LINUX.ORG.RU

При попытке добавить коммент...

 


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 725970 waits for ShareLock on transaction 21893594; blocked by process 725964. Process 725964 waits for ShareLock on transaction 21893598; blocked by process 725970. Hint: See server log for query details. Where: SQL statement "UPDATE users SET unread_events=unread_events+1 WHERE users.id = NEW.userid" PL/pgSQL function new_event() line 3 at SQL statement SQL statement "INSERT INTO user_events (userid, type, private, message_id, comment_id) SELECT memories.userid, 'WATCH', 'f', NEW.topic, NEW.id FROM memories WHERE memories.topic = NEW.topic AND NEW.userid != memories.userid AND memories.userid != parent_author AND NOT EXISTS (SELECT ignore_list.userid FROM ignore_list WHERE ignore_list.userid=memories.userid AND ignored=NEW.userid) AND watch" PL/pgSQL function event_comment() line 7 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 725970 waits for ShareLock on transaction 21893594; blocked by process 725964. Process 725964 waits for ShareLock on transaction 21893598; blocked by process 725970. Hint: See server log for query details. Where: SQL statement "UPDATE users SET unread_events=unread_events+1 WHERE users.id = NEW.userid" PL/pgSQL function new_event() line 3 at SQL statement SQL statement "INSERT INTO user_events (userid, type, private, message_id, comment_id) SELECT memories.userid, 'WATCH', 'f', NEW.topic, NEW.id FROM memories WHERE memories.topic = NEW.topic AND NEW.userid != memories.userid AND memories.userid != parent_author AND NOT EXISTS (SELECT ignore_list.userid FROM ignore_list WHERE ignore_list.userid=memories.userid AND ignored=NEW.userid) AND watch" PL/pgSQL function event_comment() line 7 at SQL statement
★★★★★

Спасибо, надо чинить

maxcom ★★★★★ ()
Вы не можете добавлять комментарии в эту тему. Тема перемещена в архив.