← All posts tagged нюню

a13

PreparedStatementCallback; SQL [INSERT INTO comments (id, userid, title, postdate, replyto, deleted, topic, postip, ua_id) VALUES (?, ?, ?, CURRENT_TIMESTAMP, ?, 'f', ?, ?::inet, create_user_agent(?))]; ERROR: deadlock detected Detail: Process 598457 waits for ShareLock on transaction 5872560; blocked by process 593803. Process 593803 waits for ShareLock on transaction 5872561; blocked by process 598457. Hint: See server log for query details. Where: SQL statement "UPDATE groups SET stat1=stat1+1,stat3=stat3+1 WHERE id = cgroup" PL/pgSQL function "comins" line 7 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 598457 waits for ShareLock on transaction 5872560; blocked by process 593803. Process 593803 waits for ShareLock on transaction 5872561; blocked by process 598457. Hint: See server log for query details. Where: SQL statement "UPDATE groups SET stat1=stat1+1,stat3=stat3+1 WHERE id = cgroup" PL/pgSQL function "comins" line 7 at SQL statement