Re: [HACKERS] Index corruption - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Index corruption
Date
Msg-id 199912291407.JAA02208@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Index corruption  (Adriaan Joubert <a.joubert@albourne.com>)
List pgsql-hackers
> Further to my problem: I've run the vacuum in a backend under the debugger and
> at least figured out in which
> loop the zillions of files are created. It is in md.c. In the stack trace
> below, you can see that blockno has got a totally stupid value and in the loop
> in lines 1049-1063 in md.c (v 6.5.3. sources) it opens zillions of files. If
> anybody knows where this comes from I'd appreciate it. In the meantime I'll
> try to dig a bit further.

Were you the person I told to use pg_upgrade and re-initdb your
database? If not, I would recommend that as the fix.  You may need to
re-enable pg_upgrade by editing the script.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: subquery performance and EXISTS
Next
From: Adriaan Joubert
Date:
Subject: Re: [HACKERS] Index corruption