[debian-mysql] Bug#479697: mysql-server-5.0: corrupt table check reports wrong info

Jan De Luyck bugs_debian at kcore.org
Tue May 6 07:44:30 UTC 2008


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


The corrupt table check which is launched at start of mysqld is 
reporting the following info:

(copy paste of mail)

Subject: WARNING: mysqlcheck has found corrupt tables

Date: Tue, 06 May 2008 09:33:25 +0200
X-Length: 1452
X-UID: 2746

524
0
0
0
6
425
11
833
160
30
644
1464
86
1774
0
2
0
2
29
0
2359
966
7071
0
7070
45
0
1
0
36
401
825
475
0
0
0
0
0
0
0
0
0
4
0
1
406
0
0
151
17
9
0
1
0
0
1
2

 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             
|
+----+------------------+-----------+----+---------+------+-------+------------------+
| 64 | debian-sys-maint | localhost |    | Query   | 0    |       | show 
processlist |
+----+------------------+-----------+----+---------+------+-------+------------------+
Uptime: 3  Threads: 1  Questions: 186  Slow queries: 0  Opens: 59  Flush 
tables: 1  Open tables: 53  Queries per second avg: 62.000


Checking the tables with mysqlcheck reveals no problems:

root at whocares:/etc/mysql# /usr/bin/mysqlcheck 
--defaults-file=/etc/mysql/debian.cnf --auto-repair -A 
amarok.admin                                       OK
amarok.album                                       OK
amarok.amazon                                      OK
amarok.artist                                      OK
amarok.composer                                    OK
amarok.devices                                     OK
amarok.directories                                 OK
amarok.embed                                       OK
amarok.genre                                       OK
amarok.images                                      OK
amarok.labels                                      OK
amarok.lyrics                                      OK
amarok.playlists                                   OK
amarok.podcastchannels                             OK
amarok.podcastepisodes                             OK
amarok.podcastfolders                              OK
amarok.related_artists                             OK
amarok.statistics                                  OK
amarok.tags                                        OK
amarok.tags_labels                                 OK
amarok.uniqueid                                    OK
amarok.year                                        OK
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

What can be done to get rid of this?

Kind regards,

Jan

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

Kernel: Linux 2.6.24.4 (SMP w/2 CPU cores; PREEMPT)
Locale: LANG=en_GB.ISO-8859-15, LC_CTYPE=en_GB.ISO-8859-15 (charmap=ISO-8859-15)
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+b1        Perl5 database interface by Tim Bu
ii  libgcc1                1:4.3.0-4         GCC support library
ii  libmysqlclient15off    5.0.51a-5         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-4           The GNU Standard C++ Library v3
ii  libwrap0               7.6.q-15          Wietse Venema's TCP wrappers libra
ii  lsb-base               3.2-12            Linux Standard Base 3.2 init scrip
ii  mysql-client-5.0       5.0.51a-5         MySQL database client binaries
ii  mysql-common           5.0.51a-5         MySQL database common files
ii  passwd                 1:4.1.1-1         change and administer password and
ii  perl                   5.10.0-9          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-3 A simple mail user agent
ii  libhtml-template-p 2.9-1                 HTML::Template : A module for usin
ii  mailx              1:20071201-3          Transitional package for mailx ren

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





More information about the pkg-mysql-maint mailing list