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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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