Forum Discussion

MichaelM's avatar
MichaelM
Icon for Altostratus rankAltostratus
Sep 25, 2015

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

  • [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.