Zabbix Server DB is unstable

XMLWordPrintable

    • Type: Problem report
    • Resolution: Won't fix
    • Priority: Critical
    • None
    • Affects Version/s: None
    • Component/s: None
    • Environment:
      Zabbix 4.0.3
      DB:MySQL 5.6.10a

      Zabbix DB is using AWS Aurora MySQL.
      After Aurora fails over, there are times when items that can be acquired by Zabbix server can and can not be acquired.
      That state will continue for a long time.
      Restarting the Zabbix server process will output the values correctly.
      Is this a bug?
      Or is there a function to clear the cache of DNS?

       

      Log:
      3225:20190306:153313.135 [Z3005] query failed: [1290] The MySQL server is running with the --read-only option so it cannot execute this statement [insert into history (itemid,clock,ns,value) values (29874,1551853981,821258439,3.000000);

            Assignee:
            Arturs Lontons
            Reporter:
            da-ishi
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: