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 188380 waits for ShareLock on transaction 5083205; blocked by process 194139. Process 194139 waits for ExclusiveLock on tuple (8745,174) of relation 187714 of database 16409; blocked by process 188380. Hint: See server log for query details. Where: SQL statement "SELECT groupid FROM topics WHERE topics.id = NEW.topic FOR UPDATE" PL/pgSQL function "comins" line 5 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 188380 waits for ShareLock on transaction 5083205; blocked by process 194139. Process 194139 waits for ExclusiveLock on tuple (8745,174) of relation 187714 of database 16409; blocked by process 188380. Hint: See server log for query details. Where: SQL statement "SELECT groupid FROM topics WHERE topics.id = NEW.topic FOR UPDATE" PL/pgSQL function "comins" line 5 at SQL statement
при попытке отправить сообщение.
