deadlock on simple update
| От | Jiří Pavlovský |
|---|---|
| Тема | deadlock on simple update |
| Дата | |
| Msg-id | 4BE92AEC.9070106@getnet.cz обсуждение исходный текст |
| Ответы |
Re: deadlock on simple update
|
| Список | 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 по дате отправления: