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/