Forum Discussion

palli_69943's avatar
palli_69943
Icon for Nimbostratus rankNimbostratus
Feb 23, 2015
Solved

AVR MySQL Error

After updating to 11.5.1 HF7 I start to see errors like this on one of our active/standby configure LTMs.

monpd|ERR|Feb 23 20:10:10.020|18506| [DB::run_sql_query, mysql_query_safe] Error executing SQL query:
EXECUTE stmt_select_table_with_too_many_partitions USING @table_name,@table_name
 Because : Unknown prepared statement handler (stmt_select_table_with_too_many_partitions) given to EXECUTE

I tried restarting 

monpd
without success. (
bigstart restart monpd
)

Is the only course of action to wipe the AVR database?

application delivery
avr
LTM
management
mysql
  • dickeypjeep_116's avatar
    dickeypjeep_116
    Feb 25, 2015

    I'd first try just restarting monp first, (bigstart restart monpd). If that doesn't fix it, then yes, I'd think the SOL article you referenced is your next step.

     

4 Replies

Sort By
  • dickeypjeep_116's avatar
    dickeypjeep_116
    Icon for Cirrus rankCirrus
    Feb 25, 2015

    I'd first try just restarting monp first, (bigstart restart monpd). If that doesn't fix it, then yes, I'd think the SOL article you referenced is your next step.

     

    • Philippe_Page_2's avatar
      Philippe_Page_2
      Icon for Cirrus rankCirrus
      Oct 01, 2018

      May I ask how did you wiped the database? I also am facing the same problem. Thank you