Bug ID 447693: AVR: In some cases of table corruption in the MySQL database, automatic auto-repair does not complete successfully.

Last Modified: Apr 10, 2019

Bug Tracker

Affected Product:  See more info
BIG-IP AFM, ASM, AVR(all modules)

Known Affected Versions:
11.4.1, 11.5.0, 11.5.1, 11.5.1 HF1, 11.5.1 HF10, 11.5.1 HF11, 11.5.1 HF2, 11.5.1 HF3

Fixed In:
11.6.0, 11.5.1 HF4, 11.4.1 HF6

Opened: Feb 07, 2014
Severity: 3-Major
Related AskF5 Article:
K27467883

Symptoms

AVR: In some cases of table corruption in the MySQL database, automatic table-repair does not complete successfully.

Impact

Some reports generated in the Configuration utility or from TMSH may not work and an error similar to the following appears in the monpd log: errno[126] strerror[Incorrect key file for table './logdb/log_data_current.MYI'; try to repair it].

Conditions

Sporadic MySQL errors that are not handled by AVR.

Workaround

Run a manual 'REPAIR TABLE' operation on the corrupted table using a command similar to the following (replacing 'log_data_current_ with the table name from the error message): repair table log_data_current.

Fix Information

This release corrects an issue where some reports generated from the Configuration utility or from TMSH commands did not work.

Behavior Change