Details
-
Type:
Bug
-
Status: Closed
-
Resolution: Not a Bug
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
I have a database with 13.000 tables on a dedicated MySQL server. Running MariaDB 5.2.10. I currently notice tables continuously crashing, syslog shows for such tables:
===
Mar 7 22:45:20 mysql2 mysqld: 120307 22:45:20 [ERROR] mysqld: Incorrect key file for table './mx_messages/table_nl.MYI'; try to repair it
Mar 7 23:03:35 mysql2 mysqld: 120307 23:03:35 [ERROR] mysqld: Table './mx_messages/table_nl' is marked as crashed and should be repaired
Mar 7 23:03:35 mysql2 mysqld: 120307 23:03:35 [Warning] Checking table: './mx_messages/table_nl'
Mar 7 23:03:35 mysql2 mysqld: 120307 23:03:35 [Warning] Recovering table: './mx_messages/table_nl'
Mar 7 23:06:13 mysql2 mysqld: 120307 23:06:13 [Note] Found 5427 of 5541 rows when repairing './mx_messages/table_nl'
===
I'm 100% sure the tables weren't corrupted earlier, because I did a full check/repair of all tables when things were not busy (I firewalled all external servers temporarily). We have around 20 servers writing to these tables at fast rate using REPLACE INTO. I'll upload the syslog, table structure, and part of the general log (private/confidential). This is on Debian Linux.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: MyISAM tables continuously crashing
This was caused by https://bugs.launchpad.net/maria/+bug/917689
Launchpad bug id: 949456
Re: MyISAM tables continuously crashing
Hi,
If, as discussed on IRC, the root cause of the table corruption is server crashes due to a problem with archive tables, should we close this bug?