[debian-mysql] Bug#478256: mysql-server-5.0: since last upgrade, mysql reports error when starting

[arno renevier]

Package: mysql-server-5.0
Version: 5.0.51a-4
Severity: normal

Hi, since last upgrade, each time is start mysql-server, I get a mail with
subject  WARNING: mysqlcheck has found corrupt tables and with content:

345
0
0
0
84
29880
1259065
29880
29880
197059
21001375
0
3
0
36
401
825
475
0
0
0
0
0
0
0
0
0
5

 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             |
+----+------------------+-----------+----+---------+------+-------+------------------+
| 35 | debian-sys-maint | localhost |    | Query   | 0    |       | show processlist |
+----+------------------+-----------+----+---------+------+-------+------------------+
Uptime: 1  Threads: 1  Questions: 99  Slow queries: 0  Opens: 30  Flush tables: 1  Open tables: 24  Queries per second avg: 99.000




when running mysqlcheck or myisamchk, I don't find an error.

That error report comes from check_for_crashed_tables

when running from command line:
mysql -N -b -p -e 'select concat("select count(*) from ",TABLE_SCHEMA,".", TABLE_NAME) from information_schema.TABLES where ENGINE="MyISAM"' | xargs -i mysql -N -q -p -e "{}" 

I get numbers reported in the mail (345, 0, 0, 0, 84 etc) on stdin and nothing on stderr. It looks like check_for_crashed_tables checks to see if there is anything on stdout or stderr whereas it should check only if there is something on stderr.

arno

-- System Information:
Debian Release: lenny/sid
  APT prefers unstable
  APT policy: (990, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)

Kernel: Linux 2.6.22custom
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                3.107             add and remove users and groups
ii  debconf [debconf-2.0]  1.5.21            Debian configuration management sy
ii  libc6                  2.7-10            GNU C Library: Shared libraries
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-4         MySQL database client library
ii  libncurses5            5.6+20080419-2    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  lsb-base               3.2-10            Linux Standard Base 3.2 init scrip
ii  mysql-client-5.0       5.0.51a-4         MySQL database client binaries
ii  mysql-common           5.0.51a-4         MySQL database common files
ii  passwd                 1:4.1.1-1         change and administer password and
ii  perl                   5.8.8-12          Larry Wall's Practical Extraction
ii  psmisc                 22.6-1            Utilities that use the proc filesy
ii  zlib1g                 1:1.2.3.3.dfsg-12 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  bsd-mailx [mailx]  8.1.2-0.20071201cvs-2 A simple mail user agent
ii  libhtml-template-p 2.9-1                 HTML::Template : A module for usin
ii  mailx              1:20071201-2          Transitional package for mailx ren

-- debconf information:
  mysql-server-5.0/really_downgrade: false
* mysql-server-5.0/need_sarge_compat: false
  mysql-server-5.0/start_on_boot: true
  mysql-server/error_setting_password:
  mysql-server-5.0/nis_warning:
  mysql-server-5.0/postrm_remove_databases: false
  mysql-server-5.0/need_sarge_compat_done: true
  mysql-server/password_mismatch: