Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Incomplete
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
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.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: Aria spontaneous corruption
It has not recently reoccurred.
Launchpad bug id: 884715
maybe there's some information in aria log? i don't know if i'm right, but aria have a file where it write changes and after writing to this file, it will write to the table file, like a ext3 filesystem with journal
maybe the lost rows are inside this journal file, i done something like this in past and to solve my problem, i first flushed tables and locked for read, after this i copied some files from one server to another, and i had no errors
It has never contained enough information to reproduce the issue, and later the reporter said it stopped happening. Closing.
Re: Aria spontaneous corruption
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.