Bug #21606 MySQL restart causes hang/connection issues
Submitted: 12 Aug 2006 19:05 Modified: 15 Sep 2006 7:54
Reporter: Danny Swett Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.22 OS:FreeBSD (FreeBSD 5.4)
Assigned to: CPU Architecture:Any

[12 Aug 2006 19:05] Danny Swett
I am using MySQL 5.0.22 on freebsd 5.4 with linuxthreads, currently.

I first notices this issue 5.0.18

When I restart mysql in freebsd, using the supplied shell scripts (/usr/local/etc/rc.d)
It will shut down correctly. And then start back up just fine.

If the time between shutdown/startup wasn't enough for all the connected clients to notice and kill off the tcp connections, then the old tcp connections will flood mysql with unauth connections, and end up using all threads.

If you than attempt to shutdown mysql, all threads that don't have unauth connections on them will shutdown fine. But the unauth threads will stay, and can only be killed using kill -KILL.

If I leave the db server down for 5+min before starting it back up, no issues.

I really perfer not to shut down the db server for so many minutes though.

How to repeat:
explained above.
[26 Aug 2006 11:10] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.24, and inform about the results. Is it possible for you to test on FreeBSD 6.x (we have no 5.4 boxes easily available)?
[14 Sep 2006 14:27] Danny Swett
I have upgraded to 5.0.24, and it seems to have fixed the issue. Will keep watching it though.
[15 Sep 2006 7:54] Valeriy Kravchuk
Closed as not repeatable on 5.0.24, it seems.