Re: [arch-general] MySQL Starts But Fails to Restart
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: [r...@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?
[arch-general] MySQL Starts But Fails to Restart
I don't understand this issue so I am posting this here. I noticed today that I had an issue with restarting MySQL on my server: 1. I verify MySQL is not running: Code: [r...@ghost /]# ps -ef | grep -i mysqld root 1706 1216 0 16:45 pts/000:00:00 grep --color=auto -i mysqld 2. I start the 'mysqld' service: Code: [r...@ghost /]# /etc/rc.d/mysqld start :: Starting MySQL Server [DONE] 3. I verify that the daemon is running: Code: [r...@ghost /]# ps -ef | grep -i mysqld root 1715 1 0 16:45 pts/000:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql mysql 1813 1715 0 16:45 pts/000:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/ghost.err --pid-file=/var/lib/mysql/ghost.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 4. I then run the command to restart the daemon for MySQL and it fails... Code: [r...@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?