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

trends tables failing to update when bogus future data is present

    XMLWordPrintable

Details

    • Incident report
    • Status: Open
    • Trivial
    • Resolution: Unresolved
    • 6.2.0, 6.2.1
    • None
    • Server (S)
    • None
    • Ubuntu 20.04, MariaDB

    Description

      Steps to reproduce:

      1. Temporarily set server time forward eg. by 6 months
      2. Start Zabbix server and let it run for a while so it updates trends tables; this will cause bogus "future" data (clock > now()) to be saved to tables trends and trends_uint
      3. Restart server with correct time

      Result:

      • Tables trends and trends_uint fail to update, without error messages in the server log

      Expected:

      • error message in the server logs, or
      • server updates trends nonetheless

      Workaround implemented:

      • cron job to update items with max(clock) from the trends tables
      • trigger to indicate max(clock) > now()

      Attachments

        Activity

          People

            igorbach Igor Gorbach
            pholzleitner Peter Holzleitner
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: