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.

[alexjustesen]

The way it was worded sounded like you had an existing instance working.

That being said it sounds more like Speedtest Tracker can't access the database instance. Since you're connecting to the DB by it's host IP and port let's change a couple of things...

1. Set the CACHE_STORE to session file to bypass the cache table. (restart the app container when you're doing this)
2. Delete and recreate the database so that no tables exist, the migrations want to run in a synchronous order to ensure the state is correct.

[Meridiumus]

@alexjustesen Actually, Speedtest Tracker can access the databaase as tables migrations, password_reset, telescope_entries and users are being created when connected to mariadb 10 (port 3007). Then the initialization aborts with the error mentioned in my initial comment.

Anyhow, I added the environment parameter CACHE_STORE with session as value. Deleted and recreated the database. And recreated the container. Then get the following error:

[2025-08-28 10:51:00] production.ERROR: Cache store [session] is not defined. {"exception":"[object] (InvalidArgumentException(code: 0): Cache store [session] is not defined. at /app/www/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:106)

Or did I interpret the session value to literally and you meant something else?

[alexjustesen]

Sorry I meant file should be the driver, we want to take the cache out of the picture to see if we can identify what's going on at the DB layer.

[Meridiumus]

Sorry to say, but still no luck...

[2025-08-30 12:13:34] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speedtesttracker.jobs' doesn't exist (Connection: mariadb, SQL: select * from jobs where queue = default and ((reserved_at is null and available_at <= 1756556014) or (reserved_at <= 1756555924)) order by id asc limit 1 for update) {"exception":"[object] (Illuminate\Database\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speedtesttracker.jobs' doesn't exist (Connection: mariadb, SQL: select * from jobs where queue = default and ((reserved_at is null and available_at <= 1756556014) or (reserved_at <= 1756555924)) order by id asc limit 1 for update) at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:824)

Still only tables migrations, password_reset, telescope_entries and users are being created.

[alexjustesen]

Instead of Docker run, can you use composer and setup a new DB within the stack? I'm thinking there is some incompatibility with your existing instance.

[Meridiumus]

Will use docker composer and will get back here with the outcome.

[Meridiumus]

Tried the following docker composer. Took it from the docs.speedtest-tracker.dev site and modified it a bit.

services:
speedtest-tracker:
image: lscr.io/linuxserver/speedtest-tracker:latest
restart: unless-stopped
container_name: speedtest-tracker-1
ports:
- 8383:80
- 7443:443
environment:
- PUID=1005
- PGID=1002
- APP_KEY=base64:+xgdWNGm63O5G+pI0jRdTVRXjv2+rvo/hGTIIAm2lzw=
- DB_CONNECTION=mariadb
- DB_HOST=db
- DB_PORT=3306
- DB_DATABASE=speedtesttracker
- DB_USERNAME=speedtesttracker
- DB_PASSWORD=st_tracker
volumes:
- /share/ContainerSF/SpeedtestTracker1/Config:/config
networks:
bridge-1:
depends_on:
- db
db:
image: mariadb:11
restart: always
ports:
- 3308:3306
environment:
- MYSQL_DATABASE=speedtesttracker
- MYSQL_USER=speedtesttracker
- MYSQL_PASSWORD=st_tracker
- MYSQL_RANDOM_ROOT_PASSWORD=true
volumes:
- speedtest-db:/var/lib/mysql
networks:
bridge-1:
healthcheck:
test: ["CMD", "healthcheck.sh", "--connect", "--innodb_initialized"]
interval: 5s
retries: 3
timeout: 5s
volumes:
speedtest-db:
networks:
bridge-1:
external: true

But still have issues.

[2025-09-02 20:26:28] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speedtesttracker.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 'speedtesttracker.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)

Did not have the time to do some more analysis. Will do that next week due to a short vacation.

[Meridiumus]

Did some more analysis by adding a myphpadmin container.

services:
speedtest-tracker:
image: lscr.io/linuxserver/speedtest-tracker:latest
restart: unless-stopped
container_name: speedtest-tracker-1
ports:
- 8383:80
- 7443:443
environment:
- PUID=1005
- PGID=1002
- APP_KEY=base64:+xgdWNGm63O5G+pI0jRdTVRXjv2+rvo/hGTIIAm2lzw=
- DB_CONNECTION=mariadb
- DB_HOST=db
- DB_PORT=3306
- DB_DATABASE=speedtesttracker
- DB_USERNAME=speedtesttracker
- DB_PASSWORD=st_tracker
- SPEEDTEST_SCHEDULE=6 */2 * * *
- SPEEDTEST_SERVERS=24887
volumes:
- /share/ContainerSF/SpeedtestTracker1/Config:/config
networks:
bridge-1:
depends_on:
- db
db:
image: mariadb:11
restart: always
ports:
- 3308:3306
environment:
- MYSQL_DATABASE=speedtesttracker
- MYSQL_USER=speedtesttracker
- MYSQL_PASSWORD=st_tracker
- MYSQL_RANDOM_ROOT_PASSWORD=true
volumes:
- speedtest-db:/var/lib/mysql
networks:
bridge-1:
healthcheck:
test: ["CMD", "healthcheck.sh", "--connect", "--innodb_initialized"]
interval: 5s
retries: 3
timeout: 5s
phpmyadmin:
image: phpmyadmin/phpmyadmin
restart: always
container_name: dev_pma
ports:
- 8183:80
links:
- db
environment:
- PMA_HOST=mysql
- PMA_PORT=3306
- PMA_ARBITRARY=1
networks:
bridge-1:
volumes:
speedtest-db:
networks:
bridge-1:
external: true

Somehow, the mariadb database was not initialize at all. No table created. Then executed 'php artisan migrate' and immediately started initializing and created tables in the mariadb database. After that I could successfully start the Speedtest Tracker site. So the common behavior with my earlier attempt to get it working is that the initialization process does needs attention.

Next step is doing the same with mariadb 10. To see if the issues I experienced is specifically with mariadb 10 in general or the specific implementation of mariadb10 on my qnap.

[JMerrell5468]

Thank you Meridiumus. Your instructions got me running on my QNAP.

[Meridiumus]

I just used same docker compose, but for MariaDB 10. And same issue as I had with the docker compose for MariaDB 11. But could not reproduce the issue with the MariaDB 10 app on QNAP. However then saw a difference in storage engine. Apparently, by default the storage engine is InnoDB with the MariaDB created containers. On the MariaDB 10 app on my QNAP, I noticed the default storage engine to be MyISAM. No idea why. I changed the default to InnoDB, and now could initialize the MariaDB database via 'php artisan migrate' and got the speedtest-tracker working using the MariaDB 10 app database on my QNAP. Hope this helps others.

Still remains then, why tables are not initialized after running the docker compose as displayed above (Sep 13).

[alexjustesen]

I'm going to move this over to a discussion, as far as we can tell it's nothing specific with Speedtest Tracker so hopefully someone in the community can help.