[axxs-sysadmin] severe database corruption problems on indymedia.org.nz

[Sebastian]

kia ora koutou..

for 1 week or 2, we have a recurrent problem of database corruption.
we did not change any code that touches database stuff (actually none at
all until today). we see error messages like:

file not found: articles.MYI


or when running mysqlcheck:

nzdada.articles
warning  : Table is marked as crashed
error    : Key in wrong position at page 339968
error    : Corrupt


or just now:

Unknown ID Error

Database failed to return a unique record for this query, or you are not
authorized to access that record.


a simple SQL command 'repair table <table name>' or 'mysqlcheck
--auto-repair' seems to fix it, but only temporarily. i installed a cron
script today which runs mysqlcheck every 5 minutes.

i am crawling the internet at the moment for possible answers, but
perhaps any one of you has an idea?

ta,
 Sebastian
-- 
 _   ascii ribbon campaign     .oOo.   GCSd-s:+aC++ULB+++W++M+PS+++Y+
( )
 X   Jeden Tag eine Erisische Tat!
/ \  
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.indymedia.org/pipermail/axxs-sysadmin/attachments/20070207/a8a2a4ee/attachment.pgp