Re: MySQL Starts But Fails to Restart

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



When you stop MySQL, the kill command completes immediately, while MySQL
is still doing shutdown tasks to make sure the database is in a
consistent state. As MySQL is still running when you try to start it, it
will fail to do so.
There's 2 ways to fix this:
- use mysqladmin shutdown, needs a user in the database with process
privileges, this is the way used by debian
- implement a loop that waits for MySQL to shutdown after executing the
kill command. This is what the upstream MySQL start/stop script does.

On Tue, 2010-03-23 at 22:46 -0400, Carlos Mennens wrote:
> 4. I then run the command to restart the daemon for MySQL and it fails...
> 
> Code:
> 
> [root@ghost /]# /etc/rc.d/mysqld restart
> :: Stopping MySQL Server
> 
>                 [DONE]
> :: Starting MySQL Server
> 
>                 [FAIL]
> 
> I can use the 'start' and 'stop' commands for /etc/rc.d/mysqld but
> 'restart' for some reason fails and this concerns me. Can anyone help
> me understand what is wrong?




[Index of Archives]     [Linux Wireless]     [Linux Kernel]     [ATH6KL]     [Linux Bluetooth]     [Linux Netdev]     [Kernel Newbies]     [Share Photos]     [IDE]     [Security]     [Git]     [Netfilter]     [Bugtraq]     [Yosemite News]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]     [Linux ATA RAID]     [Samba]     [Device Mapper]
  Powered by Linux