Forum Discussion

Roman_Kral's avatar
Roman_Kral
Icon for Nimbostratus rankNimbostratus
Jul 15, 2016

mysql table is full

Hi,

I see the following in /var/log/asm:

Jul 15 14:04:32 XXXXXX crit g_server.pl[11919]: 01310027:2: ASM subsystem error `(asm_config_server.pl,F5::ASMConfig::Handler::SyncHandler::sync_ucs_file_complete): Could not load configuration while in sync recovery state: DBD::mysql::db do failed: The table 'LRN_NEGSIG_QUARANTINE_SIGNATURES' is full at /usr/lib/perl5/site_perl/F5/PrepareConf/Policy.pm line 4631.`
`


In /var/lib/mysql/mysqld.err i see the following:


`160715 12:45:40 [ERROR] /usr/sbin/mysqld: The table 'PL_POLICY_HISTORY' is full
160715 12:50:29 [ERROR] /usr/sbin/mysqld: The table 'LRN_NEGSIG_QUARANTINE_SIGNATURES' is full

This occurs on standby big-ip while active one tries to sync asm config to stanby.

According df, there is 20% free space on /var/lib/mysql.

Any idea how to fix this ?

Thanks, Roman

application delivery
ASM Advanced WAF
security

6 Replies

Sort By
  • Roman_Kral's avatar
    Roman_Kral
    Icon for Nimbostratus rankNimbostratus
    Jul 16, 2016

    This has something to do with mysql database. But don't know how to fix this on F5 environment.

     

  • Hannes_Rapp's avatar
    Hannes_Rapp
    Icon for Nimbostratus rankNimbostratus
    Jul 17, 2016

    Try resetting the ASM MySQL DB to default config (flush all DBs):

     

    https://support.f5.com/kb/en-us/solutions/public/6000/900/sol6992

     

    Do one node at a time, starting with Standby. When done, perform a config sync. That initial sync could take up to 3 min if you have 50 policies or more. If you get a chance to do a cluster failover, repeat on the unit which is currently Active.

     

    • Roman_Kral's avatar
      Roman_Kral
      Icon for Nimbostratus rankNimbostratus
      Jul 18, 2016

      Thanks for help. sol6992 was the correct sollution for me.

       

  • Hannes_Rapp_162's avatar
    Hannes_Rapp_162
    Icon for Nacreous rankNacreous
    Jul 17, 2016

    Try resetting the ASM MySQL DB to default config (flush all DBs):

     

    https://support.f5.com/kb/en-us/solutions/public/6000/900/sol6992

     

    Do one node at a time, starting with Standby. When done, perform a config sync. That initial sync could take up to 3 min if you have 50 policies or more. If you get a chance to do a cluster failover, repeat on the unit which is currently Active.

     

    • Roman_Kral's avatar
      Roman_Kral
      Icon for Nimbostratus rankNimbostratus
      Jul 18, 2016

      Thanks for help. sol6992 was the correct sollution for me.