Mailing List Archive: Gentoo: User

Updating mysql-init-scripts to 2.0_pre1-r2 now Mysql restart fails!?

Index | Next | Previous | View Threaded

tanstaafl at libertytrek

Jan 15, 2012, 9:26 AM

Post #1 of 6 (562 views)
Permalink

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

stephane at 22decembre

Jan 15, 2012, 10:35 AM

Post #2 of 6 (543 views)
Permalink

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

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

Attachments:

signature.asc (0.48 KB)

michaelkintzios at gmail

Jan 15, 2012, 11:11 AM

Post #3 of 6 (543 views)
Permalink

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

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

Attachments:

signature.asc (0.19 KB)

tanstaafl at libertytrek

Jan 17, 2012, 4:29 AM

Post #4 of 6 (537 views)
Permalink

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

On 2012-01-15 2:11 PM, Mick <michaelkintzios [at] gmail> 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?

tanstaafl at libertytrek

Feb 5, 2012, 11:09 AM

Post #5 of 6 (497 views)
Permalink

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

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 [at] libertytrek> 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
>

tanstaafl at libertytrek

Feb 5, 2012, 11:45 AM

Post #6 of 6 (494 views)
Permalink

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

On 2012-02-05 2:09 PM, Tanstaafl <tanstaafl [at] libertytrek> 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

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads