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:
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
