deadlock on simple update

Поиск
Список
Период
Сортировка
От Jiří Pavlovský
Тема deadlock on simple update
Дата
Msg-id 4BE92AEC.9070106@getnet.cz
обсуждение исходный текст
Ответы Re: deadlock on simple update  (<tv@fuzzy.cz>)
Список pgsql-general
Hello,
I have 8.4.2. I'm getting deadlock when multiple processes try to update
a table. Strange is it is a simple table with no triggers firing etc.
Just an id and a numerical field to update. So I'm at odds as to what
could cause the deadlock?

  DETAIL:  Process 8253 waits for ShareLock on transaction 7001023;
blocked by process 8230.
        Process 8230 waits for ExclusiveLock on tuple (17,269) of
relation 17544 of database 16417; blocked by process 8226.
        Process 8226 waits for ShareLock on transaction 7000961; blocked
by process 8253.
        Process 8253:
        UPDATE statistics SET count = count + 1 WHERE ArticleID=$1 AND
Language=$2

        Process 8230:
        UPDATE statistics SET count = count + 1 WHERE ArticleID=$1 AND
Language=$2

       Process 8226:
       UPDATE statistics SET count = count + 1 WHERE ArticleID=$1 AND
Language=$2

  HINT:  See server log for query details.
  STATEMENT:
       UPDATE statistics SET count = count + 1 WHERE ArticleID=$1 AND
Language=$2

  ERROR:  current transaction is aborted, commands ignored until end of
transaction block

В списке pgsql-general по дате отправления:

Предыдущее
От: Alexander Pyhalov
Дата:
Сообщение: Re: log database in which error occurs
Следующее
От: Mickaël DA ROCHA
Дата:
Сообщение: Full Text Search : Parse date