On Thu, Feb 7, 2013 at 9:32 AM, Jeff Janes <jeff.ja...@gmail.com> wrote: > On Thu, Feb 7, 2013 at 12:55 AM, Pavan Deolasee > <pavan.deola...@gmail.com> wrote: >> >> Index scans do not return any duplicates and you need to force a seq >> scan to see them. Assuming that the page level VM bit might be >> corrupted, I tried to REINDEX the table to see if it complains of >> unique key violations, but that crashes the server with >> >> TRAP: FailedAssertion("!(((bool) ((root_offsets[offnum - 1] != >> ((OffsetNumber) 0)) && (root_offsets[offnum - 1] <= ((OffsetNumber) >> (8192 / sizeof(ItemIdData)))))))", File: "index.c", Line: 2482) > > I don't see the assertion failure myself. If I do REINDEX INDEX it > gives a duplicate key violation, and if I do REINDEX TABLE or REINDEX > DATABASE I get claimed success.
Ah, ignore that claim. Of course one does not get assertion failures if one neglected to turn them on! Cheers, Jeff -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers