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

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.0.0rc4
    • Fix Version/s: 2.0.1rc1, 2.1.0
    • Component/s: Frontend (F), Server (S)
    • Labels:
    • Environment:
      PostgreSQL 8.4

      Description

      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')) "

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: