For more information regarding the security incident at F5, the actions we are taking to address it, and our ongoing efforts to protect our customers, click here.

Forum Discussion

Arthur_7109's avatar
Arthur_7109
Icon for Nimbostratus rankNimbostratus
16 years ago

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

2 Replies

  • Ido_Breger_3805's avatar
    Ido_Breger_3805
    Historic F5 Account
    16 years ago
    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
    16 years ago
    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.