Re: Missing segment 3 of index

After I do a vacuum full, I will run memtest and some disk diags.

Thanks
Jim



---------- Original Message -----------
From: Gavin Sherry <swm@linuxworld.com.au>
To: Jim Buttafuoco <jim@contactbda.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Sent: Sat, 26 Mar 2005 11:02:39 +1100 (EST)
Subject: Re: [HACKERS] Missing segment 3 of index

> On Fri, 25 Mar 2005, Jim Buttafuoco wrote:
> 
> > All,
> >
> > I had to abort a vacuum full after 36 hours on a large table (16 million rows).  I started the vacuum again and 
after
> > 10 minutes in got to the place I aborted it (control-c) yesterday.  I recieved the following error
> >
> > ERROR:  could not open segment 3 of relation "emi_110101_idx1" (target block 2079965576): No such file or
directory
> >
> > Will a REINDEX fix this or do I need to drop the index instead?
> 
> A reindex or drop/recreate will do the trick. However, I'd be concerned
> about your hardware. I've seen this kind of problem on systems with bad
> memory, CPU and disk controllers in the past.
> 
> Gavin
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
------- End of Original Message -------