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

Change lld discovery table update approach

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • 7.0.4rc1, 7.2.0alpha1
    • None
    • Server (S)
    • None
    • S24-W30/31, S24-W34/35
    • 2

      lld_process_lost_objects() function uses 'per field' update approach. It creates multiple id vectors for different field values types and then executes single field update per each vector, for example:

      update item_discovery set ts_delete=1718646734 where itemid=47167;
      update item_discovery set status=1 where itemid=47167;
      update item_discovery set disable_source=1 where itemid=47167;
      

      This also makes harder to update relevant fields - ids might need to be removed from some vectors and added to others.

      LLD mostly uses 'per object' approach - all changes are gathered for each object, flagging the updated fields and then single update query for each object is generated, for example:

      update item_discovery set ts_delete=1718646734,status=1,disable_source=1 where itemid=47167;
      

            wiper Andris Zeila
            wiper Andris Zeila
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 8h
                8h