[debian-mysql] Bug#418648: similar problem - mysql hanging at boot

Miguel Martins Feitosa Filho mfeitosa at certificadoranorte.com.br
Wed Jul 11 13:44:05 UTC 2007

On a testing system a similar problem happens.

A) During the boot sequence mysql starts apparently without errors.
ps -e | grep mysql show a safe_mysqld and mysqld process as expected.

B) If you access mysql client program then an error similar to:
mfeitosa at tatarana:~$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)

C) If you stop mysql server with
tatarana:~$ /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.

another ps -e | grep mysql shows that the processes did not die.

D) If you send kill signals, mysql processes exit.
ps -e | grep mysql shows nothing

E) If you then start mysql
/etc/init.d/mysql start
server start correctly which can be tested by

tatarana:/home/mfeitosa# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
tatarana:/home/mfeitosa# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.0.41-Debian_1-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


G) It would be nice if /etc/init.d/mysql stop was more informative 

H) This problem DOES NOT AFFECT a similar debian testing system but
running slightly older version of mysql package

quarto:~# dpkg -l | grep mysql
libmysqlclient15off              5.0.38-1                        mysql
database client library
mysql-client-5.0                 5.0.38-1                        mysql
database client binaries
mysql-common                     5.0.38-1                        mysql
database common files mysql-navigator                  1.4.2-8
GUI client program for MySQL mysql-query-browser
1.2.5beta-3                     Official GUI tool to query MySQL
mysql-query-browser-common       1.2.5beta-3
Architecture independent files for mysql-server
5.0.38-1                        mysql database server  mysql-server-5.0
5.0.38-1                        mysql database server binaries

mfeitosa at tatarana:~$ dpkg -l | grep mysql
libmysqlclient15off               5.0.41a-1                       MySQL
database client library
mysql-client-5.0                  5.0.41a-1                       MySQL
database client binaries
mysql-common                      5.0.41a-1                       MySQL
database common files
mysql-server                      5.0.41a-1                       MySQL
database server   mysql-server-5.0                  5.0.41a-1
MySQL database server binaries

H) No framebuffer is used at boot

I) I do not know how to further test this situation - any pointers will
be helpfull so I can generate more feedback

J) Will look into mysqlmanager - 

K) Seems Nicolas identified the problem but as he was using - 5.0.32 and
my 5.0.38 system does not have the bug then we might have diferent
reasons for having the same problem

Miguel Feitosa

More information about the pkg-mysql-maint mailing list