Re: BUG #11141: Duplicate primary key values corruption

behrmann@ndgf.org wrote:

> We have observed two rows with the same primary key in one of our production
> databases. We don't know how to reproduce this problem, but given that this
> looks like a corruption bug, I figure you will want to know about this.


Can you please install extension pageinspect, then grab the TIDs of both
copies (select ctid from srmlinkgroup where id = ..), then post the
output of:

select *
from heap_page_items(get_raw_page('srmlinkgroup', BLKNO))
where lp = (OFFNO)

where the BLKNO value is the first half of the TID, and OFFNO is the
second half of the TID, for each of those tuples?

Please attach the results in text files rather than pasting in the
email, as whitespace is mangled by your mail program.

Thanks

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services