MySQL Bugs: #21606: MySQL restart causes hang/connection issues

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:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.22	OS:	FreeBSD (FreeBSD 5.4)
Assigned to:		CPU Architecture:	Any

Description:
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.

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)?

I have upgraded to 5.0.24, and it seems to have fixed the issue. Will keep watching it though.

Closed as not repeatable on 5.0.24, it seems.