[Sysadmin] Fwd: WARNING: mysqlcheck has found corrupt tables

David Kaufman david at gigawatt.com
Wed Apr 25 13:51:11 CDT 2012



-------- Original Message --------
Subject: WARNING: mysqlcheck has found corrupt tables
Date: Wed, 25 Apr 2012 13:49:53 -0500 (CDT)
From: root at tron.evolt.org (root)
To: root at tron.evolt.org

www_evolt_org.cache
warning  : Table is marked as crashed
warning  : 2 clients are using or haven't closed the table properly
error    : Record at pos: 33963960 is not remove-marked
error    : record delete-link-chain corrupted
error    : Corrupt
www_evolt_org.node_counter
warning  : Table is marked as crashed
error    : Checksum for key:  2 doesn't match checksum for records
error    : Checksum for key:  3 doesn't match checksum for records
error    : Checksum for key:  4 doesn't match checksum for records
error    : Corrupt
www_evolt_org.sessions
warning  : Table is marked as crashed
warning  : 3 clients are using or haven't closed the table properly
error    : Found 26935 keys of 26936
error    : Corrupt
www_evolt_org.watchdog
warning  : Table is marked as crashed
warning  : 2 clients are using or haven't closed the table properly
error    : Found 703104 keys of 703106
error    : Corrupt

  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 
             |
+----+------------------+-----------+----+---------+------+-------+------------------+
| 7  | debian-sys-maint | localhost |    | Query   | 0    |       | show 
processlist |
+----+------------------+-----------+----+---------+------+-------+------------------+
Uptime: 18  Threads: 1  Questions: 298  Slow queries: 0  Opens: 276 
Flush tables: 1  Open tables: 64  Queries per second avg: 16.556


More information about the Sysadmin mailing list