search

laravel / framework

The Laravel Framework.
https://laravel.com
MIT License
32.12k stars 10.87k forks source link

Horizon Job: ErrorException: Warning: PDO::prepare(): MySQL server has gone away #28127

Closed keithbrink closed 5 years ago

keithbrink commented 5 years ago

Description:

Hey there, I am struggling with a bug on my production server using Horizon.

ErrorException: Warning: PDO::prepare(): MySQL server has gone away [internal] in unserialize

You can see a stack trace of the error here: https://sentry.io/share/issue/b105b7946b524a9e841f56f44445ea14/

As far as I can tell, this error should be caught by the Laravel framework (#19080, #19263). I'm not sure why it's not being caught and turned into a QueryException which would then trigger the reconnection and/or killing the worker.

This is an occasional error so it's difficult to reproduce; I've tried to manually throw a similar error but it is caught properly and handled properly.

Any insight into how I can fix this would be appreciated.

driesvints commented 5 years ago

Hi there,

It's best that you opened this on the Horizon issue tracker: https://github.com/laravel/horizon/issues

Also: this seems like a problem with your MySQL server which has connectivity issues. Please try asking this on a support channel:

Thanks!