[Bug 332530] New: MySQL fails to reload after security update error from YOU
https://bugzilla.novell.com/show_bug.cgi?id=332530 Summary: MySQL fails to reload after security update error from YOU Product: openSUSE 10.2 Version: Final Platform: 64bit OS/Version: openSUSE 10.2 Status: NEW Severity: Normal Priority: P5 - None Component: Other AssignedTo: mmarek@novell.com ReportedBy: gtsm@gandalfsemporium.homelinux.com QAContact: qa@suse.de Found By: Customer Report Requested by Michal Marek When MySQL security update applied by YOU MySQL fails to reload. Restart with rcmysql restart generates a duplicate column error and MySQL starts. No errors on subsequent restarts. Check suggested by Michal generates no problems. -- 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#c3 Michal Marek <mmarek@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO Info Provider| |gtsm@gandalfsemporium.homelinux.com --- Comment #3 from Michal Marek <mmarek@novell.com> 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#c4 Graham Smith <gtsm@gandalfsemporium.homelinux.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW Info Provider|gtsm@gandalfsemporium.homelinux.com | --- Comment #4 from Graham Smith <gtsm@gandalfsemporium.homelinux.com> 2007-10-12 04:00:17 MST --- Yes, it was a running mysql server session. -- 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 <mmarek@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED --- Comment #5 from Michal Marek <mmarek@novell.com> 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 mmarek@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=332530#c6 Michal Marek <mmarek@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |NEEDINFO Info Provider| |gtsm@gandalfsemporium.homelinux.com --- Comment #6 from Michal Marek <mmarek@novell.com> 2008-02-20 03:53:22 MST --- Graham, Lars: did you happen to use yum for the update? -- 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 <gtsm@gandalfsemporium.homelinux.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |gtsm@gandalfsemporium.homelinux.com --- Comment #7 from Graham Smith <gtsm@gandalfsemporium.homelinux.com> 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#c8 Lars Rupp <lrupp@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|mmarek@novell.com |bnc-team-screening@forge.provo.novell.com Status|NEEDINFO |NEW Info Provider|gtsm@gandalfsemporium.homelinux.com | --- Comment #8 from Lars Rupp <lrupp@novell.com> 2008-03-11 06:20:10 MST --- I used "zypper up -y -t patch --skip-interactive 1>/dev/null" (YaST2 automatic online update) -- 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 <lrupp@novell.com> 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 mmarek@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=332530#c11 Michal Marek <mmarek@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO Info Provider| |lrupp@novell.com --- Comment #11 from Michal Marek <mmarek@novell.com> 2008-05-06 08:05:40 MST --- Interesting. Does /var/lib/mysql/mysqld.log file contain any lines form the starting mysqld? Also Could you please try changing echo -n "Starting service MySQL " $SAFE_MYSQLD \ to echo -n "Starting service MySQL " /usr/bin/strace -fo /var/lib/mysql/strace.$$ $SAFE_MYSQLD \ in the init script and restarting mysqld? Maybe this can tell us why the new mysqld doesn't start. -- 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 <lrupp@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW Info Provider|lrupp@novell.com | --- Comment #12 from Lars Vogdt <lrupp@novell.com> 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#c13 Michal Marek <mmarek@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED --- Comment #13 from Michal Marek <mmarek@novell.com> 2008-05-23 01:15:30 MST --- For the next update, I changed the 'rcmysql stop' timeout to 5 minutes (it was 1 minute). If this bug was really caused by mysql not shutting down in time, this should at least make it less likely. -- 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 <mmarek@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED --- Comment #15 from Michal Marek <mmarek@novell.com> 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.
https://bugzilla.novell.com/show_bug.cgi?id=332530 User swamp@suse.com added comment https://bugzilla.novell.com/show_bug.cgi?id=332530#c16 Swamp Script User <swamp@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard| |maint:released:10.2:21050 --- Comment #16 from Swamp Script User <swamp@suse.com> 2008-12-16 05:45:19 MST --- Update released for: openSUSE 10.2 (i386, ppc, x86_64) -- 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.
participants (1)
-
bugzilla_noreply＠novell.com