LINUX.ORG.RU

add_comment.jsp плюётся


0

1
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 990764 waits for ShareLock on transaction 7886095; blocked by process 988916. Process 988916 waits for ExclusiveLock on tuple (8501,19) of relation 187714 of database 16409; blocked by process 990764. 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 990764 waits for ShareLock on transaction 7886095; blocked by process 988916. Process 988916 waits for ExclusiveLock on tuple (8501,19) of relation 187714 of database 16409; blocked by process 990764. 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
Вы не можете добавлять комментарии в эту тему. Тема перемещена в архив.