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

Last Modified: Sep 13, 2023

Affected Product(s):
BIG-IP AFM, ASM, AVR(all modules)

Known Affected Versions:
11.6.2 HF1, 11.4.1

Fixed In:
11.6.0, 11.5.1 HF4, 11.4.1 HF6

Opened: Feb 07, 2014

Severity: 3-Major

Related 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

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips