Clean install via docker run with existing mysql does not populate all tables in database and fails.

[Meridiumus]

Pre-work

• I have read the docs.
• I have searched open and closed issues.
• I agree to follow this project's Code of Conduct.

Description

During a clean install and first initialization of the mysql database, the process ends in errors.

[2025-08-18 16:09:14] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speedtest_tracker.cache' doesn't exist (Connection: mariadb, SQL: select * from cachewherekeyin (laravel_cache_illuminate:queue:restart)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speedtest_tracker.cache' doesn't exist (Connection: mariadb, SQL: select * fromcachewherekey in (laravel_cache_illuminate:queue:restart)) at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:824)

Seems not to be a database connection issue, as during initialization some tables are created. The following tables are created: migrations, password_reset, telescope_entries and users.
Also the config folder created for the container is populated.

I have used the app_debug, but does not seem to give any additional info.

Speedtest Tracker.pdf

Expected Behavior

A working speedtest tracker connected to the mariadb database.

Steps to Reproduce

1. Prepared the MySQL database: created database, created user/pw with sufficient permissions.
2. Created folders for Config
3. Modified the docker run found here in the following:

docker run -d --name speedtest-tracker --restart unless-stopped \ -p 8282:80 \ -p 9443:443 \ -e PUID=1005 \ -e PGID=1002 \ -e APP_KEY=base64:+xgdWNGm63O5G+pI0jRdTVRXjv2+rvo/hGTIIAm2lzw= \ -e DB_CONNECTION=mariadb \ -e DB_HOST=192.168.202.5 \ -e DB_PORT=3307 \ -e DB_DATABASE=speedtest_tracker \ -e DB_USERNAME=speedtest_tracker \ -e DB_PASSWORD=st_tracker \ -v /share/ContainerSF/SpeedtestTracker/Config:/config \ lscr.io/linuxserver/speedtest-tracker:latest

4. After start container, the error is displayed as mentioned in the description,

Deployment Environment

Docker Run

Application Information

Creating the container on a QNAP NAS. mariadb is installed as app locally on the NAS. So not as a container. I have both mariadb 5 as mariadb 10 installed on the NAS and therefore the port is set to 3307 for mariadb 10.

What browser(s) are you seeing the problem on?

Both Chrome and Firefox

Logs

[2025-08-18 16:20:22] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speedtest_tracker.cache' doesn't exist (Connection: mariadb, SQL: select * from `cache` where `key` in (laravel_cache_illuminate:queue:restart)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speedtest_tracker.cache' doesn't exist (Connection: mariadb, SQL: select * from `cache` where `key` in (laravel_cache_illuminate:queue:restart)) at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:824)
�      
[stacktrace]
#0 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\\Database\\Connection->runQueryCallback()
#1 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(397): Illuminate\\Database\\Connection->run()
#2 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3188): Illuminate\\Database\\Connection->select()
#3 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3173): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3763): Illuminate\\Database\\Query\\Builder->{closure:Illuminate\\Database\\Query\\Builder::get():3172}()
#5 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3172): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /app/www/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php(130): Illuminate\\Database\\Query\\Builder->get()
#7 /app/www/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php(105): Illuminate\\Cache\\DatabaseStore->many()
#8 /app/www/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(119): Illuminate\\Cache\\DatabaseStore->get()
#9 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(729): Illuminate\\Cache\\Repository->get()
#10 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(139): Illuminate\\Queue\\Worker->getTimestampOfLastQueueRestart()
#11 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\\Queue\\Worker->daemon()
#12 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\\Queue\\Console\\WorkCommand->runWorker()
#13 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()
#14 /app/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#15 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure()
#16 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#17 /app/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\\Container\\BoundMethod::call()
#18 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()
#19 /app/www/vendor/symfony/console/Command/Command.php(318): Illuminate\\Console\\Command->execute()
#20 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()
#21 /app/www/vendor/symfony/console/Application.php(1092): Illuminate\\Console\\Command->run()
#22 /app/www/vendor/symfony/console/Application.php(341): Symfony\\Component\\Console\\Application->doRunCommand()
#23 /app/www/vendor/symfony/console/Application.php(192): Symfony\\Component\\Console\\Application->doRun()
#24 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()
#25 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1234): Illuminate\\Foundation\\Console\\Kernel->handle()
#26 /app/www/artisan(16): Illuminate\\Foundation\\Application->handleCommand()
#27 {main}
[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speedtest_tracker.cache' doesn't exist at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:406)
�      
[stacktrace]
#0 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(406): PDO->prepare()
#1 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(811): Illuminate\\Database\\Connection->{closure:Illuminate\\Database\\Connection::select():397}()
#2 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\\Database\\Connection->runQueryCallback()
#3 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(397): Illuminate\\Database\\Connection->run()
#4 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3188): Illuminate\\Database\\Connection->select()
#5 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3173): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3763): Illuminate\\Database\\Query\\Builder->{closure:Illuminate\\Database\\Query\\Builder::get():3172}()
#7 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3172): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /app/www/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php(130): Illuminate\\Database\\Query\\Builder->get()
#9 /app/www/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php(105): Illuminate\\Cache\\DatabaseStore->many()
#10 /app/www/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(119): Illuminate\\Cache\\DatabaseStore->get()
#11 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(729): Illuminate\\Cache\\Repository->get()
#12 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(139): Illuminate\\Queue\\Worker->getTimestampOfLastQueueRestart()
#13 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\\Queue\\Worker->daemon()
#14 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\\Queue\\Console\\WorkCommand->runWorker()
#15 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()
#16 /app/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#17 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure()
#18 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#19 /app/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\\Container\\BoundMethod::call()
#20 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()
#21 /app/www/vendor/symfony/console/Command/Command.php(318): Illuminate\\Console\\Command->execute()
#22 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()
#23 /app/www/vendor/symfony/console/Application.php(1092): Illuminate\\Console\\Command->run()
#24 /app/www/vendor/symfony/console/Application.php(341): Symfony\\Component\\Console\\Application->doRunCommand()
#25 /app/www/vendor/symfony/console/Application.php(192): Symfony\\Component\\Console\\Application->doRun()
#26 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()
#27 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1234): Illuminate\\Foundation\\Console\\Kernel->handle()
#28 /app/www/artisan(16): Illuminate\\Foundation\\Application->handleCommand()
#29 {main}
"} 
In Connection.php line 824:
                                                                               
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speedtest_tracke  
  r.cache' doesn't exist (Connection: mariadb, SQL: select * from `cache` whe  
  re `key` in (laravel_cache_illuminate:queue:restart))                        
                                                                               
In Connection.php line 406:
                                                                               
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speedtest_tracke  
  r.cache' doesn't exist

[svenvg93]

Do only thing I can think of is that something went wrong with the database connection. My suggestion would be recreate the database, and docker volume and make sure that all the database information is correct.

[Meridiumus]

Do only thing I can think of is that something went wrong with the database connection. My suggestion would be recreate the database, and docker volume and make sure that all the database information is correct.

I already did the following a couple of times without luck: Delete all tables in the database, deleted all folders/files in the config share and restart the docker volume. As tables are being created in the database and folders/files are being created in the config share, database information is correct. Did not yet recreate the database and docker volume. Will do that as next step. Thx.

[Meridiumus]

I just deleted and re-created the database on mariadb 10 (port 3007). And recreated the docker container for speedtest-tracker. No luck. Same errors. Then deleted the database on mariadb 10 and re-created the database on mariadb 5 (port 3006). And recreated the docker container for speedtest-tracker again (changed port to 3006 and had to limit userid to 16 characters). Again no luck. Only thing different now, was that only two tables (migrations and users) were created instead of four tables.

I read in another issue something about timing? That during first start of the speedtest-tracker container, the database was not setup in time and then the speedtest-tracker app also ran in errors. Could this be the case here? Is there a way to force full initialization of the database first? Anything else to look at/try?

[svenvg93]

Can you run below on the shell of the container.

cd app/www
php artisan migrate:status

If the migration did not run you can try php artisan migrate. Then we can see why it failed.

[Meridiumus]

Thx for quick response.

Output of 'php artisan migrate:status'

Migration name .................................................................................................................... Batch / Status
2014_10_12_000000_create_users_table ..................................................................................................... Pending
2014_10_12_100000_create_password_resets_table ........................................................................................... Pending
2018_08_08_100000_create_telescope_entries_table ......................................................................................... Pending
2019_08_19_000000_create_failed_jobs_table ............................................................................................... Pending
2019_12_14_000001_create_personal_access_tokens_table .................................................................................... Pending
2022_08_18_015337_create_jobs_table ...................................................................................................... Pending
2022_08_31_202106_create_results_table ................................................................................................... Pending
2022_10_20_211143_create_sessions_table .................................................................................................. Pending
2022_10_21_104903_create_settings_table .................................................................................................. Pending
2022_10_21_130121_create_influxdb_settings ............................................................................................... Pending
2022_10_24_152031_create_notifications_table ............................................................................................. Pending
2022_10_24_153150_create_database_notifications_settings ................................................................................. Pending
2022_10_24_153411_create_thresholds_settings ............................................................................................. Pending
2022_11_11_134355_create_mail_notification_settings ...................................................................................... Pending
2022_12_22_125055_create_telegram_notification_settings .................................................................................. Pending
2023_01_05_205157_create_cache_table ..................................................................................................... Pending
2023_03_06_002044_add_verify_ssl_to_influx_db_settings ................................................................................... Pending
2023_05_07_000000_rename_password_resets_table ........................................................................................... Pending
2023_09_11_144858_create_webhook_notification_settings ................................................................................... Pending
2024_02_07_173217_add_telegram_disable_notification_to_notification_settings ............................................................. Pending
2024_02_18_000050_update_locked_default_on_settings_table ................................................................................ Pending
2024_02_19_134641_create_job_batches_table ............................................................................................... Pending
2024_02_19_134706_create_imports_table ................................................................................................... Pending
2024_02_19_134707_create_exports_table ................................................................................................... Pending
2024_02_19_134708_create_failed_import_rows_table ........................................................................................ Pending
2024_02_22_144620_create_healthcheck_notification_settings ............................................................................... Pending
2024_02_22_144650_create_discord_notification_settings ................................................................................... Pending
2024_02_22_144650_create_ntfy_notification_settings ...................................................................................... Pending
2024_02_22_144650_create_slack_notification_settings ..................................................................................... Pending
2024_02_22_144654_create_gotify_notification_settings .................................................................................... Pending
2024_02_22_144680_create_pushover_notification_settings .................................................................................. Pending
2024_09_11_094357_rename_influxdb_settings ............................................................................................... Pending
2024_11_22_235011_add_benchmarks_to_results_table ........................................................................................ Pending
2024_11_23_021744_add_healthy_to_results_table ........................................................................................... Pending
2025_05_19_160458_reset_existing_api_token_abilities ..................................................................................... Pending

Output of 'php artisan migrate'

                                                                      APPLICATION IN PRODUCTION.                                                                           

┌ Are you sure you want to run this command? ──────────────────┐
│ Yes │
└──────────────────────────────────────────────────────────────┘

INFO Running migrations.

2014_10_12_000000_create_users_table ................................................................................................. 7.11ms FAIL
[2025-08-26 17:07:31] production.ERROR: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (Connection: mariadb, SQL: create table users (id bigint unsigned not null auto_increment primary key, name varchar(255) not null, email varchar(255) not null, email_verified_at timestamp null, password varchar(255) not null, remember_token varchar(100) null, role varchar(255) not null default 'user', created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci') {"exception":"[object] (Illuminate\Database\QueryException(code: 42S01): SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (Connection: mariadb, SQL: create table users (id bigint unsigned not null auto_increment primary key, name varchar(255) not null, email varchar(255) not null, email_verified_at timestamp null, password varchar(255) not null, remember_token varchar(100) null, role varchar(255) not null default 'user', created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci') at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:824)
[stacktrace]
#0 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\Database\Connection->runQueryCallback()
#1 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(559): Illuminate\Database\Connection->run()
#2 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(119): Illuminate\Database\Connection->statement()
#3 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(618): Illuminate\Database\Schema\Blueprint->build()
#4 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(472): Illuminate\Database\Schema\Builder->build()
#5 /app/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\Builder->create()
#6 /app/www/database/migrations/2014_10_12_000000_create_users_table.php(17): Illuminate\Support\Facades\Facade::__callStatic()
#7 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(514): Illuminate\Database\Migrations\Migration@anonymous->up()
#8 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(439): Illuminate\Database\Migrations\Migrator->runMethod()
#9 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(448): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runMigration():435}()
#10 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\Database\Migrations\Migrator->runMigration()
#11 /app/www/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(41): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runUp():250}()
#12 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(809): Illuminate\Console\View\Components\Task->render()
#13 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\Database\Migrations\Migrator->write()
#14 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210): Illuminate\Database\Migrations\Migrator->runUp()
#15 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(137): Illuminate\Database\Migrations\Migrator->runPending()
#16 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\Database\Migrations\Migrator->run()
#17 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(666): Illuminate\Database\Console\Migrations\MigrateCommand->{closure:Illuminate\Database\Console\Migrations\MigrateCommand::runMigrations():109}()
#18 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\Database\Migrations\Migrator->usingConnection()
#19 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#20 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#21 /app/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()
#22 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()
#23 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#24 /app/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\Container\BoundMethod::call()
#25 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call()
#26 /app/www/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#27 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\Component\Console\Command\Command->run()
#28 /app/www/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#29 /app/www/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#30 /app/www/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#31 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\Component\Console\Application->run()
#32 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1234): Illuminate\Foundation\Console\Kernel->handle()
#33 /app/www/artisan(16): Illuminate\Foundation\Application->handleCommand()
#34 {main}

[previous exception] [object] (PDOException(code: 42S01): SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:570)
[stacktrace]
#0 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(570): PDOStatement->execute()
#1 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(811): Illuminate\Database\Connection->{closure:Illuminate\Database\Connection::statement():559}()
#2 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\Database\Connection->runQueryCallback()
#3 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(559): Illuminate\Database\Connection->run()
#4 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(119): Illuminate\Database\Connection->statement()
#5 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(618): Illuminate\Database\Schema\Blueprint->build()
#6 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(472): Illuminate\Database\Schema\Builder->build()
#7 /app/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\Builder->create()
#8 /app/www/database/migrations/2014_10_12_000000_create_users_table.php(17): Illuminate\Support\Facades\Facade::__callStatic()
#9 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(514): Illuminate\Database\Migrations\Migration@anonymous->up()
#10 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(439): Illuminate\Database\Migrations\Migrator->runMethod()
#11 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(448): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runMigration():435}()
#12 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\Database\Migrations\Migrator->runMigration()
#13 /app/www/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(41): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runUp():250}()
#14 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(809): Illuminate\Console\View\Components\Task->render()
#15 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\Database\Migrations\Migrator->write()
#16 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210): Illuminate\Database\Migrations\Migrator->runUp()
#17 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(137): Illuminate\Database\Migrations\Migrator->runPending()
#18 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\Database\Migrations\Migrator->run()
#19 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(666): Illuminate\Database\Console\Migrations\MigrateCommand->{closure:Illuminate\Database\Console\Migrations\MigrateCommand::runMigrations():109}()
#20 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\Database\Migrations\Migrator->usingConnection()
#21 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#22 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#23 /app/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()
#24 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()
#25 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#26 /app/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\Container\BoundMethod::call()
#27 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call()
#28 /app/www/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#29 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\Component\Console\Command\Command->run()
#30 /app/www/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#31 /app/www/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#32 /app/www/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#33 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\Component\Console\Application->run()
#34 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1234): Illuminate\Foundation\Console\Kernel->handle()
#35 /app/www/artisan(16): Illuminate\Foundation\Application->handleCommand()
#36 {main}
"}

In Connection.php line 824:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (Connection: mariadb, SQL: create table users (id bigint unsigned not null auto_
increment primary key, name varchar(255) not null, email varchar(255) not null, email_verified_at timestamp null, password varchar(255) not null, remember_token
varchar(100) null, role varchar(255) not null default 'user', created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_
unicode_ci')

In Connection.php line 570:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists

Seems like a catch 22. As when I would clean the database first and then start the container, immediately the tables migrations and users would be created and would be in same situation. Or should I just drop the tables after starting the container and then do php artisan migrate?

[Meridiumus]

Decided just to drop the two tables and do php artisan migrate again. Result:

                                                                      APPLICATION IN PRODUCTION.                                                                           

┌ Are you sure you want to run this command? ──────────────────┐
│ Yes │
└──────────────────────────────────────────────────────────────┘

INFO Preparing database.

Creating migration table ............................................................................................................ 86.16ms DONE

INFO Running migrations.

2014_10_12_000000_create_users_table ................................................................................................ 75.21ms FAIL
[2025-08-26 17:18:45] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (Connection: mariadb, SQL: alter table users add unique users_email_unique(email)) {"exception":"[object] (Illuminate\Database\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (Connection: mariadb, SQL: alter table users add unique users_email_unique(email)) at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:824)
[stacktrace]
#0 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\Database\Connection->runQueryCallback()
#1 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(559): Illuminate\Database\Connection->run()
#2 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(119): Illuminate\Database\Connection->statement()
#3 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(618): Illuminate\Database\Schema\Blueprint->build()
#4 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(472): Illuminate\Database\Schema\Builder->build()
#5 /app/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\Builder->create()
#6 /app/www/database/migrations/2014_10_12_000000_create_users_table.php(17): Illuminate\Support\Facades\Facade::__callStatic()
#7 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(514): Illuminate\Database\Migrations\Migration@anonymous->up()
#8 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(439): Illuminate\Database\Migrations\Migrator->runMethod()
#9 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(448): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runMigration():435}()
#10 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\Database\Migrations\Migrator->runMigration()
#11 /app/www/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(41): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runUp():250}()
#12 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(809): Illuminate\Console\View\Components\Task->render()
#13 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\Database\Migrations\Migrator->write()
#14 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210): Illuminate\Database\Migrations\Migrator->runUp()
#15 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(137): Illuminate\Database\Migrations\Migrator->runPending()
#16 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\Database\Migrations\Migrator->run()
#17 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(666): Illuminate\Database\Console\Migrations\MigrateCommand->{closure:Illuminate\Database\Console\Migrations\MigrateCommand::runMigrations():109}()
#18 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\Database\Migrations\Migrator->usingConnection()
#19 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#20 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#21 /app/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()
#22 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()
#23 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#24 /app/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\Container\BoundMethod::call()
#25 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call()
#26 /app/www/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#27 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\Component\Console\Command\Command->run()
#28 /app/www/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#29 /app/www/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#30 /app/www/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#31 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\Component\Console\Application->run()
#32 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1234): Illuminate\Foundation\Console\Kernel->handle()
#33 /app/www/artisan(16): Illuminate\Foundation\Application->handleCommand()
#34 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:570)
[stacktrace]
#0 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(570): PDOStatement->execute()
#1 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(811): Illuminate\Database\Connection->{closure:Illuminate\Database\Connection::statement():559}()
#2 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\Database\Connection->runQueryCallback()
#3 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(559): Illuminate\Database\Connection->run()
#4 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(119): Illuminate\Database\Connection->statement()
#5 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(618): Illuminate\Database\Schema\Blueprint->build()
#6 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(472): Illuminate\Database\Schema\Builder->build()
#7 /app/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\Builder->create()
#8 /app/www/database/migrations/2014_10_12_000000_create_users_table.php(17): Illuminate\Support\Facades\Facade::__callStatic()
#9 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(514): Illuminate\Database\Migrations\Migration@anonymous->up()
#10 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(439): Illuminate\Database\Migrations\Migrator->runMethod()
#11 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(448): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runMigration():435}()
#12 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\Database\Migrations\Migrator->runMigration()
#13 /app/www/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(41): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runUp():250}()
#14 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(809): Illuminate\Console\View\Components\Task->render()
#15 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\Database\Migrations\Migrator->write()
#16 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210): Illuminate\Database\Migrations\Migrator->runUp()
#17 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(137): Illuminate\Database\Migrations\Migrator->runPending()
#18 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\Database\Migrations\Migrator->run()
#19 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(666): Illuminate\Database\Console\Migrations\MigrateCommand->{closure:Illuminate\Database\Console\Migrations\MigrateCommand::runMigrations():109}()
#20 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\Database\Migrations\Migrator->usingConnection()
#21 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#22 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#23 /app/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()
#24 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()
#25 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#26 /app/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\Container\BoundMethod::call()
#27 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call()
#28 /app/www/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#29 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\Component\Console\Command\Command->run()
#30 /app/www/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#31 /app/www/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#32 /app/www/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#33 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\Component\Console\Application->run()
#34 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1234): Illuminate\Foundation\Console\Kernel->handle()
#35 /app/www/artisan(16): Illuminate\Foundation\Application->handleCommand()
#36 {main}
"}

In Connection.php line 824:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (Connection: mariadb, SQL: alter table users add unique
users_email_unique(email))

In Connection.php line 570:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

Does this give more info as to why initialization fails?

[svenvg93]

Maybe, but that goes above my database knowledge. Maybe @alexjustesen does have the magic tip here.

[Meridiumus]

Just switched back to mariadb 10, as I read here the following:
[Laravel 5.4](https://laravel-news.com/laravel-5-4) made a change to the default database character set, and it’s now utf8mb4 which includes support for storing emojis. This only affects new applications and as long as you are running MySQL v5.7.7 and higher you do not need to do anything.

And now see the following as output of 'php artisan migrate:status':

Migration name .................................................................................................................... Batch / Status
2014_10_12_000000_create_users_table ..................................................................................................... [1] Ran
2014_10_12_100000_create_password_resets_table ........................................................................................... [1] Ran
2018_08_08_100000_create_telescope_entries_table ......................................................................................... Pending
2019_08_19_000000_create_failed_jobs_table ............................................................................................... Pending
2019_12_14_000001_create_personal_access_tokens_table .................................................................................... Pending
2022_08_18_015337_create_jobs_table ...................................................................................................... Pending
2022_08_31_202106_create_results_table ................................................................................................... Pending
2022_10_20_211143_create_sessions_table .................................................................................................. Pending
2022_10_21_104903_create_settings_table .................................................................................................. Pending
2022_10_21_130121_create_influxdb_settings ............................................................................................... Pending
2022_10_24_152031_create_notifications_table ............................................................................................. Pending
2022_10_24_153150_create_database_notifications_settings ................................................................................. Pending
2022_10_24_153411_create_thresholds_settings ............................................................................................. Pending
2022_11_11_134355_create_mail_notification_settings ...................................................................................... Pending
2022_12_22_125055_create_telegram_notification_settings .................................................................................. Pending
2023_01_05_205157_create_cache_table ..................................................................................................... Pending
2023_03_06_002044_add_verify_ssl_to_influx_db_settings ................................................................................... Pending
2023_05_07_000000_rename_password_resets_table ........................................................................................... Pending
2023_09_11_144858_create_webhook_notification_settings ................................................................................... Pending
2024_02_07_173217_add_telegram_disable_notification_to_notification_settings ............................................................. Pending
2024_02_18_000050_update_locked_default_on_settings_table ................................................................................ Pending
2024_02_19_134641_create_job_batches_table ............................................................................................... Pending
2024_02_19_134706_create_imports_table ................................................................................................... Pending
2024_02_19_134707_create_exports_table ................................................................................................... Pending
2024_02_19_134708_create_failed_import_rows_table ........................................................................................ Pending
2024_02_22_144620_create_healthcheck_notification_settings ............................................................................... Pending
2024_02_22_144650_create_discord_notification_settings ................................................................................... Pending
2024_02_22_144650_create_ntfy_notification_settings ...................................................................................... Pending
2024_02_22_144650_create_slack_notification_settings ..................................................................................... Pending
2024_02_22_144654_create_gotify_notification_settings .................................................................................... Pending
2024_02_22_144680_create_pushover_notification_settings .................................................................................. Pending
2024_09_11_094357_rename_influxdb_settings ............................................................................................... Pending
2024_11_22_235011_add_benchmarks_to_results_table ........................................................................................ Pending
2024_11_23_021744_add_healthy_to_results_table ........................................................................................... Pending
2025_05_19_160458_reset_existing_api_token_abilities ..................................................................................... Pending

So now there seems no issue in creating the users table. Will now check again with php artisan migrate if I can see now where the initialization aborts.

[Meridiumus]

Result of php artisan migrate on mariadb 10:

                                                                      APPLICATION IN PRODUCTION.                                                                           

┌ Are you sure you want to run this command? ──────────────────┐
│ Yes │
└──────────────────────────────────────────────────────────────┘

INFO Preparing database.

Creating migration table ........................................................................................................... 157.06ms DONE

INFO Running migrations.

2014_10_12_000000_create_users_table ............................................................................................... 593.05ms DONE
2014_10_12_100000_create_password_resets_table ..................................................................................... 455.20ms DONE
2018_08_08_100000_create_telescope_entries_table ......................................................................................... 1s FAIL
[2025-08-26 19:00:16] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (Connection: mariadb, SQL: create table telescope_entries_tags (entry_uuid char(36) not null, tag varchar(255) not null, primary key (entry_uuid, tag)) default character set utf8mb4 collate 'utf8mb4_unicode_ci') {"exception":"[object] (Illuminate\Database\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (Connection: mariadb, SQL: create table telescope_entries_tags (entry_uuid char(36) not null, tag varchar(255) not null, primary key (entry_uuid, tag)) default character set utf8mb4 collate 'utf8mb4_unicode_ci') at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:824)
[stacktrace]
#0 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\Database\Connection->runQueryCallback()
#1 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(559): Illuminate\Database\Connection->run()
#2 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(119): Illuminate\Database\Connection->statement()
#3 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(618): Illuminate\Database\Schema\Blueprint->build()
#4 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(472): Illuminate\Database\Schema\Builder->build()
#5 /app/www/database/migrations/2018_08_08_100000_create_telescope_entries_table.php(41): Illuminate\Database\Schema\Builder->create()
#6 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(514): Illuminate\Database\Migrations\Migration@anonymous->up()
#7 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(439): Illuminate\Database\Migrations\Migrator->runMethod()
#8 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(448): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runMigration():435}()
#9 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\Database\Migrations\Migrator->runMigration()
#10 /app/www/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(41): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runUp():250}()
#11 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(809): Illuminate\Console\View\Components\Task->render()
#12 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\Database\Migrations\Migrator->write()
#13 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210): Illuminate\Database\Migrations\Migrator->runUp()
#14 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(137): Illuminate\Database\Migrations\Migrator->runPending()
#15 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\Database\Migrations\Migrator->run()
#16 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(666): Illuminate\Database\Console\Migrations\MigrateCommand->{closure:Illuminate\Database\Console\Migrations\MigrateCommand::runMigrations():109}()
#17 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\Database\Migrations\Migrator->usingConnection()
#18 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#19 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#20 /app/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()
#21 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()
#22 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#23 /app/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\Container\BoundMethod::call()
#24 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call()
#25 /app/www/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#26 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\Component\Console\Command\Command->run()
#27 /app/www/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#28 /app/www/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#29 /app/www/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#30 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\Component\Console\Application->run()
#31 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1234): Illuminate\Foundation\Console\Kernel->handle()
#32 /app/www/artisan(16): Illuminate\Foundation\Application->handleCommand()
#33 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:570)
[stacktrace]
#0 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(570): PDOStatement->execute()
#1 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(811): Illuminate\Database\Connection->{closure:Illuminate\Database\Connection::statement():559}()
#2 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\Database\Connection->runQueryCallback()
#3 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(559): Illuminate\Database\Connection->run()
#4 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(119): Illuminate\Database\Connection->statement()
#5 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(618): Illuminate\Database\Schema\Blueprint->build()
#6 /app/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(472): Illuminate\Database\Schema\Builder->build()
#7 /app/www/database/migrations/2018_08_08_100000_create_telescope_entries_table.php(41): Illuminate\Database\Schema\Builder->create()
#8 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(514): Illuminate\Database\Migrations\Migration@anonymous->up()
#9 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(439): Illuminate\Database\Migrations\Migrator->runMethod()
#10 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(448): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runMigration():435}()
#11 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\Database\Migrations\Migrator->runMigration()
#12 /app/www/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(41): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runUp():250}()
#13 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(809): Illuminate\Console\View\Components\Task->render()
#14 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(250): Illuminate\Database\Migrations\Migrator->write()
#15 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210): Illuminate\Database\Migrations\Migrator->runUp()
#16 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(137): Illuminate\Database\Migrations\Migrator->runPending()
#17 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\Database\Migrations\Migrator->run()
#18 /app/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(666): Illuminate\Database\Console\Migrations\MigrateCommand->{closure:Illuminate\Database\Console\Migrations\MigrateCommand::runMigrations():109}()
#19 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\Database\Migrations\Migrator->usingConnection()
#20 /app/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#21 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#22 /app/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()
#23 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()
#24 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#25 /app/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\Container\BoundMethod::call()
#26 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call()
#27 /app/www/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#28 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\Component\Console\Command\Command->run()
#29 /app/www/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#30 /app/www/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#31 /app/www/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#32 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\Component\Console\Application->run()
#33 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1234): Illuminate\Foundation\Console\Kernel->handle()
#34 /app/www/artisan(16): Illuminate\Foundation\Application->handleCommand()
#35 {main}
"}

In Connection.php line 824:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (Connection: mariadb, SQL: create table telescope_entrie s_tags (entry_uuid char(36) not null, tag varchar(255) not null, primary key (entry_uuid, tag)) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

In Connection.php line 570:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

So similar error, but now on table 'telescope_entries_tags'.

[alexjustesen]

I suggest taking a back up of your results table, you can do this with DBeaver or another DB IDE. After that I would start over fresh with new volumes/drives and import your results back to the table once the new setup is running.

Seems something went wrong during all the migrations/switching of containers and it's going to be pretty hard for us to track down.

[Meridiumus]

I suggest taking a back up of your results table, you can do this with DBeaver or another DB IDE. After that I would start over fresh with new volumes/drives and import your results back to the table once the new setup is running.

Seems something went wrong during all the migrations/switching of containers and it's going to be pretty hard for us to track down.

Hello @alexjustesen, I get the impression you think I had a previously working speedtest-tracker container. This is not the case. I am trying to do a clean/new install, as I have not used speedtest-tracker before. So totally new mariadb database with clean config share and recreated speedtest-tracker container.