Re: Rare corruption of pg_class index - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Rare corruption of pg_class index
Date
Msg-id 20061220191921.GV30769@alvh.no-ip.org
Whole thread Raw
In response to Re: Rare corruption of pg_class index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > Greg Sabino Mullane wrote:

> > It would help if you could get a stack trace at the moment of the
> > problem, but I'm not sure how to do that.
> 
> Perhaps insert an abort() call right before the elog(ERROR)
> that's reporting this.

Yeah, but doing this in a production environment is not likely to go
very far ...

> (I think there are three possibilities,
> but they're all in heapam.c so you might as well just hack them all.)

Maybe it would be good to run under log_error_verbosity='verbose' for a
while to discover whether it's always the same one.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Release 8.2.0 done, 8.3 development starts
Next
From: "Jim Nasby"
Date:
Subject: Re: Interface for pg_autovacuum