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 по дате отправления: