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

    • Sprint 71 (Dec 2020), Sprint 72 (Jan 2021)
    • 0.75

      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.

            sasha Alexander Vladishev
            sasha Alexander Vladishev
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: