MySQL Forums
Forum List  »  Archive Storage Engine

ARCHIVE crash after power failure
Posted by: Piotr Czachur
Date: February 02, 2009 03:25AM


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:

Options: ReplyQuote

Written By
ARCHIVE crash after power failure
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.