ARCHIVE crash after power failure
Hello!
Do you guys use ARCHIVE on production systems? I want to warn you, that last week after power failure, the only one ARCHIVE table I was using, caused my server to be unavailable.
2 CPUs were working 100% while MySQL was trying to repair that table. It was impossible to run any query, because server was so busy. In result data in table was corrupted, despite `check table` successful result.
What's more surprising, in some rows, I have found /var/lib/mysql dir listing, and what is also very surprising, select * from this table is causing MySQL do die. Details on this bug can be founf here:
http://bugs.mysql.com/bug.php?id=29250
Subject
Views
Written By
Posted
ARCHIVE crash after power failure
9086
February 02, 2009 03:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.