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

PostgreSQL deadlock while updating hosts table

XMLWordPrintable

    • Sprint 50 (Mar 2019), Sprint 51 (Apr 2019)
    • 0.5

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

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

              Created:
              Updated:
              Resolved: