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

Configuration cache sync returning 0 triggers and functions intermittently

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Trivial
    • Resolution: Cannot Reproduce
    • None
    • None
    • Server (S)
    • None

    Description

       Hello,

      As part of a hardware refresh, we've recently failed over our database from one cluster, to another. Same OS version (Xenial 16.04.1, kernel 4.4.0-31-generic), same MySQL version (Percona-Server-5.7.21-20-Linux.x86_64.ssl100), the only difference is the underlying hardware. Since this was performed, we're seeing trigger processing fail intermittently. This occurs at some point after the configuration cache is synced (600s interval). We believe we've narrowed down why the processing failures occur, which are due to the configuration cache sync returning zero triggers and zero functions.

      Again, this occurs intermittently, but enough that it renders monitoring useless for the period of time, sometimes hitting up to 45 minutes. Once we failed back to the original cluster, the issue subsided and trigger processing is normal. Looking at the queries that are run during the config sync, nothing is failing and according to mysql, each query is running fine and returning the expected ~3m rows.

      I've attached the output from DCsync_configuration(), indicating what we are seeing. Any direction on how to debug this issue would be greatly appreciated.

      Zabbix Version: 3.0.5

      Attachments

        1. bad_zbx_sync
          17 kB
        2. bad_zbx_sync2
          23 kB
        3. good_zbx_sync
          18 kB
        4. good_zbx_sync2
          23 kB
        5. zabbix_new_hw_cfg
          6 kB
        6. zabbix_new_hw_globals
          250 kB

        Activity

          People

            kpavars Kristians Pavars
            andrew.boren Andrew Boren
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: