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

Re: vacumm error

From: V13 <v13(at)it(dot)teithe(dot)gr>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: vacumm error
Date: 2002-11-26 21:05:16
Message-ID: 200211262305.17217.v13@it.teithe.gr (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tuesday 26 November 2002 16:43, Rod Taylor wrote:
> On Fri, 2002-11-22 at 15:51, Stefanos Harhalakis wrote:
> > I'm running postgresql 7.2.1 on linux.
> >
> > I cannot run vacuumm on a table in a database i'm running for about 7
> > months. I get:
> >
> > ERROR:  No one parent tuple was found
>
> Your best bet, since you've crashed with fsync off, is to dump and
> reload the database.  This should clean up any data issues you currently
> have -- assuming pg_dump functions on it.
>
> That said, 7.2.3 has several vacuum fixes, but I don't think they'll fix
> your problem.

I did a SELECT * FROM table FOR UPDATE; and it solved the problem...

thnx for your answer.

<<V13>>

In response to

pgsql-bugs by date

Next:From: Jean-Luc LachanceDate: 2002-11-26 21:15:28
Subject: order by in for loop in plpgsql does not work
Previous:From: bpalmerDate: 2002-11-26 20:59:21
Subject: regression hickups w/ freebsd.

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