jpral
5 years ago
2771
18
Laravel

Error while sending STMT_PREPARE packet on queued jobs

Posted 5 years ago by jpral

Hi there, I have couple of queued jobs connecting to AWS to do some tasks with videos: upload, then re-encode in a couple of formats, and finally moving between buckets. After that I need to save some details in the local mysql database, but as soon as the process takes a bit longer than usual, I keep getting errors with the database:

[2015-07-24 14:44:37] production.ERROR: exception 'ErrorException' with message 'Error while sending STMT_PREPARE packet. PID=1759' in /home/inetwork/public_html/aws/vendor/laravel/framework/src/Illuminate/Database/Connection.php:310
Stack trace:
#0 [internal function]: Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(2, 'Error while sen...', '/home/inetwork/...', 310, Array)
#1 /home/inetwork/public_html/aws/vendor/laravel/framework/src/Illuminate/Database/Connection.php(310): PDO->prepare('select * from `...')
#2 /home/inetwork/public_html/aws/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'select * from `...', Array)

I've looked around for that STMP_PREPARE error and it looks like it's often related to the DB connection to be timed out but I am not sure how to tackle this issue. Any ideas?

Please sign in or create an account to participate in this conversation.