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

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 -------