Your message dated Tue, 03 Oct 2006 14:42:23 +0200
with message-id <[EMAIL PROTECTED]>
and subject line Key file corruption
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
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:
--- End Message ---
--- Begin Message ---
Hello
I close this bug as it seems to be unreproducible and older than a
couple of months..
bye,
-christian-
--- End Message ---
