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

PostgreSQL deadlock while updating hosts table

    XMLWordPrintable

    Details

    • Team:
      Team A
    • Sprint:
      Sprint 50 (Mar 2019), Sprint 51 (Apr 2019)
    • Story Points:
      0.5

      Description

      Steps to reproduce:

      1. Upgrade to Zabbix 4.0.5 and PostgreSQL 9.6 and pg_activity/pg_top
      2. Setup active agent auto-registration

      Result:

       51083:20190325:095811.429 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  deadlock detected
      DETAIL:  Process 61170 waits for ShareLock on transaction 1050243760; blocked by process 82093.
      Process 82093 waits for ShareLock on transaction 1050243129; blocked by process 61170.
      HINT:  See server log for query details.
      CONTEXT:  while updating tuple (44,1) in relation "hosts"
       [update hosts set status=1 where hostid=12751]
      

      See screenshots...




      Expected:
      No deadlocks...

        Attachments

          Activity

            People

            Assignee:
            vso Vladislavs Sokurenko
            Reporter:
            edgar.akhmetshin Edgar Akhmetshin
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: