Aria spontaneous corruption
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MariaDB |
New
|
Undecided
|
Unassigned | ||
Bug 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.
| Elena Stepanova (elenst) wrote | #1 |
| Dreas van Donselaar (dreas-9) wrote | #2 |
Hi Dreas,
There have been quite a lot of changes, including fixes for related or similar bugs you filed; so it's quite possible that this one got fixed along with them. Could you please let us know if you still experience the problem?
Thank you.