Inefficient update queries when syncing configuration to Zabbix proxy

XMLWordPrintable

    • Type: Incident report
    • Resolution: Unresolved
    • Priority: Trivial
    • 8.0.0beta1 (master)
    • Affects Version/s: 7.0.25rc1, 7.4.8rc1
    • Component/s: Proxy (P)
    • None

      There are such queries for each item to be inserted.

      "update items set interfaceid=null,master_itemid=null where itemid=628726;.update items set interfaceid=null,master_itemid=null where itemid=87557;.update items set interfaceid=null,master_itemid=null where itemid=463432;

      Expected:
      Items are not present in database, they shouldn't be updated.
      If updated then they should be updated using id list, not duplicating update for each id.

            Assignee:
            Zabbix Development Team
            Reporter:
            Vladislavs Sokurenko
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: