MySQL problem - filesystem?

[Martin Och]

---------- Original Message -----------
From: Dalibor Straka <dast na panelnet.cz>
To: Diskuse o Linuxu v cestine <linux na linux.cz>
Sent: Sat, 24 May 2008 02:42:48 +0200
Subject: Re: MySQL problem - filesystem?

> On Sat, May 24, 2008 at 01:29:13AM +0200, Martin Och wrote:
> > Dobry vecer,
> > 
> > zacal jsem dnes bojovat s:
> > 
> > 080523 11:55:56 [ERROR] /usr/libexec/mysqld: Table './tablemane' is
> > marked as crashed and last (automatic?) repair failed
> > 080523 12:52:35 [ERROR] Got error 127 when reading table './othertable'
> > 080524  0:57:48 [ERROR] /usr/libexec/mysqld: Table './othertable' is
> > marked as crashed and should be repaired
> > 
> > Netusite nekdo co se MySQL nelibi? Po repairu se tvari tabulky OK, ale nemam
> > moznost proverit, jestli se z nich neco neztratilo.
> > 
> V dmesg nejsou nejake zpravy od radice disku? Smartctl -a /dev/xxx
> neukazuje nejake chyby? Tabulka muze byt oznacena jako crash i 
> v pripade, ze neco natvrdo zabije mysql, nebo pri LOCK TABLES.
> 

Nee, disky jsou OK (smartctl), raid je OK (mdstat).
Jak jste to myslel s tim lock tables?

--
Martin Och
http://www.och.cz
http://www.3foto.cz