One more note about [mysql] not configured error.

It seems if configuration cached and cache has default expiration value, such thing may happen for long-term idle queues. After the start queue working fine but some time later you start getting errors like specified below. Is it possible?

production.ERROR: Database connection [mysql] not configured. {"exception":"[object] (InvalidArgumentException(code: 0): Database connection [mysql] not configured. at /var/www/application/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php:152)
[stacktrace]
#0 /var/www/application/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(115): Illuminate\Database\DatabaseManager->configuration()
#1 /var/www/application/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(274): Illuminate\Database\DatabaseManager->makeConnection()
#2 /var/www/application/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(245): Illuminate\Database\DatabaseManager->refreshPdoConnections()
#3 /var/www/application/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(65): Illuminate\Database\DatabaseManager->reconnect()
#4 [internal function]: Illuminate\Database\DatabaseManager->Illuminate\Database\{closure}()
#5 /var/www/application/vendor/laravel/framework/src/Illuminate/Database/Connection.php(763): call_user_func()
#6 /var/www/application/vendor/laravel/framework/src/Illuminate/Database/Connection.php(777): Illuminate\Database\Connection->reconnect()
#7 /var/www/application/vendor/laravel/framework/src/Illuminate/Database/Connection.php(623): Illuminate\Database\Connection->reconnectIfMissingConnection()
#8 /var/www/application/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run()
#9 /var/www/application/vendor/laravel/framework/src/Illuminate/Database/Connection.php(417): Illuminate\Database\Connection->statement()
#10 /var/www/application/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert()
#11 /var/www/application/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2839): Illuminate\Database\Query\Processors\Processor->processInsertGetId()
#12 /var/www/application/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseFailedJobProvider.php(62): Illuminate\Database\Query\Builder->insertGetId()
#13 /var/www/application/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(200): Illuminate\Queue\Failed\DatabaseFailedJobProvider->log()
#14 /var/www/application/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(149): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#15 /var/www/application/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(381): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#16 /var/www/application/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(226): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#17 /var/www/application/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#18 /var/www/application/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(498): Illuminate\Queue\Jobs\Job->fail()
#
...

Snapey

3 years ago

Level 122

no, config cache does not expire. what queue driver is it ?

pvasilek

3 years ago

Level 1

Thank you for the reply. By default, QUEUE_CONNECTION=redis-sentinel Also, previously I met the similar behavior with database default driver as well in laravel 5.7-5.8. It happens only when a queue has rare tasks. For example, once per day. By the logs above, failed_jobs exists only in database space, so it fails trying to reconnect mysql. systemctl restart ... fix the situation but it is a bit annoying because requires reschedule for the lost tasks. DB is definitely configured and working well.

> config('queue.failed');
= [
    "driver" => "database",
    "database" => "mysql",
    "table" => "failed_jobs",
  ]

> config('database.connections.mysql');
= [
    "driver" => "mysql",
    "url" => null,
    "host" => "...",
    "port" => "3306",
    "database" => "...",
    "username" => "...",
    "password" => "...",
    "unix_socket" => "",
    "charset" => "utf8mb4",
    "collation" => "utf8mb4_unicode_ci",
    "prefix" => "",
    "prefix_indexes" => true,
    "strict" => false,
    "engine" => null,
    "options" => [
      1009 => ".../rds-combined-ca-bundle.pem",
      1014 => false,
    ],
  ]

Please or to participate in this conversation.