Package: mysql-server
Version: 5.0.32-7etch1
When booting (and only when booting) on a clean etch distribution, mysqld hangs
:
Apr 11 00:29:02 freevo mysqld_safe[4469]: started
Apr 11 00:29:02 freevo mysqld[4472]: 070411 0:29:02 InnoDB: Started; log
sequence number 0 43655
Apr 11 00:29:02 freevo mysqld[4472]: 070411 0:29:02 [Note] /usr/sbin/mysqld:
ready for connections.
Apr 11 00:29:02 freevo mysqld[4472]: Version: '5.0.32-Debian_7etch1-log'
socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution
Apr 11 00:29:03 freevo /etc/mysql/debian-start[4511]: Upgrading MySQL tables if
necessary.
Apr 11 00:29:03 freevo /etc/mysql/debian-start[4561]: Checking for crashed
MySQL tables.
Apr 11 00:29:04 freevo mysqld_safe[4657]: Number of processes running now: 1
Apr 11 00:29:04 freevo mysqld_safe[4665]: mysqld process hanging, pid 4471 -
killed
Apr 11 00:29:04 freevo mysqld_safe[4668]: restarted
Apr 11 00:29:04 freevo mysqld[4671]: 070411 0:29:04 InnoDB: Started; log
sequence number 0 43655
Apr 11 00:29:04 freevo mysqld[4671]: 070411 0:29:04 [Note] Recovering after a
crash using /var/log/mysql/mysql-bin
Apr 11 00:29:04 freevo mysqld[4671]: 070411 0:29:04 [Note] Starting crash
recovery...
Apr 11 00:29:04 freevo mysqld[4671]: 070411 0:29:04 [Note] Crash recovery
finished.
Apr 11 00:29:04 freevo mysqld[4671]: 070411 0:29:04 [Note] /usr/sbin/mysqld:
ready for connections.
Apr 11 00:29:04 freevo mysqld[4671]: Version: '5.0.32-Debian_7etch1-log'
socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution
Services depending on it fail then to start.
It seems to be the /etc/mysql/debian-start script which is accessing mysql too
early. If I put a sleep 1 in /etc/init.d/mysql :
if mysqld_status check_alive nowarn ; then sleep 1; break; fi
It starts on first try :
Apr 11 01:43:22 freevo mysqld_safe[2472]: started
Apr 11 01:43:23 freevo mysqld[2475]: 070411 1:43:23 InnoDB: Started; log
sequence number 0 43655
Apr 11 01:43:23 freevo mysqld[2475]: 070411 1:43:23 [Note] /usr/sbin/mysqld:
ready for connections.
Apr 11 01:43:23 freevo mysqld[2475]: Version: '5.0.32-Debian_7etch1-log'
socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution
Apr 11 01:43:24 freevo /etc/mysql/debian-start[2513]: Upgrading MySQL tables if
necessary.
Apr 11 01:43:25 freevo /etc/mysql/debian-start[2519]: Checking for crashed
MySQL tables.
BUT, it then fails on next access from another process :
Apr 11 01:35:06 freevo mysqld_safe[2862]: Number of processes running now: 1
Apr 11 01:35:07 freevo mysqld_safe[2870]: mysqld process hanging, pid 2531 -
killed
Apr 11 01:35:07 freevo mysqld_safe[2874]: restarted
Apr 11 01:35:08 freevo mysqld[2877]: 070411 1:35:08 InnoDB: Started; log
sequence number 0 43655
Apr 11 01:35:08 freevo mysqld[2877]: 070411 1:35:08 [Note] Recovering after a
crash using /var/log/mysql/mysql-bin
Apr 11 01:35:08 freevo mysqld[2877]: 070411 1:35:08 [Note] Starting crash
recovery...
Apr 11 01:35:08 freevo mysqld[2877]: 070411 1:35:08 [Note] Crash recovery
finished.
Apr 11 01:35:08 freevo mysqld[2877]: 070411 1:35:08 [Note] /usr/sbin/mysqld:
ready for connections.
Apr 11 01:35:08 freevo mysqld[2877]: Version: '5.0.32-Debian_7etch1-log'
socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution
Then this process fails too.
By removing the parallel execution of /etc/mysql/debian-start (&), everything
boots right on first time :
echo "Checking for corrupt, not cleanly closed and upgrade needing tables."
(
upgrade_system_tables_if_necessary;
check_for_crashed_tables;
) >&2
This bug is 100% reproducible on a Debian Etch running mysql-server
5.0.32-7etch1 on a nForce2 motherboard with kernel 2.6.20-beyond2-k7 (with
premption).
Start scripts are as follow :
lrwxrwxrwx 1 root root 18 2007-03-31 00:46 S10sysklogd -> ../init.d/sysklogd
lrwxrwxrwx 1 root root 15 2007-03-31 00:46 S11klogd -> ../init.d/klogd
lrwxrwxrwx 1 root root 23 2007-04-02 00:53 S17mysql-ndb-mgm ->
../init.d/mysql-ndb-mgm
lrwxrwxrwx 1 root root 19 2007-04-02 00:53 S18mysql-ndb -> ../init.d/mysql-ndb
lrwxrwxrwx 1 root root 14 2007-04-02 02:59 S19lirc -> ../init.d/lirc
lrwxrwxrwx 1 root root 15 2007-04-10 23:58 S19mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 15 2007-03-31 19:28 S20acpid -> ../init.d/acpid
lrwxrwxrwx 1 root root 17 2007-04-02 03:20 S20athcool -> ../init.d/athcool
lrwxrwxrwx 1 root root 18 2007-04-10 22:09 S20cpufreqd -> ../init.d/cpufreqd
lrwxrwxrwx 1 root root 20 2007-04-02 02:54 S20fancontrol ->
../init.d/fancontrol
lrwxrwxrwx 1 root root 17 2007-03-31 00:46 S20makedev -> ../init.d/makedev
lrwxrwxrwx 1 root root 27 2007-03-31 22:51 S20nvidia-glx-legacy ->
../init.d/nvidia-glx-legacy
lrwxrwxrwx 1 root root 23 2007-03-31 00:46 S20openbsd-inetd ->
../init.d/openbsd-inetd
lrwxrwxrwx 1 root root 13 2007-03-31 01:04 S20ssh -> ../init.d/ssh
lrwxrwxrwx 1 root root 17 2007-04-10 03:25 S23s**c-ng -> ../init.d/s**c-ng
lrwxrwxrwx 1 root root 24 2007-04-11 01:40 S24mythtv-backend ->
../init.d/mythtv-backend
lrwxrwxrwx 1 root root 14 2007-03-31 00:46 S89cron -> ../init.d/cron
lrwxrwxrwx 1 root root 17 2007-04-02 00:51 S91apache2 -> ../init.d/apache2
lrwxrwxrwx 1 root root 18 2007-03-31 00:46 S99rc.local -> ../init.d/rc.local
lrwxrwxrwx 1 root root 19 2007-03-31 00:46 S99rmnologin -> ../init.d/rmnologin
lrwxrwxrwx 1 root root 23 2007-03-31 00:46 S99stop-bootlogd ->
../init.d/stop-bootlogd
Nicolas
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
