Re: Duplicate-key-detection failure case found in btree - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Duplicate-key-detection failure case found in btree
Date
Msg-id 200201012049.g01KnVG07172@candle.pha.pa.us
Whole thread Raw
In response to Duplicate-key-detection failure case found in btree  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Duplicate-key-detection failure case found in btree
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Duplicate-key-detection failure case found in btree
Next
From: Brent Verner
Date:
Subject: Re: [PATCHES] system catalog relation of a table and a serial sequence