[axxs-sysadmin] severe database corruption problems on indymedia.org.nz
aotearoa at kodeaffe.de
Tue Feb 6 18:49:11 PST 2007
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:
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?
_ 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
Size: 189 bytes
Desc: Digital signature
Url : http://lists.indymedia.org/pipermail/axxs-sysadmin/attachments/20070207/a8a2a4ee/attachment.pgp
More information about the axxs-sysadmin