[debian-mysql] Bug#459764: mysql-server: mysqld fails to stop and start after upgrade (5.0.32-7etch3 -> 5.0.32-7etch4)
Allan Wind
allan_wind at lifeintegrity.com
Tue Jan 8 15:50:03 UTC 2008
Package: mysql-server
Version: 5.0.32-7etch4
Severity: grave
Justification: renders package unusable
Feel free to downgrade this issue if this is particular to my install,
but I thought it was important to file this one as soon as possible in
case it impacts others with production data:
Jan 8 04:47:57 input at vent cron-apt: libfreetype6 libmysqlclient15off mysql-client-5.0 mysql-common mysql-server
Jan 8 04:47:57 input at vent cron-apt: mysql-server-5.0
Jan 8 08:58:04 input at vent mysqld[1806]: 080108 8:58:04 [Note] /usr/sbin/mysqld: Normal shutdown
Jan 8 08:58:04 input at vent mysqld[1806]:
Jan 8 08:58:04 input at vent mysqld[1806]: 080108 8:58:04 InnoDB: Starting shutdown...
Jan 8 08:58:07 input at vent mysqld[1806]: 080108 8:58:07 InnoDB: Shutdown completed; log sequence number 1 2473367412
Jan 8 08:58:07 input at vent mysqld[1806]: 080108 8:58:07 [Note] /usr/sbin/mysqld: Shutdown complete
Jan 8 08:58:07 input at vent mysqld[1806]:
Jan 8 08:58:07 input at vent mysqld_safe[6326]: ended
Jan 8 09:17:42 input at vent mysqld_safe[1822]: started
Jan 8 09:17:42 input at vent mysqld[1825]: 080108 9:17:42 InnoDB: Started; log sequence number 1 2473367412
Jan 8 09:17:42 input at vent mysqld[1825]: 080108 9:17:42 [Note] /usr/sbin/mysqld: ready for connections.
Jan 8 09:17:42 input at vent mysqld[1825]: Version: '5.0.32-Debian_7etch3-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution
Jan 8 09:17:43 input at vent /etc/mysql/debian-start[1863]: Upgrading MySQL tables if necessary.
Jan 8 09:17:44 input at vent /etc/mysql/debian-start[1947]: Checking for crashed MySQL tables.
Jan 8 10:05:52 input at vent mysqld[1825]: 080108 10:05:52 [Note] /usr/sbin/mysqld: Normal shutdown
Jan 8 10:05:52 input at vent mysqld[1825]:
Jan 8 10:05:52 input at vent mysqld[1825]: 080108 10:05:52 InnoDB: Starting shutdown...
Jan 8 10:05:56 input at vent mysqld[1825]: 080108 10:05:56 InnoDB: Shutdown completed; log sequence number 1 2473367422
Jan 8 10:05:56 input at vent mysqld[1825]: 080108 10:05:56 [Note] /usr/sbin/mysqld: Shutdown complete
Jan 8 10:05:56 input at vent mysqld[1825]:
Jan 8 10:05:56 input at vent mysqld_safe[3119]: ended
Jan 8 10:06:10 input at vent mysqld_safe[3379]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Jan 8 10:06:10 input at vent mysqld_safe[3379]: To do so, start the server, then issue the following commands:
Jan 8 10:06:10 input at vent mysqld_safe[3379]: /usr/bin/mysqladmin -u root password 'new-password'
Jan 8 10:06:10 input at vent mysqld_safe[3379]: /usr/bin/mysqladmin -u root -h vent password 'new-password'
Jan 8 10:06:10 input at vent mysqld_safe[3379]: See the manual for more instructions.
Jan 8 10:06:10 input at vent mysqld_safe[3379]:
Jan 8 10:06:10 input at vent mysqld_safe[3379]: NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
Jan 8 10:06:10 input at vent mysqld_safe[3379]: the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
Jan 8 10:06:10 input at vent mysqld_safe[3379]: able to use the new GRANT command!
Jan 8 10:06:10 input at vent mysqld_safe[3379]:
Jan 8 10:06:10 input at vent mysqld_safe[3379]: Please report any problems with the /usr/bin/mysqlbug script!
Jan 8 10:06:10 input at vent mysqld_safe[3379]:
Jan 8 10:06:10 input at vent mysqld_safe[3379]: The latest information about MySQL is available on the web at
Jan 8 10:06:10 input at vent mysqld_safe[3379]: http://www.mysql.com
Jan 8 10:06:10 input at vent mysqld_safe[3379]: Support MySQL by buying support/licenses at http://shop.mysql.com
Jan 8 10:06:11 input at vent mysqld_safe[3523]: started
Jan 8 10:06:12 input at vent mysqld[3526]: 080108 10:06:12 InnoDB: Started; log sequence number 1 2473367422
Jan 8 10:06:12 input at vent mysqld[3526]: 080108 10:06:12 [Note] /usr/sbin/mysqld: ready for connections.
Jan 8 10:06:12 input at vent mysqld[3526]: Version: '5.0.32-Debian_7etch4-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution
Jan 8 10:06:12 input at vent /etc/mysql/debian-start[3560]: Upgrading MySQL tables if necessary.
Jan 8 10:06:12 input at vent /etc/mysql/debian-start[3565]: ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
Jan 8 10:06:12 input at vent /etc/mysql/debian-start[3565]: Error executing '/usr/bin/mysql --defaults-extra-file=/var/lib/mysql/mysql_upgrade_defaults --force --no-auto-rehash --batch --user=debian-sys-maint mysql < /usr/share/mysql/mysql_fix_privilege_tables.sql'
Jan 8 10:06:12 input at vent /etc/mysql/debian-start[3569]: Checking for crashed MySQL tables.
Jan 8 10:06:13 input at vent /etc/mysql/debian-start[3578]: WARNING: mysqlcheck has found corrupt tables
Jan 8 10:06:13 input at vent /etc/mysql/debian-start[3578]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect
Jan 8 10:06:13 input at vent /etc/mysql/debian-start[3578]:
Jan 8 10:06:13 input at vent /etc/mysql/debian-start[3578]: Improperly closed tables are also reported if clients are accessing
Jan 8 10:06:13 input at vent /etc/mysql/debian-start[3578]: the tables *now*. A list of current connections is below.
Jan 8 10:06:13 input at vent /etc/mysql/debian-start[3578]:
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]: Status information:
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]: Current dir: /var/lib/mysql/
Jan 8 10:12:21 input at vent mysqld[3526]: Running threads: 0 Stack size: 131072
Jan 8 10:12:21 input at vent mysqld[3526]: Current locks:
Jan 8 10:12:21 input at vent mysqld[3526]: lock: 0x120d350:
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]: lock: 0x1207500:
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]: lock: 0x11f9e60:
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]: lock: 0x11f4090:
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]: lock: 0x11f00b0:
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]: lock: 0x11e9f50:
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]: Key caches:
Jan 8 10:12:21 input at vent mysqld[3526]: default
Jan 8 10:12:21 input at vent mysqld[3526]: Buffer_size: 16777216
Jan 8 10:12:21 input at vent mysqld[3526]: Block_size: 1024
Jan 8 10:12:21 input at vent mysqld[3526]: Division_limit: 100
Jan 8 10:12:21 input at vent mysqld[3526]: Age_limit: 300
Jan 8 10:12:21 input at vent mysqld[3526]: blocks used: 3
Jan 8 10:12:21 input at vent mysqld[3526]: not flushed: 0
Jan 8 10:12:21 input at vent mysqld[3526]: w_requests: 0
Jan 8 10:12:21 input at vent mysqld[3526]: writes: 0
Jan 8 10:12:21 input at vent mysqld[3526]: r_requests: 6
Jan 8 10:12:21 input at vent mysqld[3526]: reads: 3
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]: handler status:
Jan 8 10:12:21 input at vent mysqld[3526]: read_key: 0
Jan 8 10:12:21 input at vent mysqld[3526]: read_next: 4
Jan 8 10:12:21 input at vent mysqld[3526]: read_rnd 0
Jan 8 10:12:21 input at vent mysqld[3526]: read_first: 3
Jan 8 10:12:21 input at vent mysqld[3526]: write: 0
Jan 8 10:12:21 input at vent mysqld[3526]: delete 0
Jan 8 10:12:21 input at vent mysqld[3526]: update: 0
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]: Table status:
Jan 8 10:12:21 input at vent mysqld[3526]: Opened tables: 12
Jan 8 10:12:21 input at vent mysqld[3526]: Open tables: 6
Jan 8 10:12:21 input at vent mysqld[3526]: Open files: 14
Jan 8 10:12:21 input at vent mysqld[3526]: Open streams: 0
Jan 8 10:12:21 input at vent mysqld[3526]:
Jan 8 10:12:21 input at vent mysqld[3526]: Alarm status:
Jan 8 10:12:21 input at vent mysqld[3526]: Active alarms: 0
Jan 8 10:12:21 input at vent mysqld[3526]: Max used alarms: 1
Jan 8 10:12:21 input at vent mysqld[3526]: Next alarm time: 0
Jan 8 10:12:31 input at vent mysqld_safe[3764]: Number of processes running now: 1
Jan 8 10:12:31 input at vent mysqld_safe[3772]: mysqld process hanging, pid 3525 - killed
Jan 8 10:12:31 input at vent mysqld_safe[3775]: restarted
Jan 8 10:12:31 input at vent mysqld[3778]: 080108 10:12:31 InnoDB: Started; log sequence number 1 2473367422
Jan 8 10:12:31 input at vent mysqld[3778]: 080108 10:12:31 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
Jan 8 10:12:31 input at vent mysqld[3778]: 080108 10:12:31 [Note] Starting crash recovery...
Jan 8 10:12:31 input at vent mysqld[3778]: 080108 10:12:31 [Note] Crash recovery finished.
Jan 8 10:12:31 input at vent mysqld[3778]: 080108 10:12:31 [Note] /usr/sbin/mysqld: ready for connections.
Jan 8 10:12:31 input at vent mysqld[3778]: Version: '5.0.32-Debian_7etch4-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution
Jan 8 10:13:12 input at vent mysqld[3778]: 080108 10:13:12 [Note] /usr/sbin/mysqld: Normal shutdown
Jan 8 10:13:12 input at vent mysqld[3778]:
Jan 8 10:13:12 input at vent mysqld[3778]: 080108 10:13:12 InnoDB: Starting shutdown...
Jan 8 10:13:12 input at vent mysqld_safe[3823]: Number of processes running now: 1
Jan 8 10:13:12 input at vent mysqld_safe[3831]: mysqld process hanging, pid 3777 - killed
Jan 8 10:13:12 input at vent mysqld_safe[3834]: restarted
I tried to connect to mysql using the information in
/etc/mysql/debian.cnf and it did not work.
-- System Information:
Debian Release: 4.0
APT prefers stable
APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.23.12
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Versions of packages mysql-server depends on:
ii mysql-server-5.0 5.0.32-7etch4 mysql database server binaries
mysql-server recommends no packages.
-- no debconf information
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20080108/43a82811/attachment.pgp
More information about the pkg-mysql-maint
mailing list