maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

Well, didn't found a solution, luckly i moved the aria log file, and
executed manually aria_chk

Just to report and log here in list if anyone have this problem maybe this
can help:

--------------------------
#  aria_chk -Tev --datadir=./ DB/TABLE
Checking Aria file: DB/TABLE
Data records: 1816203   Deleted blocks:       0
aria_chk: warning: Table is marked as crashed
- check file-size
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check data record references index: 6
- check data record references index: 7
- check data record references index: 8
- check data record references index: 9
- check data record references index: 10
- check data record references index: 11
- check data record references index: 12
- check data record references index: 13
- check records and index references
aria_chk: error: Found row with transaction id 308245601 when max
transaction id according to aria_control_file is 298273610
Max transaction id found: 355465377
Aria table 'DB/TABLE' is corrupted
Fix it using switch "-r" or "-o"

--------------------------

this helped, the aria control file was useless (since i removed - aria_chk:
error: Found row with transaction id 308245601 when max transaction id
according to aria_control_file is 298273610)
I checked data with some others tables and it seens ok

thanks guys