•	pg_query(): Query failed: ERROR: deadlock detected
•	DETAIL: Process 79179 waits for ShareLock on transaction 314358826; blocked by process 73840.
•	Process 73840 waits for ShareLock on transaction 314356128; blocked by process 79179.
•	HINT: See server log for query details.
•	CONTEXT: while updating tuple (186540,15) in relation "items" [items.php:713 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->update() → CItem->inherit() → CItem->updateReal() → DB::update() → DBexecute() → pg_query() in include/db.inc.php:487]
•	Error in query [UPDATE items SET key_='logrt[/var/log/messages,(error(?!.*dev fd0)(?!.*ansible-command Invoked)),,,skip,,]',trends='0',itemid='1875648',hostid='18079',type='7',name='error',delay='60s',master_itemid=NULL,templateid='921754' WHERE itemid='1875648'] [ERROR: deadlock detected
•	DETAIL: Process 79179 waits for ShareLock on transaction 314358826; blocked by process 73840.
•	Process 73840 waits for ShareLock on transaction 314356128; blocked by process 79179.
•	HINT: See server log for query details.
•	CONTEXT: while updating tuple (186540,15) in relation "items"]
•	SQL statement execution has failed "UPDATE items SET key_='logrt[/var/log/messages,(error(?!.*dev fd0)(?!.*ansible-command Invoked)),,,skip,,]',trends='0',itemid='1875648',hostid='18079',type='7',name='error',delay='60s',master_itemid=NULL,templateid='921754' WHERE itemid='1875648'".




53918:20190213:125722.423 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  deadlock detected
DETAIL:  Process 73842 waits for ShareLock on transaction 314356128; blocked by process 79179.
Process 79179 waits for ShareLock on transaction 314358666; blocked by process 73842.
HINT:  See server log for query details.
CONTEXT:  while updating tuple (155702,41) in relation "items"
[update items set lastlogsize=4787511,mtime=1550051820 where itemid=3059315;
update items set lastlogsize=4787511,mtime=1550051820 where itemid=3059316;
update items set lastlogsize=4787511,mtime=1550051820 where itemid=3059319;
update items set lastlogsize=4787511,mtime=1550051820 where itemid=3059321;
update items set lastlogsize=4787511,mtime=1550051820 where itemid=3059328;
update items set lastlogsize=1005195,mtime=1550051840 where itemid=3083837;
update items set lastlogsize=1143660,mtime=1550051821 where itemid=3174332;
update items set lastlogsize=1143660,mtime=1550051821 where itemid=3174333;
update items set lastlogsize=1143660,mtime=1550051821 where itemid=3174340;
update items set lastlogsize=18770462,mtime=1550051833 where itemid=5414135;
update items set lastlogsize=4787511,mtime=1550051820 where itemid=9436439;
update items set lastlogsize=4787511,mtime=1550051820 where itemid=10573903;
update items set lastlogsize=4787511,mtime=1550051820 where itemid=10677857;
update items set lastlogsize=4787511,mtime=1550051820 where itemid=10914849;
update items set lastlogsize=4787511,mtime=1550051820 where itemid=10959567;
update items set lastlogsize=4787511,mtime=1550051820 where itemid=10959737;
update items set lastlogsize=4787511,mtime=1550051820 where itemid=10959907;
update items set lastlogsize=4787511,mtime=1550051820 where itemid=10964381;
update items set lastlogsize=949171,mtime=1550051821 where itemid=15122616;
update items set lastlogsize=942205,mtime=1550051821 where itemid=15462490;
update items set lastlogsize=942205,mtime=1550051821 where itemid=15462491;
update items set lastlogsize=942205,mtime=1550051821 where itemid=15462492;
update items set lastlogsize=942205,mtime=1550051821 where itemid=15462494;
update items set lastlogsize=942205,mtime=1550051821 where itemid=15462495;
update items set lastlogsize=942205,mtime=1550051821 where itemid=15462496;
update items set lastlogsize=942205,mtime=1550051821 where itemid=15462497;
update items set lastlogsize=942205,mtime=1550051821 where itemid=15462498;
update items set lastlogsize=942205,mtime=1550051821 where itemid=15462499;
update items set lastlogsize=946380,mtime=1550051821 where itemid=15468103;
update items set lastlogsize=496972,mtime=1550051821 where itemid=15470823;
]