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

[Ivan Kurmanov]

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 at 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 at 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 at authors.repec.org>
>>> Date: Sun, Jan 29, 2012 at 12:13 AM
>>> Subject: WARNING: mysqlcheck has found corrupt tables
>>> To: root at 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/
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/ras-run/attachments/20120129/306d19d7/attachment-0001.html>