Your message dated Fri, 16 Feb 2007 03:32:07 +0000
with message-id <[EMAIL PROTECTED]>
and subject line Bug#409780: fixed in mysql-dfsg-5.0 5.0.32-5
has caused the attached Bug report 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 I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
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:
--- End Message ---
--- Begin Message ---
Source: mysql-dfsg-5.0
Source-Version: 5.0.32-5
We believe that the bug you reported is fixed in the latest version of
mysql-dfsg-5.0, which is due to be installed in the Debian FTP archive:
libmysqlclient15-dev_5.0.32-5_amd64.deb
to pool/main/m/mysql-dfsg-5.0/libmysqlclient15-dev_5.0.32-5_amd64.deb
libmysqlclient15off_5.0.32-5_amd64.deb
to pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.32-5_amd64.deb
mysql-client-5.0_5.0.32-5_amd64.deb
to pool/main/m/mysql-dfsg-5.0/mysql-client-5.0_5.0.32-5_amd64.deb
mysql-client_5.0.32-5_all.deb
to pool/main/m/mysql-dfsg-5.0/mysql-client_5.0.32-5_all.deb
mysql-common_5.0.32-5_all.deb
to pool/main/m/mysql-dfsg-5.0/mysql-common_5.0.32-5_all.deb
mysql-dfsg-5.0_5.0.32-5.diff.gz
to pool/main/m/mysql-dfsg-5.0/mysql-dfsg-5.0_5.0.32-5.diff.gz
mysql-dfsg-5.0_5.0.32-5.dsc
to pool/main/m/mysql-dfsg-5.0/mysql-dfsg-5.0_5.0.32-5.dsc
mysql-server-4.1_5.0.32-5_amd64.deb
to pool/main/m/mysql-dfsg-5.0/mysql-server-4.1_5.0.32-5_amd64.deb
mysql-server-5.0_5.0.32-5_amd64.deb
to pool/main/m/mysql-dfsg-5.0/mysql-server-5.0_5.0.32-5_amd64.deb
mysql-server_5.0.32-5_all.deb
to pool/main/m/mysql-dfsg-5.0/mysql-server_5.0.32-5_all.deb
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Christian Hammers <[EMAIL PROTECTED]> (supplier of updated mysql-dfsg-5.0
package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [EMAIL PROTECTED])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Thu, 15 Feb 2007 04:47:04 +0100
Source: mysql-dfsg-5.0
Binary: libmysqlclient15-dev mysql-client mysql-client-5.0 mysql-server
mysql-server-4.1 mysql-server-5.0 mysql-common libmysqlclient15off
Architecture: source all amd64
Version: 5.0.32-5
Distribution: unstable
Urgency: medium
Maintainer: Christian Hammers <[EMAIL PROTECTED]>
Changed-By: Christian Hammers <[EMAIL PROTECTED]>
Description:
libmysqlclient15-dev - mysql database development files
libmysqlclient15off - mysql database client library
mysql-client - mysql database client (meta package depending on the latest
versi
mysql-client-5.0 - mysql database client binaries
mysql-common - mysql database common files (e.g. /etc/mysql/my.cnf)
mysql-server - mysql database server (meta package depending on the latest
versi
mysql-server-4.1 - mysql database server (transitional package)
mysql-server-5.0 - mysql database server binaries
Closes: 403721 409780
Changes:
mysql-dfsg-5.0 (5.0.32-5) unstable; urgency=medium
.
* Backported upstream patch for a bug that crashed the server when using
certain join/group/limit combinations.
Users of the Joomla CMS seemed to be affected by this. Closes: #403721
* The debian-start script that runs on every server start now first upgrades
the system tables (if neccessary) and then check them as it sometimes did
not work the other way around (e.g. for MediaWiki). The script now uses
mysql_update instead of mysql_update_script as recommended. Closes: 409780
* Remove the Debconf generated config file in postrm.
Files:
db28a43287de05808050373efe36f166 1115 misc optional mysql-dfsg-5.0_5.0.32-5.dsc
02a77e57615de743c108b7a982387817 147841 misc optional
mysql-dfsg-5.0_5.0.32-5.diff.gz
c2aabbd8e923a77cde1641b326524f96 52508 misc optional
mysql-common_5.0.32-5_all.deb
b698463abedb4b220f3fbeb893b775ea 46196 misc optional
mysql-server_5.0.32-5_all.deb
5a56f11b0ffcda8e75ac20275a45b3ac 44122 misc optional
mysql-client_5.0.32-5_all.deb
d4cd4f30f959997b8e1096f2f12afaf4 1828446 libs optional
libmysqlclient15off_5.0.32-5_amd64.deb
71619212a64e05b7340368b40e50a87e 7367622 libdevel optional
libmysqlclient15-dev_5.0.32-5_amd64.deb
fc9df6f90f7e5448c41efc49d482c61b 7542362 misc optional
mysql-client-5.0_5.0.32-5_amd64.deb
b6fd9762fdc137af193cfa8f6e71fefb 25811746 misc optional
mysql-server-5.0_5.0.32-5_amd64.deb
62e6f494caff16b470d92cbde76af620 46224 oldlibs extra
mysql-server-4.1_5.0.32-5_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iEYEARECAAYFAkXU9cwACgkQkR9K5oahGOZ3KgCfSMyJoUoODh2oZfK3bm+LVrAe
57UAoLMQ/U6cAy3/rpD7mMFC70Zh0EiK
=sw9V
-----END PGP SIGNATURE-----
--- End Message ---
