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

PostgreSQL deadlock while trying to delete 3 hosts with linked templates

XMLWordPrintable

      PostgreSQL deadlock while trying to delete 3 hosts with linked templates.

      1. pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: deadlock detected ???????: Process 2558 waits for ShareLock on transaction 4791924; blocked by process 15301. Process 15301 waits for ShareLock on transaction 4791923; blocked by process 2558. ????????: See server log for query details. [include/db.inc.php:500]
      2. Error in query [DELETE FROM items WHERE (itemid IN ('24716','24668','24691','24681','24685','24665','24687','24713','24728','24731','24676','24686','24688','24669','24690','24689','24680','24671','24677','24683','24684','24714','24673','24667','24712','24672','24692','24682','24678','24679','24711','24670','24664','24727','24675','24729','24674','24666','24726','24730','24663','24715')) ] [ERROR: deadlock detected ???????: Process 2558 waits for ShareLock on transaction 4791924; blocked by process 15301. Process 15301 waits for ShareLock on transaction 4791923; blocked by process 2558. ????????: See server log for query details.]
      3. ?????? ??? ?????????? SQL ??????? "DELETE FROM items WHERE (itemid IN ('24716','24668','24691','24681','24685','24665','24687','24713','24728','24731','24676','24686','24688','24669','24690','24689','24680','24671','24677','24683','24684','24714','24673','24667','24712','24672','24692','24682','24678','24679','24711','24670','24664','24727','24675','24729','24674','24666','24726','24730','24663','24715')) "

            Unassigned Unassigned
            sire Sergey Syreskin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: