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

When performing mass update operations execution order of update SQL statements is not ordered by itemid in the frontend

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • 1.8.5
    • Frontend (F)
    • None

      When performing mass update operations execution order of update SQL statements is not ordered by itemid in the frontend.

      That is why can appear many failed queries:

      "Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block"

      Seems that this appears due to the fact that execution order of these update sql statements is not ordered by itemid:

      update items set lastclock=1304516778,prevvalue=lastvalue,prevorgvalue=NULL,lastvalue='1' where itemid=83278;
      ...

            Unassigned Unassigned
            igor Igor Danoshaites (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: