-
Incident report
-
Resolution: Fixed
-
Critical
-
2.0.0rc4
-
PostgreSQL 8.4
PostgreSQL deadlock while trying to delete 3 hosts with linked templates.
- 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]
- 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.]
- ?????? ??? ?????????? 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')) "
- duplicates
-
ZBX-2494 deadlock between server and frontend
- Closed