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 [EMAIL PROTECTED] cron-apt: libfreetype6 libmysqlclient15off mysql-client-5.0 mysql-common mysql-server Jan 8 04:47:57 [EMAIL PROTECTED] cron-apt: mysql-server-5.0 Jan 8 08:58:04 [EMAIL PROTECTED] mysqld[1806]: 080108 8:58:04 [Note] /usr/sbin/mysqld: Normal shutdown Jan 8 08:58:04 [EMAIL PROTECTED] mysqld[1806]: Jan 8 08:58:04 [EMAIL PROTECTED] mysqld[1806]: 080108 8:58:04 InnoDB: Starting shutdown... Jan 8 08:58:07 [EMAIL PROTECTED] mysqld[1806]: 080108 8:58:07 InnoDB: Shutdown completed; log sequence number 1 2473367412 Jan 8 08:58:07 [EMAIL PROTECTED] mysqld[1806]: 080108 8:58:07 [Note] /usr/sbin/mysqld: Shutdown complete Jan 8 08:58:07 [EMAIL PROTECTED] mysqld[1806]: Jan 8 08:58:07 [EMAIL PROTECTED] mysqld_safe[6326]: ended Jan 8 09:17:42 [EMAIL PROTECTED] mysqld_safe[1822]: started Jan 8 09:17:42 [EMAIL PROTECTED] mysqld[1825]: 080108 9:17:42 InnoDB: Started; log sequence number 1 2473367412 Jan 8 09:17:42 [EMAIL PROTECTED] mysqld[1825]: 080108 9:17:42 [Note] /usr/sbin/mysqld: ready for connections. Jan 8 09:17:42 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] /etc/mysql/debian-start[1863]: Upgrading MySQL tables if necessary. Jan 8 09:17:44 [EMAIL PROTECTED] /etc/mysql/debian-start[1947]: Checking for crashed MySQL tables. Jan 8 10:05:52 [EMAIL PROTECTED] mysqld[1825]: 080108 10:05:52 [Note] /usr/sbin/mysqld: Normal shutdown Jan 8 10:05:52 [EMAIL PROTECTED] mysqld[1825]: Jan 8 10:05:52 [EMAIL PROTECTED] mysqld[1825]: 080108 10:05:52 InnoDB: Starting shutdown... Jan 8 10:05:56 [EMAIL PROTECTED] mysqld[1825]: 080108 10:05:56 InnoDB: Shutdown completed; log sequence number 1 2473367422 Jan 8 10:05:56 [EMAIL PROTECTED] mysqld[1825]: 080108 10:05:56 [Note] /usr/sbin/mysqld: Shutdown complete Jan 8 10:05:56 [EMAIL PROTECTED] mysqld[1825]: Jan 8 10:05:56 [EMAIL PROTECTED] mysqld_safe[3119]: ended Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: To do so, start the server, then issue the following commands: Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: /usr/bin/mysqladmin -u root password 'new-password' Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: /usr/bin/mysqladmin -u root -h vent password 'new-password' Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: See the manual for more instructions. Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: able to use the new GRANT command! Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: Please report any problems with the /usr/bin/mysqlbug script! Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: The latest information about MySQL is available on the web at Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: http://www.mysql.com Jan 8 10:06:10 [EMAIL PROTECTED] mysqld_safe[3379]: Support MySQL by buying support/licenses at http://shop.mysql.com Jan 8 10:06:11 [EMAIL PROTECTED] mysqld_safe[3523]: started Jan 8 10:06:12 [EMAIL PROTECTED] mysqld[3526]: 080108 10:06:12 InnoDB: Started; log sequence number 1 2473367422 Jan 8 10:06:12 [EMAIL PROTECTED] mysqld[3526]: 080108 10:06:12 [Note] /usr/sbin/mysqld: ready for connections. Jan 8 10:06:12 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] /etc/mysql/debian-start[3560]: Upgrading MySQL tables if necessary. Jan 8 10:06:12 [EMAIL PROTECTED] /etc/mysql/debian-start[3565]: ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) Jan 8 10:06:12 [EMAIL PROTECTED] /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 [EMAIL PROTECTED] /etc/mysql/debian-start[3569]: Checking for crashed MySQL tables. Jan 8 10:06:13 [EMAIL PROTECTED] /etc/mysql/debian-start[3578]: WARNING: mysqlcheck has found corrupt tables Jan 8 10:06:13 [EMAIL PROTECTED] /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 [EMAIL PROTECTED] /etc/mysql/debian-start[3578]: Jan 8 10:06:13 [EMAIL PROTECTED] /etc/mysql/debian-start[3578]: Improperly closed tables are also reported if clients are accessing Jan 8 10:06:13 [EMAIL PROTECTED] /etc/mysql/debian-start[3578]: the tables *now*. A list of current connections is below. Jan 8 10:06:13 [EMAIL PROTECTED] /etc/mysql/debian-start[3578]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Status information: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Current dir: /var/lib/mysql/ Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Running threads: 0 Stack size: 131072 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Current locks: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: lock: 0x120d350: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: lock: 0x1207500: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: lock: 0x11f9e60: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: lock: 0x11f4090: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: lock: 0x11f00b0: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: lock: 0x11e9f50: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Key caches: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: default Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Buffer_size: 16777216 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Block_size: 1024 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Division_limit: 100 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Age_limit: 300 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: blocks used: 3 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: not flushed: 0 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: w_requests: 0 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: writes: 0 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: r_requests: 6 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: reads: 3 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: handler status: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: read_key: 0 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: read_next: 4 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: read_rnd 0 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: read_first: 3 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: write: 0 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: delete 0 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: update: 0 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Table status: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Opened tables: 12 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Open tables: 6 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Open files: 14 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Open streams: 0 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Alarm status: Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Active alarms: 0 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Max used alarms: 1 Jan 8 10:12:21 [EMAIL PROTECTED] mysqld[3526]: Next alarm time: 0 Jan 8 10:12:31 [EMAIL PROTECTED] mysqld_safe[3764]: Number of processes running now: 1 Jan 8 10:12:31 [EMAIL PROTECTED] mysqld_safe[3772]: mysqld process hanging, pid 3525 - killed Jan 8 10:12:31 [EMAIL PROTECTED] mysqld_safe[3775]: restarted Jan 8 10:12:31 [EMAIL PROTECTED] mysqld[3778]: 080108 10:12:31 InnoDB: Started; log sequence number 1 2473367422 Jan 8 10:12:31 [EMAIL PROTECTED] mysqld[3778]: 080108 10:12:31 [Note] Recovering after a crash using /var/log/mysql/mysql-bin Jan 8 10:12:31 [EMAIL PROTECTED] mysqld[3778]: 080108 10:12:31 [Note] Starting crash recovery... Jan 8 10:12:31 [EMAIL PROTECTED] mysqld[3778]: 080108 10:12:31 [Note] Crash recovery finished. Jan 8 10:12:31 [EMAIL PROTECTED] mysqld[3778]: 080108 10:12:31 [Note] /usr/sbin/mysqld: ready for connections. Jan 8 10:12:31 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] mysqld[3778]: 080108 10:13:12 [Note] /usr/sbin/mysqld: Normal shutdown Jan 8 10:13:12 [EMAIL PROTECTED] mysqld[3778]: Jan 8 10:13:12 [EMAIL PROTECTED] mysqld[3778]: 080108 10:13:12 InnoDB: Starting shutdown... Jan 8 10:13:12 [EMAIL PROTECTED] mysqld_safe[3823]: Number of processes running now: 1 Jan 8 10:13:12 [EMAIL PROTECTED] mysqld_safe[3831]: mysqld process hanging, pid 3777 - killed Jan 8 10:13:12 [EMAIL PROTECTED] 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
signature.asc
Description: Digital signature

