Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
None
-
None
-
None
Description
We've duplicate an Aria table to some servers by copying the files directly. A mysqlcheck confirms that the table is good, aria_chk also sees no issues. After a restart of MariaDB all is fine with the table as well. Now we checked again the next day, and suddenly a check indicates the table is corrupted. This happened twice now (on the same server).
:~/$ mysqlcheck -v database table
|
database.table
|
warning : Table is marked as crashed
|
error : Wrong base information on indexpage at page: 34022
|
error : Corrupt
|
:~/$
|
The actual count of rows using {{select count(*)} did not change. However, after executing a repair table many rows disappeared. Nothing is writing to this table (only reads in very low volume), so it's really strange that this spontaneously corrupts without any restarts/writing to the table.
I'll upload the original non-crashed version, and the crashed-version to FTP.