SEO

#1 (**permalink**) 04-11-2008, 03:13 AM

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?

Thanks
Jim

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

#2 (**permalink**) 04-11-2008, 03:13 AM

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

#3 (**permalink**) 04-11-2008, 03:13 AM

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode