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