BUG #6393: cluster sometime fail under heavy concurrent write load

Поиск
Список
Период
Сортировка
От maxim.boguk@gmail.com
Тема BUG #6393: cluster sometime fail under heavy concurrent write load
Дата
Msg-id E1RknUp-0000cl-ME@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #6393: cluster sometime fail under heavy concurrent write load  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6393
Logged by:          Maxim Boguk
Email address:      maxim.boguk@gmail.com
PostgreSQL version: 9.0.6
Operating system:   Linux Ubuntu
Description:=20=20=20=20=20=20=20=20

I have heavy write-load table under PostgreSQL 9.0.6 and sometime (not
always but more then 50% chance) i'm getting the next error during cluster:

db=3D# cluster public.enqueued_mail;
ERROR:  duplicate key value violates unique constraint
"pg_toast_119685646_index"
DETAIL:  Key (chunk_id, chunk_seq)=3D(119685590, 0) already exists.

chunk_id different each time.

No uncommon datatypes exists in the table.

Currently I work on create reproducible test case (but it seems require 2-3
open write transaction on the table).

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6390: maximum data limit of Postgres.
Следующее
От: john.udick@zionsbancorp.com
Дата:
Сообщение: BUG #6391: insert does not insert correct value