Laravel Horizon: ErrorException: Warning: PDO::prepare(): MySQL server has gone away

Are you followed this answer ? https://stackoverflow.com/questions/35036547/mysql-server-has-gone-away-error-during-installing-migration-laravel

Thanks for your reply. I've researched MySQL connection errors extensively, and there are a couple reasons they are not applicable to this case:

1. The Laravel framework is specifically coded to reconnect when the MySQL connection is dropped. See my original post for links.

2. The queue is a long-running process, and no matter how long I set my MySQL timeout, the queue will eventually be alive for longer than that. There should be a mechanism within the queue to handle these, and in fact, there is, but for whatever reason it is not being triggered occasionally.

Hi @keithbrink, did you resolve this issue? I'm getting the same issue now

This was discussed fairly extensively here: https://github.com/laravel/horizon/issues/583

There's no official resolution but others put in some helpful ideas that you may find useful.

@keithbrink, did you resolve this ?

I tried following code in AppServiceProvide.php but still not working!

public function boot() {
    Queue::failing(function(JobFailed $event) {
        $entityManager = new EntityManager();
        $entityManager->getConnection()->close()
    });
    Queue::after(function(JobProcessed $event) {
        $entityManager = new EntityManager();
        $entityManager->getConnection()->close()
    });
}