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

        1. Screenshot at 2019-03-26 11-38-18.png
          Screenshot at 2019-03-26 11-38-18.png
          51 kB
        2. Screenshot at 2019-03-26 11-38-23.png
          Screenshot at 2019-03-26 11-38-23.png
          184 kB
        3. Screenshot at 2019-03-26 11-46-48.png
          Screenshot at 2019-03-26 11-46-48.png
          273 kB
        4. Screenshot at 2019-03-26 11-47-44-2.png
          Screenshot at 2019-03-26 11-47-44-2.png
          85 kB
        5. Screenshot at 2019-03-26 11-47-44-3.png
          Screenshot at 2019-03-26 11-47-44-3.png
          90 kB
        6. zabbix_server 3.log.7z
          942 kB

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

              Created:
              Updated:
              Resolved: