[gentoo-user] Updating mysql-init-scripts to 2.0_pre1-r2 now Mysql restart fails!?

[gentoo-user] Updating mysql-init-scripts to 2.0_pre1-r2 now Mysql restart fails!?

[Tanstaafl]

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

[Stéphane Guedon]

[-- Attachment #1: Type: Text/Plain, Size: 991 bytes --]

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

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 490 bytes --]

Re: [gentoo-user] Updating mysql-init-scripts to 2.0_pre1-r2 now Mysql restart fails!?

[Mick]

[-- Attachment #1: Type: Text/Plain, Size: 1075 bytes --]

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

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-user] Updating mysql-init-scripts to 2.0_pre1-r2 now Mysql restart fails!?

[Tanstaafl]

On 2012-01-15 2:11 PM, Mick <michaelkintzios@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 kill<PID>  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?

Re: [gentoo-user] Updating mysql-init-scripts to 2.0_pre1-r2 now Mysql restart fails!?

[Tanstaafl]

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 version        10
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 <tanstaafl@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!?

[Tanstaafl]

On 2012-02-05 2:09 PM, Tanstaafl <tanstaafl@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