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

David Kaufman david at gigawatt.com
Tue Apr 24 10:47:51 CDT 2012


And here is today's:

I wonder if root mail should go to this list instead of my a 
mostly-neglected evolt-root folder on my imap server...?

it might get more attention sometimes.

-dave

-------- Original Message --------
Subject: WARNING: mysqlcheck has found corrupt tables
Date: Tue, 24 Apr 2012 06:54:18 -0500 (CDT)
From: root at tron.evolt.org (root)
To: root at tron.evolt.org

www_evolt_org.accesslog
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.bad_behavior_log
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.cache
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.comments
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.history
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.node
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.node_comment_statistics
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.node_counter
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.profile_values
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.sequences
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.sessions
warning  : 2 clients are using or haven't closed the table properly
error    : Checksum for key:  4 doesn't match checksum for records
error    : Corrupt
www_evolt_org.spam_log
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.spam_tracker
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.term_node
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.users
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.users_roles
warning  : 1 client is using or hasn't closed the table properly
www_evolt_org.watchdog
warning  : 1 client is using or hasn't closed the table properly

  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 
             |
+----+------------------+-----------+----+---------+------+-------+------------------+
| 22 | debian-sys-maint | localhost |    | Query   | 0    |       | show 
processlist |
+----+------------------+-----------+----+---------+------+-------+------------------+
Uptime: 145  Threads: 1  Questions: 1298  Slow queries: 0  Opens: 303 
Flush tables: 1  Open tables: 64  Queries per second avg: 8.952



More information about the Sysadmin mailing list