Re: [gentoo-user] Updating mysql-init-scripts to 2.0_pre1-r2 now Mysql restart fails!?
just updated mysql from 5.1.56 to 5.1.61, and STILL have this problem... I can't even STOP mysql - with the included init script, all I get is: myhost : Sun Feb 05, 13:55:53 : ~ # /etc/init.d/mysql stop * WARNING: mysql is already stopped Well, it *isn't* stopped, it is running, but it is apparently still the old version (but the mysqladmin command apparently is from the new version): myhost : Sun Feb 05, 14:05:05 : ~ # mysqladmin -u root -p version Enter password: mysqladmin Ver 8.42 Distrib 5.1.61, for pc-linux-gnu on x86_64 Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Server version 5.1.56-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 25 days 7 hours 45 min 17 sec Threads: 4 Questions: 708143 Slow queries: 0 Opens: 139 Flush tables: 1 Open tables: 57 Queries per second avg: 0.323 myhost : Sun Feb 05, 14:05:20 : ~ # Also... shouldn't the init script be for mysqld, not mysql?? Also, why is there no entry for mysql in rc-update? It starts up just fine when booting. I'm totally stumped... On 2012-01-15 12:26 PM, Tanstaafl tansta...@libertytrek.org wrote: Anyone else having this problem? Yes, I did etc-update, and simply accepted the new conf.d config file and init.d script changes... After the update, I attempted to restart mysql but got: myhost : Sun Jan 15, 12:23:47 : ~ # /etc/init.d/mysql restart * Starting mysql ... * start-stop-daemon: /usr/sbin/mysqld is already running [ !! ] * ERROR: mysql failed to start myhost : Sun Jan 15, 12:23:55 : ~ and in the log: Jan 15 12:23:55 myhost /etc/init.d/mysql[16429]: start-stop-daemon: /usr/sbin/mysqld is already running Jan 15 12:23:55 myhost /etc/init.d/mysql[16396]: ERROR: mysql failed to start
Re: [gentoo-user] Updating mysql-init-scripts to 2.0_pre1-r2 now Mysql restart fails!?
On 2012-02-05 2:09 PM, Tanstaafl tansta...@libertytrek.org wrote: just updated mysql from 5.1.56 to 5.1.61, and STILL have this problem... after reviewing this problem, I'm thinking that maybe the problem with stopping or restarting mysql is related to the post install elog warning I got back in January when I updated the init scripts: In the emerge post install I had: WARN: postinst Old /etc/init.d/mysql and /etc/conf.d/mysql still present! Update both of those files to the new versions! But it doesn't say anything about *how* to update them... and yes, I did etc-update after updating the init scripts... Is this documented anywhere? Or is this just evidence that I'm clueless (meaning, I should 'just know' what needs to be done)? Would someone who is not having this problem kindly send me their /etc/init.d/mysq init script, and maybe even their /etc/conf.d/mysql config file? Maybe comparing them will give me a clue... Thanks to anyone for their assistance... Charles
Re: [gentoo-user] Updating mysql-init-scripts to 2.0_pre1-r2 now Mysql restart fails!?
On 2012-01-15 2:11 PM, Mick michaelkintz...@gmail.com wrote: On Sunday 15 Jan 2012 18:35:01 Stéphane Guedon wrote: On Sunday 15 January 2012 18:26:09 Tanstaafl wrote: After the update, I attempted to restart mysql but got: myhost : Sun Jan 15, 12:23:47 : ~ # /etc/init.d/mysql restart * Starting mysql ... * start-stop-daemon: /usr/sbin/mysqld is already running [ !! ] * ERROR: mysql failed to start myhost : Sun Jan 15, 12:23:55 : ~ and in the log: Jan 15 12:23:55 myhost /etc/init.d/mysql[16429]: start-stop-daemon: /usr/sbin/mysqld is already running Jan 15 12:23:55 myhost /etc/init.d/mysql[16396]: ERROR: mysql failed to start I have this since years ! Can't manage to get this error out ! I will look at the tread carefully ! You could try: ps axf | grep mysql and then killPID of mysql before you try to restart it. I can try that this weekend (this is a production server), but that would not be a *fix*, only an ugly workaround. No one else is having this problem or has an idea of how to fix it properly?
[gentoo-user] Updating mysql-init-scripts to 2.0_pre1-r2 now Mysql restart fails!?
Anyone else having this problem? Yes, I did etc-update, and simply accepted the new conf.d config file and init.d script changes... After the update, I attempted to restart mysql but got: myhost : Sun Jan 15, 12:23:47 : ~ # /etc/init.d/mysql restart * Starting mysql ... * start-stop-daemon: /usr/sbin/mysqld is already running [ !! ] * ERROR: mysql failed to start myhost : Sun Jan 15, 12:23:55 : ~ and in the log: Jan 15 12:23:55 myhost /etc/init.d/mysql[16429]: start-stop-daemon: /usr/sbin/mysqld is already running Jan 15 12:23:55 myhost /etc/init.d/mysql[16396]: ERROR: mysql failed to start
Re: [gentoo-user] Updating mysql-init-scripts to 2.0_pre1-r2 now Mysql restart fails!?
On Sunday 15 January 2012 18:26:09 Tanstaafl wrote: Anyone else having this problem? Yes, I did etc-update, and simply accepted the new conf.d config file and init.d script changes... After the update, I attempted to restart mysql but got: myhost : Sun Jan 15, 12:23:47 : ~ # /etc/init.d/mysql restart * Starting mysql ... * start-stop-daemon: /usr/sbin/mysqld is already running [ !! ] * ERROR: mysql failed to start myhost : Sun Jan 15, 12:23:55 : ~ and in the log: Jan 15 12:23:55 myhost /etc/init.d/mysql[16429]: start-stop-daemon: /usr/sbin/mysqld is already running Jan 15 12:23:55 myhost /etc/init.d/mysql[16396]: ERROR: mysql failed to start I have this since years ! Can't manage to get this error out ! I will look at the tread carefully ! -- Stéphane Guedon http://www.22decembre.eu/ http://lectures.22decembre.eu/ carte de visite : http://www.22decembre.eu/downloads/Stephane-Guedon.vcf signature.asc Description: This is a digitally signed message part.
Re: [gentoo-user] Updating mysql-init-scripts to 2.0_pre1-r2 now Mysql restart fails!?
On Sunday 15 Jan 2012 18:35:01 Stéphane Guedon wrote: On Sunday 15 January 2012 18:26:09 Tanstaafl wrote: Anyone else having this problem? Yes, I did etc-update, and simply accepted the new conf.d config file and init.d script changes... After the update, I attempted to restart mysql but got: myhost : Sun Jan 15, 12:23:47 : ~ # /etc/init.d/mysql restart * Starting mysql ... * start-stop-daemon: /usr/sbin/mysqld is already running [ !! ] * ERROR: mysql failed to start myhost : Sun Jan 15, 12:23:55 : ~ and in the log: Jan 15 12:23:55 myhost /etc/init.d/mysql[16429]: start-stop-daemon: /usr/sbin/mysqld is already running Jan 15 12:23:55 myhost /etc/init.d/mysql[16396]: ERROR: mysql failed to start I have this since years ! Can't manage to get this error out ! I will look at the tread carefully ! You could try: ps axf | grep mysql and then kill PID of mysql before you try to restart it. -- Regards, Mick signature.asc Description: This is a digitally signed message part.