[2024-07-22 12:10:01] local.ERROR: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: select * from `jobs` where `queue` = default and ((`reserved_at` is null and `available_at` <= 1721617800) or (`reserved_at` <= 1721617710)) order by `id` asc limit 1 for update) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: select * from `jobs` where `queue` = default and ((`reserved_at` is null and `available_at` <= 1721617800) or (`reserved_at` <= 1721617710)) order by `id` asc limit 1 for update) at /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712) [stacktrace] #0 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select * from `...', Array, Object(Closure)) #1 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\\Database\\Connection->run('select * from `...', Array, Object(Closure)) #2 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2414): Illuminate\\Database\\Connection->select('select * from `...', Array, false) #3 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #4 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2403): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(294): Illuminate\\Database\\Query\\Builder->get(Array) #7 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(242): Illuminate\\Database\\Query\\Builder->first() #8 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(220): Illuminate\\Queue\\DatabaseQueue->getNextAvailableJob('default') #9 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(29): Illuminate\\Queue\\DatabaseQueue->Illuminate\\Queue\\{closure}(Object(Illuminate\\Database\\MySqlConnection)) #10 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(223): Illuminate\\Database\\Connection->transaction(Object(Closure)) #11 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(345): Illuminate\\Queue\\DatabaseQueue->pop('default') #12 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(354): Illuminate\\Queue\\Worker->Illuminate\\Queue\\{closure}('default') #13 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(159): Illuminate\\Queue\\Worker->getNextJob(Object(Illuminate\\Queue\\DatabaseQueue), 'default') #14 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon('database', 'high,low,defaul...', Object(Illuminate\\Queue\\WorkerOptions)) #15 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker('database', 'high,low,defaul...') #16 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle() #17 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #18 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #19 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure)) #20 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL) #21 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array) #22 /var/www/html/spaceagent/micadolayout-access/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #23 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #24 /var/www/html/spaceagent/micadolayout-access/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #25 /var/www/html/spaceagent/micadolayout-access/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #26 /var/www/html/spaceagent/micadolayout-access/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #27 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #28 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #29 /var/www/html/spaceagent/micadolayout-access/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #30 {main} [previous exception] [object] (PDOException(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Connection.php:373) [stacktrace] #0 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): PDOStatement->execute() #1 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select * from `...', Array) #2 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select * from `...', Array, Object(Closure)) #3 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\\Database\\Connection->run('select * from `...', Array, Object(Closure)) #4 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2414): Illuminate\\Database\\Connection->select('select * from `...', Array, false) #5 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #6 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2403): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(294): Illuminate\\Database\\Query\\Builder->get(Array) #9 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(242): Illuminate\\Database\\Query\\Builder->first() #10 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(220): Illuminate\\Queue\\DatabaseQueue->getNextAvailableJob('default') #11 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(29): Illuminate\\Queue\\DatabaseQueue->Illuminate\\Queue\\{closure}(Object(Illuminate\\Database\\MySqlConnection)) #12 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(223): Illuminate\\Database\\Connection->transaction(Object(Closure)) #13 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(345): Illuminate\\Queue\\DatabaseQueue->pop('default') #14 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(354): Illuminate\\Queue\\Worker->Illuminate\\Queue\\{closure}('default') #15 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(159): Illuminate\\Queue\\Worker->getNextJob(Object(Illuminate\\Queue\\DatabaseQueue), 'default') #16 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon('database', 'high,low,defaul...', Object(Illuminate\\Queue\\WorkerOptions)) #17 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker('database', 'high,low,defaul...') #18 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle() #19 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #20 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #21 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure)) #22 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL) #23 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array) #24 /var/www/html/spaceagent/micadolayout-access/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #25 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #26 /var/www/html/spaceagent/micadolayout-access/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #27 /var/www/html/spaceagent/micadolayout-access/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #28 /var/www/html/spaceagent/micadolayout-access/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #29 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #30 /var/www/html/spaceagent/micadolayout-access/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #31 /var/www/html/spaceagent/micadolayout-access/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #32 {main} "}