Re: database corruption - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: database corruption
Date
Msg-id 20030830200439.GA12214@dcc.uchile.cl
Whole thread Raw
In response to Re: database corruption  (Joe Conway <mail@joeconway.com>)
Responses Re: database corruption
List pgsql-hackers
On Sat, Aug 30, 2003 at 12:57:26PM -0700, Joe Conway wrote:
> Joe Conway wrote:
> >I don't have any more detail yet on exactly what he was doing at this 
> >point, but I grabbed a copy of $PGDATA and looked at it on my own 
> >machine (since he doesn't have debug and assert support). Logging into 
> >any other database works fine, but the offending database produces this 
> >backtrace:
> 
> It turns out the "corruption" was user error. He ran a statement that 
> inadvertantly set reltriggers = 1 for every row in pg_class. This is 
> what led to the infinite recursion.

For the record, how were you able to detect this?

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Ellos andaban todos desnudos como su madre los parió, y también las mujeres,
aunque no vi más que una, harto moza, y todos los que yo vi eran todos
mancebos, que ninguno vi de edad de más de XXX años" (Cristóbal Colón)


pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: database corruption
Next
From: Joe Conway
Date:
Subject: Re: database corruption