https://bugzilla.novell.com/show_bug.cgi?id=332530#c3 Michal Marek changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO Info Provider| |gtsm@gandalfsemporium.homelinux.com --- Comment #3 from Michal Marek 2007-10-11 04:27:49 MST --- Lars Rupp> for me it looks like

mysql has problems with open connections during an update of the binary.

Good point. Graham, was it a loaded mysql server in your case? It could be that the _shutdown_ doesn't wait and then the start finds the old mysqld instance still blocking the sockets.

I think the problem is in the init script around the wait_for_socket() function. Perhaps you can encapsulate the call of mysqld and the wait_for_socket() function in a simple loop (I think two turns of this loop are enough as all problems are gone after a second start).

Hmm, interesting idea, I have to think what would happen if the script manages to start two mysqlds... Hopefully the slower one would just abort.

Or increase the time in wait_for_socket() ? Fedora waits 30 seconds f.e.

10.3 also has 30 seconds. Maybe we should do that in 10.2 as well. I'm still wondering why exactly 10.2 has the problem. It must be something with the mysql_upgrade call in the rc script, because that's eg. the only difference between 10.1 / SLES10 mysql and 10.2 mysql. Thanks for your input Lars ;-) -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332530#c5 Michal Marek changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED --- Comment #5 from Michal Marek 2007-10-19 09:03:01 MST --- (In reply to comment #3 from Michal Marek)

Lars Rupp> for me it looks like

...

mysql has problems with open connections during an update of the binary.

Good point. Graham, was it a loaded mysql server in your case? It could be that the _shutdown_ doesn't wait and then the start finds the old mysqld instance still blocking the sockets.

I tried loading the server, but that didn't trigger the bug. And the init script does wait for the shutdown to complete, so the bug might be somewhere else... -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332530 User gtsm@gandalfsemporium.homelinux.com added comment https://bugzilla.novell.com/show_bug.cgi?id=332530#c7 Graham Smith changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |gtsm@gandalfsemporium.homelinux.com --- Comment #7 from Graham Smith 2008-02-22 02:57:00 MST --- IIRC I used Yast and the normal YOU update, but this was some time ago. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332530 User lrupp@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=332530#c10 --- Comment #10 from Lars Vogdt 2008-05-06 04:28:13 MST --- Some new information: looks like the "non starting mysql" daemon is reproducable not only during rpm update. Looks like this sometimes(!?) also happens when the database has run a few days without restart. Two of my development databases are not really optimized (indexes missing, 25 k created tmp disk tables, ...) - perhaps this is one of the reasons why a simple "rcmysql restart" doesn't work. Calling the command a second time starts the mysqld. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332530 User lrupp@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=332530#c12 Lars Vogdt changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW Info Provider|lrupp@novell.com | --- Comment #12 from Lars Vogdt 2008-05-06 08:21:34 MST --- Created an attachment (id=212728) --> (https://bugzilla.novell.com/attachment.cgi?id=212728) strace of mysqld (5.0.45-22.2) restart on openSUSE 10.2 x86_64 First: nothing interesting in /var/lib/mysql/mysqld.log* Find attached the strace output. But this time mysqld restarts successfully :-/ I'll attach a new output if mysqld hangs again. Perhaps the daemon has to run for a while... -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332530 User mmarek@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=332530#c15 Michal Marek changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED --- Comment #15 from Michal Marek 2008-06-05 05:47:13 MDT --- I submitted a package with this change: Thu May 29 22:14:19 CEST 2008 - mmarek@suse.cz - fixed rcmysql status and rcmysql start to check for the pid file, not just a mysqld process, which can be an old mysqld instance that is about to exit (bnc#359522, bnc#332530) If the bug still appears after the next update, please reopen. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.