[Bug 620441] Re: MySQL upstart stop job does not cleanly shutdown mysql

[Robert Citek]

Had some issues getting changes in mysql's upstart script from taking
effect.  This demonstrates the issue, using the respawn command as the
example, and a solution.

$ grep respawn /etc/init/mysql.conf 
respawn

$ sudo mysqladmin status ; sudo mysqladmin shutdown ; sudo mysqladmin status ; sleep 10 ; sudo mysqladmin status
Uptime: 29  Threads: 1  Questions: 100  Slow queries: 0  Opens: 99  Flush tables: 1  Open tables: 23  Queries per second avg: 3.448
Uptime: 1  Threads: 1  Questions: 1  Slow queries: 0  Opens: 15  Flush tables: 1  Open tables: 8  Queries per second avg: 1.0
Uptime: 11  Threads: 1  Questions: 99  Slow queries: 0  Opens: 99  Flush tables: 1  Open tables: 23  Queries per second avg: 9.0

$ sudo sed -i.bak -e 's/respawn/# respawn/' /etc/init/mysql.conf

$ grep respawn /etc/init/mysql.conf 
# respawn

$ sudo mysqladmin status ; sudo mysqladmin shutdown ; sudo mysqladmin status ; sleep 10 ; sudo mysqladmin status
Uptime: 5  Threads: 1  Questions: 98  Slow queries: 0  Opens: 99  Flush tables: 1  Open tables: 23  Queries per second avg: 19.600
Uptime: 1  Threads: 1  Questions: 1  Slow queries: 0  Opens: 15  Flush tables: 1  Open tables: 8  Queries per second avg: 1.0
Uptime: 11  Threads: 1  Questions: 99  Slow queries: 0  Opens: 99  Flush tables: 1  Open tables: 23  Queries per second avg: 9.0

$ sudo mysqladmin shutdown ; sudo service mysql stop
mysql stop/waiting

$ sudo service mysql start
mysql start/running, process 10405

$ sudo mysqladmin status ; sudo mysqladmin shutdown ; sudo mysqladmin status ; sleep 10 ; sudo mysqladmin status
Uptime: 6  Threads: 1  Questions: 98  Slow queries: 0  Opens: 99  Flush tables: 1  Open tables: 23  Queries per second avg: 16.333
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.
https://bugs.launchpad.net/bugs/620441

Title:
  MySQL upstart stop job does not cleanly shutdown mysql