[Dovecot] MySQL server has gone away

[Timo Sirainen]

On 20.1.2012, at 19.16, Timo Sirainen wrote:

> This is fixed in v2.1 hg. The default idle_kill of 60 seconds seems to have gotten rid of the "MySQL server has gone away" errors completely. So I guess the problem was that during some peak times a ton of auth worker processes were created, but afterwards they weren't used until the next peak happened, and then they failed.

Hmh. Still doesn't work 100%:

auth-worker(28788): Error: mysql: Query failed, retrying: MySQL server has gone away (idled for 181 secs)
auth-worker(7413): Error: mysql: Query failed, retrying: MySQL server has gone away (idled for 298 secs)

I'm not really sure why it's not killing itself after 60 seconds of idling. Probably related to how mysql code tracks idle time and how idle_kill tracks it.. Anyway, those errors are much more rare now.