Hi!
>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello monty,
Peter> After I got mysql/system crash I often see the following after I
Peter> bring mysql up again:
Peter> ruby:~ # w
Peter> 9:37pm up 7:35, 1 user, load average: 0.01, 0.04, 0.06
Peter> USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
Peter> root pts/0 mail.local 9:37pm 0.00s 0.07s 0.02s w
<cut>
Peter> ruby:/spylog/layers # tail -10000 /spylog/db/ruby.err | grep 45/g06hits
Peter> 010122 15:20:46 Warning: Checking table: './st45/g06hits'
Peter> 010122 15:20:46 Warning: Recovering table: './st45/g06hits'
Peter> mysqladmin debug reports no table locks active
Peter> I saw this many times on different machines and this sequince never
Peter> resolves itself ( the locks never disapears). Always the only way to
Peter> fix this is to kill one of the queries. I killed query #16 and
Peter> situation momentaly fixed:
<cut>
Can you kill any thread when this happens to resolve the problem?
Looks very strange; There is probably some broadcast that is missing
after a table is repaired. I shall try to simulate this. It
shouldn't be that hard.
Peter> The log also shows the table was repaired long ago:
Peter> 010122 15:16:35 Warning: Checking table: './st31/g07pages'
Peter> 010122 15:16:36 Warning: Recovering table: './st31/g07pages'
Peter> Hope this will somehow point the problem :)
Peter> P.S You anyway write two messages to a log file then a table is
Peter> automatically repaired. I think there might be a good idea to add
Peter> third message indicating the table was fixed successfully.
I will do that.
Regards,
Monty
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
