Package: mysql-server Version: 5.0.32-3 Severity: important
Subject: mysql-server-5.0: upgrade of mysql tables fails Package: mysql-server-5.0 Version: 5.0.32-3 Severity: important After the last mysql upgrade (from 5.0.32-2) I have noticed that the following error messages appear in syslog on every reboot: ================= 8< =============== Feb 5 12:16:13 localhost /etc/mysql/debian-start[1497]: Checking for crashed MySQL tables. Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: WARNING: mysqlcheck has found corrupt tables Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: wikidb.wiki_archive Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: error : Table upgrade required. Please do "REPAIR TABLE wiki_archive" to fix it! Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: wikidb.wiki_categorylinks Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: error : Table upgrade required. Please do "REPAIR TABLE wiki_categorylinks" to fix it! Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: wikidb.wiki_filearchive Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: error : Table upgrade required. Please do "REPAIR TABLE wiki_filearchive" to fix it! Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: wikidb.wiki_image Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: error : Table upgrade required. Please do "REPAIR TABLE wiki_image" to fix it! Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: wikidb.wiki_imagelinks Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: error : Table upgrade required. Please do "REPAIR TABLE wiki_imagelinks" to fix it! [ similar lines skipped ] Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: wikidb.wiki_watchlist Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: error : Table upgrade required. Please do "REPAIR TABLE wiki_watchlist" to fix it! Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: Improperly closed tables are also reported if clients are accessing Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: the tables *now*. A list of current connections is below. Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: +----+------------------+-----------+----+---------+------+-------+------------------+ Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: | Id | User | Host| db | Command | Time | State | Info | Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: +----+------------------+-----------+----+---------+------+-------+------------------+ Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: | 5 | debian-sys-maint | localhost | | Query | 0 | | show processlist | Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: +----+------------------+-----------+----+---------+------+-------+------------------+ Feb 5 12:16:16 localhost /etc/mysql/debian-start[1593]: Uptime: 3 Threads: 1 Questions: 69 Slow queries: 0 Opens: 61 Flush tables: 1 Open tables: 31 Queries per second avg: 23.000 Feb 5 12:16:16 localhost /etc/mysql/debian-start[1595]: Upgrading MySQL tables if necessary. Feb 5 12:16:17 localhost /etc/mysql/debian-start[1598]: This script updates all the mysql privilege tables to be usable by Feb 5 12:16:17 localhost /etc/mysql/debian-start[1598]: MySQL 4.0 and above. Feb 5 12:16:17 localhost /etc/mysql/debian-start[1598]: Feb 5 12:16:17 localhost /etc/mysql/debian-start[1598]: This is needed if you want to use the new GRANT functions, Feb 5 12:16:17 localhost /etc/mysql/debian-start[1598]: CREATE AGGREGATE FUNCTION, stored procedures, or Feb 5 12:16:17 localhost /etc/mysql/debian-start[1598]: more secure passwords in 4.1 Feb 5 12:16:17 localhost /etc/mysql/debian-start[1598]: Feb 5 12:16:17 localhost /etc/mysql/debian-start[1598]: done ================ >8 ================= I have corrected this by running mysqlcheck manually # mysqlcheck --check-upgrade --all-databases --auto-repair \ --user=debian-sys-maint --password=XXXXXXX But I believe this had to be done automatically after an upgrade or/and on a reboot/service restart. -- System Information: Debian Release: 4.0 APT prefers testing APT policy: (500, 'testing'), (100, 'unstable'), (1, 'experimental') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.19-minimal Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8) Versions of packages mysql-server-5.0 depends on: ii adduser 3.102 Add and remove users and groups ii debconf [debconf-2.0] 1.5.11 Debian configuration management sy ii libc6 2.3.6.ds1-10 GNU C Library: Shared libraries ii libdbi-perl 1.53-1 Perl5 database interface by Tim Bu ii libgcc1 1:4.1.1-21 GCC support library ii libmysqlclient15off 5.0.32-3 mysql database client library ii libncurses5 5.5-5 Shared libraries for terminal hand ii libreadline5 5.2-2 GNU readline and history libraries ii libstdc++6 4.1.1-21 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-12 Wietse Venema's TCP wrappers libra ii lsb-base 3.1-22 Linux Standard Base 3.1 init scrip ii mysql-client-5.0 5.0.32-3 mysql database client binaries ii mysql-common 5.0.32-3 mysql database common files (e.g. ii passwd 1:4.0.18.1-6 change and administer password and ii perl 5.8.8-7 Larry Wall's Practical Extraction ii psmisc 22.3-1 Utilities that use the proc filesy ii zlib1g 1:1.2.3-13 compression library - runtime Versions of packages mysql-server-5.0 recommends: ii mailx 1:8.1.2-0.20050715cvs-1 A simple mail user agent -- System Information: Debian Release: 4.0 APT prefers testing APT policy: (500, 'testing'), (100, 'unstable'), (1, 'experimental') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.19-minimal Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8) Versions of packages mysql-server depends on: ii mysql-server-5.0 5.0.32-3 mysql database server binaries mysql-server recommends no packages. -- debconf information: mysql-server/nis_warning: mysql-server/really_downgrade_from_41: false mysql-server/mysql_update_hints1: mysql-server/start_on_boot: true mysql-server/postrm_remove_databases: false * mysql-server/mysql_install_db_notes: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
