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='200002273' AND account_id='25'

 

mysql error: Deadlock found when trying to get lock; try restarting transaction

 

 

mysql error number: 1213

 

 

Date: Tuesday 29th 2010f June 2010 01:23:28 PM

 

Script: /dms/policy/lrn_negsigs.php

 

Referer: https://bigip/dms/policy/lrn_negsigs.php

 

-----

 

 

Any idea how bad this is, and how to fix it?

 

 

Also, does the ASM MySQL database require any maintenance?

 

 

Are there any guidelines, tips or best practices for ASM MySQL database management and maintenance?

 

 

Thanks,

 

 

Arthur
app sec
BIG-IP Access Policy Manager (APM)
security
  • Ido_Breger_3805's avatar
    Ido_Breger_3805
    Historic F5 Account
    Jul 04, 2010
    Hi,

     

    This needs to be looked by F5 Support, I suggest to open a support case.

     

    The ASM database doesn't require maintenance or specific management.
  • 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.