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

[Miguel Martins Feitosa Filho]

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

F) 
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.

mysql> 

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

I) QUARTO system DOES NOT HAVE BUG
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
...clipped...

II) TATARANA system HAS BOOT BUG
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
..clipped...

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

Thanks,
Miguel Feitosa