LINUX.ORG.RU

История изменений

Исправление xtraeft, (текущая версия) :

гыгы, писал тебе ответ «да, это тоже есть. и по совокупности всех этих причин он глючит».

а лор мне выдал

PreparedStatementCallback; SQL [INSERT INTO user_events (userid, type, private, message_id, comment_id, message) VALUES(?, ?, ?, ?, ?, ?)]; ERROR: deadlock detected Detail: Process 2531238 waits for ShareLock on transaction 9883923; blocked by process 2533167. Process 2533167 waits for ShareLock on transaction 9883924; blocked by process 2531238. 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; nested exception is org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 2531238 waits for ShareLock on transaction 9883923; blocked by process 2533167. Process 2533167 waits for ShareLock on transaction 9883924; blocked by process 2531238. 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

maxcom, hizel

Исправление xtraeft, :

гыгы, писал тебе ответ «да, это тоже есть. и по совокупности всех этих причин он глючит».

а лор мне выдал

PreparedStatementCallback; SQL [INSERT INTO user_events (userid, type, private, message_id, comment_id, message) VALUES(?, ?, ?, ?, ?, ?)]; ERROR: deadlock detected Detail: Process 2531238 waits for ShareLock on transaction 9883923; blocked by process 2533167. Process 2533167 waits for ShareLock on transaction 9883924; blocked by process 2531238. 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; nested exception is org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 2531238 waits for ShareLock on transaction 9883923; blocked by process 2533167. Process 2533167 waits for ShareLock on transaction 9883924; blocked by process 2531238. 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

Исходная версия xtraeft, :

гыгы, писал тебе ответ «да, это тоже есть. и по совокупности всех этих причин он глючит».

а лор мне выдал
[code]PreparedStatementCallback; SQL [INSERT INTO user_events (userid, type, private, message_id, comment_id, message) VALUES(?, ?, ?, ?, ?, ?)]; ERROR: deadlock detected Detail: Process 2531238 waits for ShareLock on transaction 9883923; blocked by process 2533167. Process 2533167 waits for ShareLock on transaction 9883924; blocked by process 2531238. 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; nested exception is org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 2531238 waits for ShareLock on transaction 9883923; blocked by process 2533167. Process 2533167 waits for ShareLock on transaction 9883924; blocked by process 2531238. 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[/code]