Your message dated Thu, 05 Jul 2012 15:53:12 +0000
with message-id <[email protected]>
and subject line Bug#680362: Removed package(s) from unstable
has caused the Debian Bug report #418648,
regarding mysqld process hanging only at boot
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
418648: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=418648
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
Version: 5.1.62-1+rm
Dear submitter,
as the package mysql-5.1 has just been removed from the Debian archive
unstable we hereby close the associated bug reports. We are sorry
that we couldn't deal with your issue properly.
For details on the removal, please see http://bugs.debian.org/680362
The version of this package that was in Debian prior to this removal
can still be found using http://snapshot.debian.org/.
This message was generated automatically; if you believe that there is
a problem with it please contact the archive administrators by mailing
[email protected].
Debian distribution maintenance software
pp.
Alexander Reichle-Schmehl (the ftpmaster behind the curtain)
--- End Message ---
