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