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

[Dan Hayes]

Ok, let me know if you need me.  Thanks.

On Sat, Jan 28, 2012 at 4:01 PM, Ivan Kurmanov <duraley at 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 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/20120128/a610fc61/attachment.html>