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

Incorrect order of proxy DB updates -> query failed

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • 7.0.12rc1
    • Proxy (P)
    • None

      Have a host assigned to an active proxy, having Agent and SNMP interfaces added on the host, one ICMP item created and belonged to Agent's interface.
      Proxy receives this configuration successfully:

       42371:20250403:170832.632 received configuration data from server at "1.2.3.4", datalen 3520
      

      Then quickly (up to 60 seconds, probably caused by ConfigFrequency on server) make these changes:
      1. Change interface used by the item from Agent to SNMP.
      2. Remove the unused now Agent interface from the host.

      Watch proxy log and get this error during the 60 seconds:

       42371:20250403:170932.232 received configuration data from server at "1.2.3.4", datalen 3747
       42371:20250403:170932.244 [Z3005] query failed: [1451] Cannot delete or update a parent row: a foreign key constraint fails (`proxy`.`items`, CONSTRAINT `c_items_4` FOREIGN KEY (`interfaceid`) REFERENCES `interface` (`interfaceid`)) [delete from interface where interfaceid=51]
       42371:20250403:170932.244 cannot process received configuration data from server at "1.2.3.4": cannot remove old objects from table "interface"
      

      this block will be repeated each 1 minute.

      Note - if make a 1 minute pause between steps 1 and 2 and receive an intermediate config update on proxy - the issue does not happen, because on 2nd update the proxy deletes the interface when its already not used by any item.

      This seem to be not happening on 6.0, because described steps were used many times (periodic routines) when being on 6.0. The issue started to appear soon after upgrade to 7.0.
      But this point was not specifically tested for 6.0

      Reproduced using current 7.0.12rc1 on server and proxy.

            zabbix.dev Zabbix Development Team
            zalex_ua Oleksii Zagorskyi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: