Forum Discussion
AVR/monpd/MySQL error - Table is read only
Hi all,
I was wondering if somebody could explain me an error message in the LTM log (F5 BIG-IP 11.5.1-HF7).
Sep 25 18:01:30 mybigip02 err purge_mysql_logs: SQL SHOW MASTER LOGS failed: You are not using binary logging
Sep 25 18:05:21 mybigip02 err DB[18581]: monpd|ERR|Sep 25 18:05:21.708|20863| [DB::mysql_query_safe, query failed] Error (error number 1036) executing SQL string : CALL RemoveObsoleteDimensions('AVR_STAT_URL,AVR_STAT_DOS_L7_OVERVIEW_URL','AVR_DIM_URL','url_crc') Because : Table 'AVR_STAT_DOS_L7_OVERVIEW_URL_M' is read only
Sep 25 18:05:27 mybigip02 err DB[18581]: monpd|ERR|Sep 25 18:05:27.446|20863| [DB::mysql_query_safe, query failed] Error (error number 1036) executing SQL string : CALL RemoveObsoleteDimensions('AVR_STAT_USER_AGENT','AVR_DIM_USER_AGENT','user_agent_crc') Because : Table 'AVR_STAT_USER_AGENT_M' is read only
Unfortunately I'm not familiar with AVR (the device has AVR licensed and provisioned (nominal)).
Could this be related to ID 467589? ... The /usr/share/mysql/purge_mysql_logs.pl script that ships with the new install (and is run hourly via cron) throws an error. The script is meant to be exited if AAM, ASM and PSM are not provisioned, but the check is not done appropriately and it continues execution, failing later. ...
I'm also a bit puzzled by entries in /var/lib/mysql/mysqld.err:
---snippp---
150925 18:30:15 [ERROR] /usr/sbin/mysqld: Can't find file: './AVR/AVR_STAT_STAGING_ACL_D.frm' (errno: 13)
150925 18:30:15 [ERROR] /usr/sbin/mysqld: Can't find file: './AVR/AVR_STAT_STAGING_ACL_G.frm' (errno: 13)
150925 18:30:15 [ERROR] /usr/sbin/mysqld: Can't find file: './AVR/AVR_STAT_STAGING_ACL_H.frm' (errno: 13)
150925 18:30:15 [ERROR] /usr/sbin/mysqld: Can't find file: './AVR/AVR_STAT_STAGING_ACL_M.frm' (errno: 13)
150925 18:30:15 [ERROR] /usr/sbin/mysqld: Can't find file: './AVR/AVR_STAT_STAGING_ACL_T.frm' (errno: 13)
150925 18:30:15 [ERROR] /usr/sbin/mysqld: Can't find file: './AVR/AVR_STAT_STAGING_ACL_W.frm' (errno: 13)
150925 18:30:15 [ERROR] /usr/sbin/mysqld: Can't find file: './AVR/AVR_STAT_TRAFFIC_CAPTURE_T.frm' (errno: 13)
150925 18:30:16 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './AVR/AVR_STAT_DWBL_G.frm'
150925 18:30:16 [ERROR] /usr/sbin/mysqld: Can't find file: './AVR/AVR_STAT_DWBL_H.frm' (errno: 13)
150925 18:30:16 [ERROR] /usr/sbin/mysqld: Can't find file: './AVR/AVR_STAT_DWBL_M.frm' (errno: 13)
150925 18:30:16 [ERROR] /usr/sbin/mysqld: Can't find file: './AVR/AVR_STAT_DWBL_T.frm' (errno: 13)
150925 18:30:16 [ERROR] /usr/sbin/mysqld: Can't find file: './AVR/AVR_STAT_DWBL_W.frm' (errno: 13)
---snappp---
Any hint is much appreciated. cheers
1 Reply
- MichaelM
Altostratus
[update] Spoken with F5 support in the mean time. It looks that the MySQL database is broken and needs to be rebuild. Two options are available a) rebuild the AVR database via steps from SOL16894 (attempts to rebuild the database and in theory should not affect the system). b) Reinstall a fresh firmware on a new boot location may help to refresh the MySQL database.
Help guide the future of your DevCentral Community!
What tools do you use to collaborate? (1min - anonymous)Recent Discussions
Related Content
* 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
