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

Details

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

    Description

      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;
      ...

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: