[Dbix-class] lost connection during query

[Tim Sweetman]

J.G.Konrad wrote:

> I was wondering if anyone had experience with this type of error, "DBI 
> Exception: DBD::mysql::st execute failed: Lost connection to MySQL 
> server during query" while using DBIx::Class ? 
>
> our MySQL server was getting swamped with too many connections so I 
> changed the wait_timeout to 30 seconds rather then the default of 
> 28800 seconds.  In previous post that I read there is reconnecting 
> behavior and this should work.  That is, if the connection is gone ( 
> timed  out ) , DBIx::Class will reconnect. Am I hitting some kind of 
> race condition with the reconnection behavior?

You might want to check the logs of your mysql server. Lost connection 
suggests the server may have died and restarted.

Tim