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

item.update produces useless delete and update statements for item_preproc table

    XMLWordPrintable

    Details

    • Team:
      Team B
    • Sprint:
      Sprint 71 (Dec 2020), Sprint 72 (Jan 2021)
    • Story Points:
      0.75

      Description

      Steps to reproduce:

      1. open any item with pre-processing steps
      2. press [Update] button

      Result:
      In the debug output can see useless SQL statements:

      SQL (0.000142): DELETE FROM item_preproc WHERE itemid='32442'
      SQL (0.000299): SELECT nextid FROM ids WHERE table_name='item_preproc' AND field_name='item_preprocid' FOR UPDATE
      SQL (0.000141): UPDATE ids SET nextid=81158 WHERE table_name='item_preproc' AND field_name='item_preprocid'
      SQL (0.000364): INSERT INTO item_preproc (itemid,step,type,params,error_handler,error_handler_params,item_preprocid) VALUES ('32442','1','11','/resultset/row[field/text()=''Aborted_clients'']/field[@name=''Value'']/text()','0','','81157'),('32442','2','10','','0','','81158')

      Such statements are generated for each inherited item.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sasha Alexander Vladishev
              Reporter:
              sasha Alexander Vladishev
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: