[Bug 520876] New: Update to mysql-5.1.35-34.1 fails to restart mysql
http://bugzilla.novell.com/show_bug.cgi?id=520876 Summary: Update to mysql-5.1.35-34.1 fails to restart mysql Classification: openSUSE Product: openSUSE 10.3 Version: Final Platform: Other OS/Version: Other Status: NEW Severity: Normal Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: drankinatty@suddenlinkmail.com QAContact: qa@suse.de Found By: --- User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.11) Gecko/2009060200 SUSE/3.0.11-0.1 Firefox/3.0.11 On 10.3 updating mysql to mysql-5.1.35-34.1 fails to restart mysql after the upgrade is complete. I guess there is something broken in the post-install script that does not restart the server. The my.cnf (installed as my.cnf.rpmnew) is identical to the existing my.cnf so there isn't any reason mysql should not be restarted. Reproducible: Always Steps to Reproduce: 1. zypper up -t package (with the database repository active) 2. update mysql to mysql-5.1.35-34.1 3. Actual Results: mysql is not restarted after the update Expected Results: mysql should be restarted after the upgrade -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=520876 Marcus Meissner <meissner@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|bnc-team-screening@forge.pr |mhrusecky@novell.com |ovo.novell.com | -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=520876 User mhrusecky@novell.com added comment http://bugzilla.novell.com/show_bug.cgi?id=520876#c1 Michal Hrusecky <mhrusecky@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - None |P4 - Low Status|NEW |ASSIGNED --- Comment #1 from Michal Hrusecky <mhrusecky@novell.com> 2009-07-10 05:09:36 MDT --- Manual restart works? Is MySQL enabled to start during the boot? -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=520876 Michal Hrusecky <mhrusecky@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |NEEDINFO Info Provider| |drankinatty@suddenlinkmail. | |com -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=520876 User drankinatty@suddenlinkmail.com added comment http://bugzilla.novell.com/show_bug.cgi?id=520876#c2 David Rankin <drankinatty@suddenlinkmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |ASSIGNED Info Provider|drankinatty@suddenlinkmail. | |com | --- Comment #2 from David Rankin <drankinatty@suddenlinkmail.com> 2009-09-17 15:37:42 MDT --- Michal, Sorry for the late reply, but "yes" mysql is configured to start at boot on each server I have ( 4 total -- 1 -> 10.3 x86_64, 1 10.3 i586, 1 11.0 x86_64 and 1 11.0 x86_64 ) On each of the boxes and on my laptop, mysql has failed to restart after the last 3-4 upgrades. [15:33 alchemy:/home/david/linux/openoffice/oo24] # chkconfig --list | grep mysql mysql 0:off 1:off 2:on 3:on 4:off 5:on 6:off -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=520876 User drankinatty@suddenlinkmail.com added comment http://bugzilla.novell.com/show_bug.cgi?id=520876#c3 --- Comment #3 from David Rankin <drankinatty@suddenlinkmail.com> 2009-09-17 15:38:45 MDT --- Sorry, I forgot the following: Yes, manual restart (rcmysql restart) works just fine. I just have to remember to do it after every update. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=520876 User drankinatty@suddenlinkmail.com added comment http://bugzilla.novell.com/show_bug.cgi?id=520876#c4 --- Comment #4 from David Rankin <drankinatty@suddenlinkmail.com> 2009-09-19 21:54:44 MDT --- Michal, I updated another 11.0 box tonight: 1253404504 (Sat 19 Sep 2009 06:55:04 PM CDT) libwbclient0 1253404508 (Sat 19 Sep 2009 06:55:08 PM CDT) mysql-client 1253404513 (Sat 19 Sep 2009 06:55:13 PM CDT) MyODBC-unixODBC 1253404528 (Sat 19 Sep 2009 06:55:28 PM CDT) libsmbclient0 1253404545 (Sat 19 Sep 2009 06:55:45 PM CDT) cifs-mount 1253404635 (Sat 19 Sep 2009 06:57:15 PM CDT) mysql 1253404662 (Sat 19 Sep 2009 06:57:42 PM CDT) mysql-bench 1253404842 (Sat 19 Sep 2009 07:00:42 PM CDT) samba-client 1253404896 (Sat 19 Sep 2009 07:01:36 PM CDT) libsmbclient-devel 1253404928 (Sat 19 Sep 2009 07:02:08 PM CDT) samba-winbind 1253404989 (Sat 19 Sep 2009 07:03:09 PM CDT) samba [22:22 nemesis:/home/david] # rcmysql status Checking for service MySQL: unused [22:22 nemesis:/home/david] # rpm -q mysql mysql-5.1.36-45.1 Same result. Here are the syslog entries for the past "2" updates. One on Sep 12 and the other today, Sep 19: Sep 12 18:57:31 nemesis shadow[2008]: group already exists - group=mysql, by=0 Sep 12 18:57:31 nemesis useradd[2009]: account already exists - account=mysql, by=0 Sep 12 18:57:31 nemesis shadow[2010]: default group changed - account=mysql, uid=60, gid=114, old gid=114, by=0 Sep 12 18:57:31 nemesis shadow[2010]: shell changed - account=mysql, uid=60, shell=/bin/false, old shell=/bin/false, by=0 Sep 19 18:57:08 nemesis shadow[7723]: group already exists - group=mysql, by=0 Sep 19 18:57:08 nemesis useradd[7724]: account already exists - account=mysql, by=0 Sep 19 18:57:08 nemesis shadow[7725]: default group changed - account=mysql, uid=60, gid=114, old gid=114, by=0 Sep 19 18:57:08 nemesis shadow[7725]: shell changed - account=mysql, uid=60, shell=/bin/false, old shell=/bin/false, by=0 I don't know if that will help or not, but I thought I would include it. The mysqld.log for today was: 090919 18:57:08 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended 090919 18:57:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 090919 18:57:20 [Note] Plugin 'ndbcluster' is disabled. 090919 18:57:21 InnoDB: Started; log sequence number 0 44759151 090919 18:57:21 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.36-log' socket: '/var/run/mysql/protected/mysql.sock' port: 3306 SUSE MySQL RPM 090919 18:57:29 [Note] /usr/sbin/mysqld: Normal shutdown 090919 18:57:29 InnoDB: Starting shutdown... 090919 18:57:32 InnoDB: Shutdown completed; log sequence number 0 44759151 090919 18:57:32 [Warning] Forcing shutdown of 1 plugins 090919 18:57:32 [Note] /usr/sbin/mysqld: Shutdown complete 090919 18:57:32 mysqld_safe mysqld from pid file /var/run/mysql/protected/mysqld.pid ended 090919 18:57:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 090919 18:57:32 [Note] Plugin 'ndbcluster' is disabled. 090919 18:57:32 [Note] Plugin 'FEDERATED' is disabled. 090919 18:57:32 InnoDB: Started; log sequence number 0 44759151 090919 18:57:33 [Note] Event Scheduler: Loaded 0 events 090919 18:57:33 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.36-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM 090919 18:57:33 [Note] /usr/sbin/mysqld: Normal shutdown 090919 18:57:33 [Note] Event Scheduler: Purging the queue. 0 events 090919 18:57:33 InnoDB: Starting shutdown... 090919 18:57:34 InnoDB: Shutdown completed; log sequence number 0 44759151 090919 18:57:34 [Warning] Forcing shutdown of 2 plugins 090919 18:57:34 [Note] /usr/sbin/mysqld: Shutdown complete 090919 18:57:34 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended I will attach the mysqld-upgrade.log with the following post. The only thing that looks interesting is the warning about trying to lock log tables. Hopefully these will help with progress on this bug. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=520876 User drankinatty@suddenlinkmail.com added comment http://bugzilla.novell.com/show_bug.cgi?id=520876#c5 --- Comment #5 from David Rankin <drankinatty@suddenlinkmail.com> 2009-09-19 21:56:56 MDT --- Created an attachment (id=318967) --> (http://bugzilla.novell.com/attachment.cgi?id=318967) mysqld-upgrade.log for the past several upgrades -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=520876 User mhrusecky@novell.com added comment http://bugzilla.novell.com/show_bug.cgi?id=520876#c6 Michal Hrusecky <mhrusecky@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |NEEDINFO Info Provider| |drankinatty@suddenlinkmail. | |com --- Comment #6 from Michal Hrusecky <mhrusecky@novell.com> 2009-10-01 07:56:07 MDT --- More interesting would be in this case output of following commands: /sbin/runlevel ls /etc/rc.d/rc*.d/s*mysql But I'll try to fix it somehow even without these... -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=520876 User mhrusecky@novell.com added comment http://bugzilla.novell.com/show_bug.cgi?id=520876#c7 --- Comment #7 from Michal Hrusecky <mhrusecky@novell.com> 2009-10-01 07:56:52 MDT --- More interesting would be in this case output of following commands: /sbin/runlevel ls /etc/rc.d/rc*.d/S*mysql But I'll try to fix it somehow even without these... -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=520876 User mhrusecky@novell.com added comment http://bugzilla.novell.com/show_bug.cgi?id=520876#c8 --- Comment #8 from Michal Hrusecky <mhrusecky@novell.com> 2009-10-05 04:02:46 MDT --- Should be fixed now. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=520876 http://bugzilla.novell.com/show_bug.cgi?id=520876#c9 Michal Hrusecky <mhrusecky@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |RESOLVED Info Provider|drankinatty@suddenlinkmail. | |com | Resolution| |FIXED --- Comment #9 from Michal Hrusecky <mhrusecky@novell.com> 2009-11-27 10:40:26 UTC --- Forgot to set fixed status ;-) -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=520876 http://bugzilla.novell.com/show_bug.cgi?id=520876#c10 --- Comment #10 from Bernhard Wiedemann <bwiedemann@suse.com> --- This is an autogenerated message for OBS integration: This bug (520876) was mentioned in https://build.opensuse.org/request/show/103700 Factory / mariadb https://build.opensuse.org/request/show/21973 Factory / mysql -- You are receiving this mail because: You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply＠novell.com