[debian-mysql] Bug#416482: mysql-client-5.0: cron is sending "WARNING: mysqlcheck has found corrupt tables" after the last upgrade

[Teodor]

Package: mysql-client-5.0
Version: 5.0.51a-5
Followup-For: Bug #416482

A couple of days ago I've upgraded mysql* packages to the version
5.0.51a-5 because they migrated from sid to lenny. Since then I keep
getting these messages every day, but they seem to be false positives.

Subject: WARNING: mysqlcheck has found corrupt tables
Date: Sun, 11 May 2008 12:24:00 +0300

714
0
0
0
6
16
101
12
559
46
40
41
81
342
121
34
80
271
35
4
69
583
5
26
2
21
146
5
7
26
15
0
0
64
0
4
1
5
10
68
33
0
8
19
39
59
40
2
0
17
40
1
0
4
0
36
401
825
475
0
0
0
0
0
0
0
0
0
8
6
2
6
161
19
3

 Improperly closed tables are also reported if clients are accessing
 the tables *now*. A list of current connections is below.

+----+------------------+-----------+----+---------+------+-------+------------------+
| Id | User             | Host      | db | Command | Time | State | Info
|
+----+------------------+-----------+----+---------+------+-------+------------------+
| 82 | debian-sys-maint | localhost |    | Query   | 0    |       | show
processlist |
+----+------------------+-----------+----+---------+------+-------+------------------+
Uptime: 2  Threads: 1  Questions: 240  Slow queries: 0  Opens: 361
Flush tables: 1  Open tables: 64  Queries per second avg: 120.000


Any manual run of 'mysqlcheck' reports no problem:
piti:~# mysqlcheck -A
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.func                                         OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
roundcube.cache                                    OK
roundcube.contacts                                 OK
roundcube.identities                               OK
roundcube.messages                                 OK
roundcube.session                                  OK
roundcube.users                                    OK


In the latest version from lenny I didn't received any of these
messages. In the mysql version from etch I ocassionly receive one
message after a power failure but after a REPAIR everything is OK.

Thanks


-- System Information:
Debian Release: lenny/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.24-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-client-5.0 depends on:
ii  debianutils            2.28.4            Miscellaneous utilities specific t
ii  libc6                  2.7-10            GNU C Library: Shared libraries
ii  libdbd-mysql-perl      4.006-1           A Perl5 database interface to the 
ii  libdbi-perl            1.604-1           Perl5 database interface by Tim Bu
ii  libgcc1                1:4.3.0-3         GCC support library
ii  libmysqlclient15off    5.0.51a-5         MySQL database client library
ii  libncurses5            5.6+20080308-1    Shared libraries for terminal hand
ii  libreadline5           5.2-3             GNU readline and history libraries
ii  libstdc++6             4.3.0-3           The GNU Standard C++ Library v3
ii  libwrap0               7.6.q-15          Wietse Venema's TCP wrappers libra
ii  mysql-common           5.0.51a-5         MySQL database common files
ii  perl                   5.8.8-12          Larry Wall's Practical Extraction 
ii  zlib1g                 1:1.2.3.3.dfsg-12 compression library - runtime

Versions of packages mysql-client-5.0 recommends:
ii  libterm-readkey-perl          2.30-3     A perl module for simple terminal 

-- no debconf information