[2015-07-27 18:29:50] product.ERROR: exception 'RuntimeException' with message 'Can't swap PDO instance while within transaction.' in /data/lightning5/vendor/laravel/framework/src/Illuminate/Database/Connection.php:849
Stack trace:
#0 /data/lightning5/vendor/laravel/framework/src/Illuminate/Database/Connection.php(685): Illuminate\Database\Connection->setPdo(NULL)
#1 /data/lightning5/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(113): Illuminate\Database\Connection->disconnect()
#2 /data/lightning5/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(125): Illuminate\Database\DatabaseManager->disconnect('mysql')
#3 /data/lightning5/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(196): Illuminate\Database\DatabaseManager->reconnect('mysql')
#4 [internal function]: Illuminate\Database\DatabaseManager->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection))
#5 /data/lightning5/vendor/laravel/framework/src/Illuminate/Database/Connection.php(698): call_user_func(Object(Closure), Object(Illuminate\Database\MySqlConnection))
#6 /data/lightning5/vendor/laravel/framework/src/Illuminate/Database/Connection.php(653): Illuminate\Database\Connection->reconnect()
#7 /data/lightning5/vendor/laravel/framework/src/Illuminate/Database/Connection.php(595): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection(Object(Illuminate\Database\QueryException), 'insert into `qu...', Array, Object(Closure))
#8 /data/lightning5/vendor/laravel/framework/src/Illuminate/Database/Connection.php(381): Illuminate\Database\Connection->run('insert into `qu...', Array, Object(Closure))
#9 /data/lightning5/vendor/laravel/framework/src/Illuminate/Database/Connection.php(337): Illuminate\Database\Connection->statement('insert into `qu...', Array)
#10 /data/lightning5/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1710): Illuminate\Database\Connection->insert('insert into `qu...', Array)
#11 /data/lightning5/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseFailedJobProvider.php(58): Illuminate\Database\Query\Builder->insert(Array)
#12 /data/lightning5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(227): Illuminate\Queue\Failed\DatabaseFailedJobProvider->log('redis', 'task', '{"job":"Illumin...')
#13 /data/lightning5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(195): Illuminate\Queue\Worker->logFailedJob('redis', Object(Illuminate\Queue\Jobs\RedisJob))
#14 /data/lightning5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(153): Illuminate\Queue\Worker->process('redis', Object(Illuminate\Queue\Jobs\RedisJob), '5', 0)
#15 /data/lightning5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(109): Illuminate\Queue\Worker->pop(NULL, 'task', 0, '1', '5')
#16 /data/lightning5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(85): Illuminate\Queue\Worker->runNextJobForDaemon(NULL, 'task', 0, '1', '5')
#17 /data/lightning5/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(103): Illuminate\Queue\Worker->daemon(NULL, 'task', 0, 128, '1', '5')
#18 /data/lightning5/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(71): Illuminate\Queue\Console\WorkCommand->runWorker(NULL, 'task', 0, 128, true)
#19 [internal function]: Illuminate\Queue\Console\WorkCommand->fire()
#20 /data/lightning5/vendor/laravel/framework/src/Illuminate/Container/Container.php(502): call_user_func_array(Array, Array)
#21 /data/lightning5/vendor/laravel/framework/src/Illuminate/Console/Command.php(149): Illuminate\Container\Container->call(Array)
#22 /data/lightning5/vendor/symfony/console/Command/Command.php(259): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#23 /data/lightning5/vendor/laravel/framework/src/Illuminate/Console/Command.php(135): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#24 /data/lightning5/vendor/symfony/console/Application.php(878): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#25 /data/lightning5/vendor/symfony/console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(Illuminate\Queue\Console\WorkCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#26 /data/lightning5/vendor/symfony/console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#27 /data/lightning5/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(98): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#28 /data/lightning5/artisan(30): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#29 {main}
"artisan queue:work --daemon --sleep=1 --tries=10 --queue=issue" i use at console. maybe long time run. i dont know .
and then ,i get so many failed job in database . i check the log , found so many error message like this.
and then ,i get so many failed job in database . i check the log , found so many error message like this.
exception 'RuntimeException' with message 'Can't swap PDO instance while within transaction.' in /data/lightning5/vendor/laravel/framework/src/Illuminate/Database/Connection.php:854
php /data/lightning5/app/../artisan queue:work --daemon --sleep=1 --tries=5 --queue=task
I add DB::reconnect();
in the first line in handle method, and it's solved.
Like:
public function handle() {
DB::reconnect();
}
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community