[Sysadmin] Fwd: WARNING: mysqlcheck has found corrupt tables
David Kaufman
david at gigawatt.com
Tue Apr 24 10:45:01 CDT 2012
It seems like our db issues continue...
-------- Original Message --------
Subject: WARNING: mysqlcheck has found corrupt tables
Date: Mon, 23 Apr 2012 06:52:55 -0500 (CDT)
From: root at tron.evolt.org (root)
To: root at tron.evolt.org
test_evolt_org.sessions
warning : 1 client is using or hasn't closed the table properly
www_evolt_org.accesslog
warning : 1 client is using or hasn't closed the table properly
error : Wrong bytesec: 0-0-0 at linkstart: 3101548
error : Corrupt
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 : 2 clients are using or haven'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 : Found 23436 keys of 23437
error : Corrupt
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
|
+----+------------------+-----------+----+---------+------+-------+------------------+
| 21 | debian-sys-maint | localhost | | Query | 0 | | show
processlist |
+----+------------------+-----------+----+---------+------+-------+------------------+
Uptime: 152 Threads: 1 Questions: 698 Slow queries: 0 Opens: 288
Flush tables: 1 Open tables: 64 Queries per second avg: 4.592
More information about the Sysadmin
mailing list