Re: [RAS] Fwd: WARNING: mysqlcheck has found corrupt tables
Sorry, i think Christian is right. This is a false alert. The issue is in the old nebka server, not the new one. The mail has arrived from the wustl.edu. It would be good to understand how to disable all that on the old server, to stop false alerts. -i On Sat, Jan 28, 2012 at 11:57 PM, Dan Hayes <dhayes501@gmail.com> wrote:
Ok, I'm here, what do I need to do?
On Sat, Jan 28, 2012 at 3:49 PM, Christian Zimmermann < zimmermann@stlouisfed.org> wrote:
Also, check that it is the machine at the Fed that is giving trouble.
Bob put old nebka back online, and it started sending all sorts of messages.
On Sat, 28 Jan 2012, Ivan Kurmanov wrote:
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
-- Christian Zimmermann FIGUGEGL! Economic Research Federal Reserve Bank of St. Louis P.O. Box 442 St. Louis MO 63166-0442 USA http://ideas.repec.org/zimm/
Ok, let me know if you need me. Thanks. On Sat, Jan 28, 2012 at 4:01 PM, Ivan Kurmanov <duraley@gmail.com> wrote:
Sorry, i think Christian is right. This is a false alert. The issue is in the old nebka server, not the new one. The mail has arrived from the wustl.edu.
It would be good to understand how to disable all that on the old server, to stop false alerts.
-i
On Sat, Jan 28, 2012 at 11:57 PM, Dan Hayes <dhayes501@gmail.com> wrote:
Ok, I'm here, what do I need to do?
On Sat, Jan 28, 2012 at 3:49 PM, Christian Zimmermann < zimmermann@stlouisfed.org> wrote:
Also, check that it is the machine at the Fed that is giving trouble.
Bob put old nebka back online, and it started sending all sorts of messages.
On Sat, 28 Jan 2012, Ivan Kurmanov wrote:
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
-- Christian Zimmermann FIGUGEGL! Economic Research Federal Reserve Bank of St. Louis P.O. Box 442 St. Louis MO 63166-0442 USA http://ideas.repec.org/zimm/
participants (2)
-
Dan Hayes -
Ivan Kurmanov