Skip site navigation (1) Skip section navigation (2)

Re: Missing segment 3 of index

From: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
To: Jim Buttafuoco <jim(at)contactbda(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Missing segment 3 of index
Date: 2005-03-26 00:02:39
Message-ID: Pine.LNX.4.58.0503261101130.2791@linuxworld.com.au (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Jim ButtafuocoDate: 2005-03-26 00:27:10
Subject: Re: Missing segment 3 of index
Previous:From: Karel ZakDate: 2005-03-25 23:48:49
Subject: Re: Upcoming 8.0.2 Release

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group