Re: catalog corruption bug - Mailing list pgsql-hackers

From Tom Lane
Subject Re: catalog corruption bug
Date
Msg-id 15946.1136566771@sss.pgh.pa.us
Whole thread Raw
In response to Re: catalog corruption bug  (Jeremy Drake <pgsql@jdrake.com>)
Responses Re: catalog corruption bug
List pgsql-hackers
Jeremy Drake <pgsql@jdrake.com> writes:
> Well, I applied that patch that you sent me the link to (the bufmgr.c
> one), and rebuilt (PORTDIR_OVERLAY is cool...)

> I ran my nine processes which hammer things overnight, and in the
> morning one of them was dead.

> DBD::Pg::st execute failed: ERROR:  duplicate key violates unique
> constraint "pg_type_typname_nsp_index"

Hm, did you REINDEX things beforehand?  This could be leftover corruption...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jeremy Drake
Date:
Subject: Re: catalog corruption bug
Next
From: Jeremy Drake
Date:
Subject: Re: catalog corruption bug