aria_chk does not repair tables

Description

If we repair the table(s) and start the database, it works until someone tries to access a corrupt row. Then we can repair again but then again as someone tries to access a corrupt row it crashes again.

We tried to repair it using aria_chk with every possible method/option and afterwards trying to do a mysqldump but it just crashes after reaching some row.

The error we get from mysqldump:

G:\MariaDB\bin>mysqldump greyhound items_protocols -u root > items_protocols.txt
mysqldump: Error 1030: Got error 22 "Invalid argument" from storage engine Aria when dumping table `items_protocols` at row: 38910855

We even tried to delete those rows or exclude them using a where clause with the mysqldump command.

Here the create table statement:

And our my.ini:

Any suggestions what we could try other than we already did?

Environment

Windows 2008 R2 64Bit

Assignee

Elena Stepanova

Reporter

RaphaelH

Labels

None

Affects versions

Priority

Critical
Configure