Package: mysql-server-5.0 Version: 5.0.16-1 Severity: important Hi,
After a restart I got 'Incorrect key file for table' errors and 'Table '...' is marked as crashed and should be repaired' errors. >From syslog: Dec 16 19:25:09 b mysqld[19851]: 051216 18:25:09 [Note] /usr/sbin/mysqld: Normal shutdown Dec 16 19:25:09 b mysqld[19851]: Dec 16 19:25:09 b mysqld[19851]: 051216 18:25:09 InnoDB: Starting shutdown... Dec 16 19:25:12 b mysqld[19851]: 051216 18:25:12 InnoDB: Shutdown completed; log sequence number 0 43741 Dec 16 19:25:12 b mysqld[19851]: 051216 18:25:12 [Note] /usr/sbin/mysqld: Shutdown complete Dec 16 19:25:12 b mysqld[19851]: Dec 16 19:25:12 b mysqld_safe[21121]: ended Dec 16 19:25:12 b mysqld_safe[21181]: started Dec 16 19:25:13 b mysqld[21184]: 051216 18:25:13 InnoDB: Started; log sequence number 0 43741 Dec 16 19:25:13 b mysqld[21184]: 051216 18:25:13 [Note] /usr/sbin/mysqld: ready for connections. Dec 16 19:25:13 b mysqld[21184]: Version: '5.0.16-Debian_1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution Dec 16 19:25:13 b /etc/mysql/debian-start[21218]: Checking for crashed MySQL tables. Dec 16 19:26:17 b mysqld[21184]: 051216 18:26:17 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_posts.MYI'; try to repair it Dec 16 19:26:17 b mysqld[21184]: 051216 18:26:17 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_posts.MYI'; try to repair it Dec 16 19:29:07 b mysqld[21184]: 051216 18:29:07 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_topics.MYI'; try to repair it Dec 16 19:29:07 b mysqld[21184]: 051216 18:29:07 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_topics.MYI'; try to repair it Dec 16 19:29:38 b mysqld[21184]: 051216 18:29:38 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_topics.MYI'; try to repair it Dec 16 19:29:38 b mysqld[21184]: 051216 18:29:38 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_topics.MYI'; try to repair it Dec 16 19:37:05 b mysqld[21184]: 051216 18:37:05 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_posts.MYI'; try to repair it Dec 16 19:37:05 b mysqld[21184]: 051216 18:37:05 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_posts.MYI'; try to repair it Dec 16 19:37:14 b mysqld[21184]: 051216 18:37:14 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_posts.MYI'; try to repair it Dec 16 19:37:14 b mysqld[21184]: 051216 18:37:14 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_posts.MYI'; try to repair it Dec 16 19:37:36 b mysqld[21184]: 051216 18:37:36 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_posts.MYI'; try to repair it Dec 16 19:37:36 b mysqld[21184]: 051216 18:37:36 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_posts.MYI'; try to repair it Dec 16 19:38:16 b mysqld[21184]: 051216 18:38:16 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_posts.MYI'; try to repair it Dec 16 19:38:16 b mysqld[21184]: 051216 18:38:16 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './st_forum/invision_posts.MYI'; try to repair it Dec 16 19:40:04 b snmpd[32581]: Connection from UDP: [195.13.63.187]:39403 Dec 16 19:45:04 b snmpd[32581]: Connection from UDP: [195.13.63.187]:39405 Dec 16 19:50:04 b snmpd[32581]: Connection from UDP: [195.13.63.187]:39407 Dec 16 19:55:03 b snmpd[32581]: Connection from UDP: [195.13.63.187]:39409 Dec 16 20:00:04 b snmpd[32581]: Connection from UDP: [195.13.63.187]:39411 Dec 16 20:05:05 b snmpd[32581]: Connection from UDP: [195.13.63.187]:39413 Dec 16 20:05:22 b mysqld[21184]: 051216 19:05:21 [ERROR] /usr/sbin/mysqld: Table './st_forum/invision_topics' is marked as crashed and should be repaired Dec 16 20:05:22 b mysqld[21184]: 051216 19:05:21 [ERROR] /usr/sbin/mysqld: Table './st_forum/invision_topics' is marked as crashed and should be repaired Dec 16 20:05:22 b mysqld[21184]: 051216 19:05:22 [ERROR] /usr/sbin/mysqld: Table './st_forum/invision_topics' is marked as crashed and should be repaired Dec 16 20:05:22 b mysqld[21184]: 051216 19:05:22 [ERROR] /usr/sbin/mysqld: Table './st_forum/invision_topics' is marked as crashed and should be repaired Dec 16 20:05:22 b mysqld[21184]: 051216 19:05:22 [ERROR] /usr/sbin/mysqld: Table './st_forum/invision_posts' is marked as crashed and should be repaired I'm wondering, is the crashed table checker safe to run without external locking (and a busy server)? -- System Information: Debian Release: testing/unstable APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.12-1-686-smp Locale: LANG=en_US.ISO-8859-15, LC_CTYPE=en_US.ISO-8859-15 (charmap=ISO-8859-15) Versions of packages mysql-server-5.0 depends on: ii adduser 3.80 Add and remove users and groups ii debconf [debconf 1.4.59 Debian configuration management sy ii libc6 2.3.5-8 GNU C Library: Shared libraries an ii libdbi-perl 1.48-2 Perl5 database interface by Tim Bu ii libgcc1 1:4.0.2-5 GCC support library ii libmysqlclient15 5.0.16-1 mysql database client library ii libncurses5 5.5-1 Shared libraries for terminal hand ii libreadline5 5.0-11 GNU readline and history libraries ii libstdc++6 4.0.2-5 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra ii mailx 1:8.1.2-0.20050715cvs-1 A simple mail user agent ii mysql-client-5.0 5.0.16-1 mysql database client binaries ii mysql-common 5.0.16-1 mysql database common files (e.g. ii passwd 1:4.0.13-7 change and administer password and ii perl 5.8.7-9 Larry Wall's Practical Extraction ii psmisc 21.8-1 Utilities that use the proc filesy ii zlib1g 1:1.2.3-8 compression library - runtime mysql-server-5.0 recommends no packages. -- debconf information: mysql-server-5.0/really_downgrade: false mysql-server-5.0/start_on_boot: true mysql-server-5.0/mysql_update_hints1: mysql-server-5.0/nis_warning: mysql-server-5.0/postrm_remove_databases: false * mysql-server-5.0/mysql_install_db_notes: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]