MichaelM
Sep 25, 2015Altostratus
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