Forum Discussion

Arthur_7109's avatar
Arthur_7109
Icon for Nimbostratus rankNimbostratus
Jul 02, 2010

MySQL errors and database maintenance

Hi there,     We are regularly seeing this ASM database error message:     -----   Database error in ASM:     Invalid SQL: DELETE FROM LRN_NEGSIG_SIGNATURES WHERE sig_id='...
app sec
BIG-IP Access Policy Manager (APM)
security
Arthur_7109's avatar
Arthur_7109
Icon for Nimbostratus rankNimbostratus
Jul 05, 2010
OK thanks I'l open a case then.

 

 

Also I will try this:

 

 

MySQL recovery and optimization (CR121832)

 

 

This release includes the following tools:

 

 

* recover_db.pl - This tool allows MySQL to recover when it becomes corrupted.

 

* optimize_db.pl - This tool allows you to run the MySQL optimize command on Application Security Manager tables.

 

 

To run these tools, open the command line interface utility and run the following commands: /usr/share/ts/bin/recover_db.pl or /usr/share/ts/bin/optimize_db.pl.