ERROR: deadlock detected
DETAIL: Process 27962 waits for ShareLock on transaction 150315; blocked by process 31824.
Process 31824 waits for ShareLock on transaction 150269; blocked by process 27962.
Process 27962: DELETE FROM functions WHERE (triggerid IN (14768))
Process 31824: update functions set lastvalue='243148890' where itemid=97980 and function='prev' and parameter='0';
update functions set lastvalue='525846060' where itemid=97560 and function='prev' and parameter='0';
update functions set lastvalue='3639694180' where itemid=97260 and function='prev' and parameter='0';
update functions set lastvalue='2653642520' where itemid=96480 and function='prev' and parameter='0';
update functions set lastvalue='136925640' where itemid=96240 and function='prev' and parameter='0';
update functions set lastvalue='34636650' where itemid=96300 and function='prev' and parameter='0';
update functions set lastvalue='85876270' where itemid=96780 and function='prev' and parameter='0';
update functions set lastvalue='2260206980' where itemid=96540 and function='prev' and parameter='0';
update functions set lastvalue='1696317170' where itemid=98160 and function='prev' and parameter='0';
update functions set lastvalue='601725960' where itemid=98280 and function='prev' and parameter='0';
update func
HINT: See server log for query details.
STATEMENT: DELETE FROM functions WHERE (triggerid IN (14768))
ERROR: current transaction is aborted, commands ignored until end of transaction block
после чего долго и печально в лог пишутся ошибки
STATEMENT: DELETE FROM functions WHERE (triggerid IN (14768))
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (15
063))
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: select * from triggers where triggerid=15063
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (15
063))
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (15
071))
DETAIL: Process 27962 waits for ShareLock on transaction 150315; blocked by process 31824.
Process 31824 waits for ShareLock on transaction 150269; blocked by process 27962.
Process 27962: DELETE FROM functions WHERE (triggerid IN (14768))
Process 31824: update functions set lastvalue='243148890' where itemid=97980 and function='prev' and parameter='0';
update functions set lastvalue='525846060' where itemid=97560 and function='prev' and parameter='0';
update functions set lastvalue='3639694180' where itemid=97260 and function='prev' and parameter='0';
update functions set lastvalue='2653642520' where itemid=96480 and function='prev' and parameter='0';
update functions set lastvalue='136925640' where itemid=96240 and function='prev' and parameter='0';
update functions set lastvalue='34636650' where itemid=96300 and function='prev' and parameter='0';
update functions set lastvalue='85876270' where itemid=96780 and function='prev' and parameter='0';
update functions set lastvalue='2260206980' where itemid=96540 and function='prev' and parameter='0';
update functions set lastvalue='1696317170' where itemid=98160 and function='prev' and parameter='0';
update functions set lastvalue='601725960' where itemid=98280 and function='prev' and parameter='0';
update func
HINT: See server log for query details.
STATEMENT: DELETE FROM functions WHERE (triggerid IN (14768))
ERROR: current transaction is aborted, commands ignored until end of transaction block
после чего долго и печально в лог пишутся ошибки
STATEMENT: DELETE FROM functions WHERE (triggerid IN (14768))
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (15
063))
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: select * from triggers where triggerid=15063
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (15
063))
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (15
071))