BUG #4758: deadlock.c:944

Поиск
Список
Период
Сортировка
От sergey
Тема BUG #4758: deadlock.c:944
Дата
Msg-id 200904161109.n3GB9ABg079804@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4758: deadlock.c:944
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4758
Logged by:          sergey
Email address:      opium@ydk.com.ua
PostgreSQL version: 8.4beta1
Operating system:   Linux 2.6.25-gentoo-r8
Description:        deadlock.c:944
Details:

i have table with 15 records

     Table "public.test"
 Column |  Type   | Modifiers
--------+---------+-----------
 y      | integer |


then i run 3 followng commands in parralel:

./bin/psql billy < sql.sql

in file sql.sql only 10000 statements "UPDATE test SET y=1;"

and what i see in log:

ERROR:  40P01: deadlock detected
DETAIL:  Process 10237 waits for ShareLock on transaction 165664; blocked by
process 10242.
        Process 10242 waits for ShareLock on transaction 165691; blocked by
process 10237.
        Process 10237: UPDATE test SET y=1;
        Process 10242: UPDATE test SET y=1;
HINT:  See server log for query details.
LOCATION:  DeadLockReport, deadlock.c:944

approximately one message per second

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

Предыдущее
От: "Peeyush"
Дата:
Сообщение: need information
Следующее
От: Alexander Steffens
Дата:
Сообщение: Re: BUG #3826: Very Slow Execution of examplequery (wrong plan?)