---------- Forwarded message ---------- From: Ivan Kurmanov <duraley@gmail.com> Date: Sat, Jan 28, 2012 at 11:40 PM Subject: Fwd: WARNING: mysqlcheck has found corrupt tables To: Dan Hayes <dhayes501@gmail.com>, Christian Zimmermann < zimmermann@stlouisfed.org> We seem to have an issue with the mysql database. It started with just one table (cit_doc_similarity), but now many more tables are affected. I've just disabled most cronjobs which use mysql, directly or indirectly. But the RAS service web frontend is still running and accessing the database. We need to recover these tables, and the RAS web frontend needs to be disabled in the meantime -- otherwise it may interfere. -i ---------- Forwarded message ---------- From: root <root@authors.repec.org> Date: Sun, Jan 29, 2012 at 12:13 AM Subject: WARNING: mysqlcheck has found corrupt tables To: root@authors.repec.org acis.cit_doc_similarity warning : 1 client is using or hasn't closed the table properly acis.cit_old_sug warning : 1 client is using or hasn't closed the table properly acis.cit_sug warning : 1 client is using or hasn't closed the table properly acis.citation_events warning : 1 client is using or hasn't closed the table properly acis.citations warning : 1 client is using or hasn't closed the table properly acis.citations_deleted warning : 1 client is using or hasn't closed the table properly acis.events warning : 2 clients are using or haven't closed the table properly acis.events_last_archived warning : 2 clients are using or haven't closed the table properly acis.names warning : 1 client is using or hasn't closed the table properly acis.records warning : 1 client is using or hasn't closed the table properly acis.rp_suggestions warning : 2 clients are using or haven't closed the table properly acis.session_history warning : 2 clients are using or haven't closed the table properly acis.sysprof warning : 2 clients are using or haven't closed the table properly acis.threads warning : 1 client is using or hasn't closed the table properly acis.users warning : 1 client is using or hasn't closed the table properly rdb.institutions warning : 1 client is using or hasn't closed the table properly rdb.objects warning : 1 client is using or hasn't closed the table properly rdb.relations warning : 1 client is using or hasn't closed the table properly rdb.res_creators_bulk warning : 1 client is using or hasn't closed the table properly rdb.res_creators_separate warning : 1 client is using or hasn't closed the table properly rdb.resources warning : 1 client is using or hasn't closed the table properly rdb.sid_id_to_handle warning : 1 client is using or hasn't closed the table properly rdb.sid_last_numbers 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 | +----+------------------+-----------+----+---------+------+-------+------------------+ | 20 | debian-sys-maint | localhost | | Query | 0 | | show processlist | +----+------------------+-----------+----+---------+------+-------+------------------+ Uptime: 3561 Threads: 1 Questions: 22854 Slow queries: 17 Opens: 231 Flush tables: 1 Open tables: 64 Queries per second avg: 6.418