Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-9356

Alter Server behaviour when an history/trend insert query fails

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Won't fix
    • Affects Version/s: 2.4.3
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
    • Environment:
      mysql 5.5 redhat 6.5

      Description

      When breaking your mysql historical partitions, you cannot add a given sets of data to your mysql database.

      [Z3005] query failed: [1526] Table has no partition for value 1425297600 [insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (1907943,1425297600,1,124427,124427,124427),
      ...

      Ok, that's natural to break your data if you cannot add to your database. And i already monitor zabbix_server.log for errors like this.

      But your data gets flushed out and cache is not used to store it.
      Zabbix Server knows that it did not insert successfully to the database, so it should hold that data in History Cache until it can safely store it. This behavior would then fit perfectly with the description of History Cache (text and uint) usage:

      "History cache stores item and timestamp information for all item types as well as value for the numeric types. A low number indicates performance problems on the database side."
      From https://www.zabbix.com/documentation/2.4/manual/config/items/itemtypes/internal

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            fpaternot Filipe Paternot
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: