Re: Duplicate-key-detection failure case found in btree

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Duplicate-key-detection failure case found in btree
Дата
Msg-id 200201012049.g01KnVG07172@candle.pha.pa.us
обсуждение исходный текст
Ответ на Duplicate-key-detection failure case found in btree  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Duplicate-key-detection failure case found in btree  (Jan Wieck <janwieck@yahoo.com>)
Список pgsql-hackers
> The fix is to acquire the next page's write lock before we drop the
> current page's.  This is deadlock-free since no writer ever tries
> to chain write-locks to the left (in fact the same thing is done in
> the page split logic).
> 
> I am not convinced that this explains any of the field reports of
> duplicate rows that we've seen, but it's clearly a bug.  Will commit
> the fix shortly.

Sounds good to me.  Good find.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Duplicate-key-detection failure case found in btree
Следующее
От: Brent Verner
Дата:
Сообщение: Re: [PATCHES] system catalog relation of a table and a serial sequence