Re: "too many trigger records found for relation xyz" - Mailing list pgsql-general

From Tom Lane
Subject Re: "too many trigger records found for relation xyz"
Date
Msg-id 5484.1207679448@sss.pgh.pa.us
Whole thread Raw
In response to Re: "too many trigger records found for relation xyz"  ("Mikko Partio" <mpartio@gmail.com>)
Responses Re: "too many trigger records found for relation xyz"  ("Mikko Partio" <mpartio@gmail.com>)
List pgsql-general
"Mikko Partio" <mpartio@gmail.com> writes:
> On Tue, Apr 8, 2008 at 6:38 PM, Zdenek Kotala <Zdenek.Kotala@sun.com> wrote:
>> It is really strange. It would be nice to have reproduce scenario. Can you
>> run same DDL command which invoke a catalog corruption on test database
>> cluster?

> I tried it on a fresh instance but it went through with no errors  :(

Is it possible that anything was doing a VACUUM FULL on pg_class
concurrently with your schema changes on these tables?  The behavior
looks suspiciously like some problems we've seen before wherein rows
ended up with the wrong commit-bit markings...

            regards, tom lane

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Determining weather a query fired a trigger
Next
From: Jeff Amiel
Date:
Subject: More SSL crash woes