bayes_token is marked as crashed

[LuKreme <kr...@kreme.com>]

I am getting the following error repeated many times a second:

/usr/local/libexec/mysqld: Table './bayes/bayes_token' is marked as crashed and should be repaired


-- 
"My parents were unwilling to secure the necessary eagle's eggs and lion
semen"

Re: bayes_token is marked as crashed

["Kevin A. McGrail" <KM...@PCCC.com>]

On 9/2/2014 7:07 PM, LuKreme wrote:
> I am getting the following error repeated many times a second:
>
> /usr/local/libexec/mysqld: Table './bayes/bayes_token' is marked as crashed and should be repaired
Shutdown spamassassin, shutdown mysql and look into myisamchk is my best 
recommendation.

Something like this untested command from memory might help since you 
likely had an unclean shutdown and need to check more than just that table.

cd /var/lib/mysql/data && find | grep -r .MYI$ | xargs myisamchk -c -s -r

regards,
KAM

Re: bayes_token is marked as crashed

[LuKreme <kr...@kreme.com>]

On 02 Sep 2014, at 17:16 , Reindl Harald <h....@thelounge.net> wrote:
> Am 03.09.2014 um 01:07 schrieb LuKreme:
>> I am getting the following error repeated many times a second:
>> 
>> /usr/local/libexec/mysqld: Table './bayes/bayes_token' is marked as crashed and should be repaired
> 
> well, "repair table bayes_token" in MySQL

That's, I tried that, but I think I forgot to \u hayes to select the right database.

I ended up doing

myisamchk --recover './bayes/bayes_token'

> or use the following option in /etc/my.cnf to have that happening
> automatically since you can't really do anything else then
> restore a backup you should have anyways automatd with a history
> 
> myisam-recover-options = "FORCE"

Interesting. I don't seem to HAVE a my.cnf. I'll check on that and add this.

-- 
The only reason for walking into the jaws of Death is so's you can steal
His gold teeth. --Colour of Magic

Re: bayes_token is marked as crashed

[Reindl Harald <h....@thelounge.net>]

Am 03.09.2014 um 01:07 schrieb LuKreme:
> I am getting the following error repeated many times a second:
> 
> /usr/local/libexec/mysqld: Table './bayes/bayes_token' is marked as crashed and should be repaired

well, "repair table bayes_token" in MySQL

or use the following option in /etc/my.cnf to have that happening
automatically since you can't really do anything else then
restore a backup you should have anyways automatd with a history

myisam-recover-options = "FORCE"