Forum Discussion
Arthur_7109
Nimbostratus
Jul 02, 2010MySQL 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
- Ido_Breger_3805Historic F5 AccountHi,
- Arthur_7109
Nimbostratus
OK thanks I'l open a case then.
Recent Discussions
Related Content
DevCentral Quicklinks
* Getting Started on DevCentral
* Community Guidelines
* Community Terms of Use / EULA
* Community Ranking Explained
* Community Resources
* Contact the DevCentral Team
* Update MFA on account.f5.com
Discover DevCentral Connects