Re: vacumm error

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Stefanos Harhalakis <v13(at)it(dot)teithe(dot)gr>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: vacumm error
Date: 2002-11-26 14:43:23
Message-ID: 1038321803.2508.4.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

--
Rod Taylor <rbt(at)rbt(dot)ca>

In response to

  • vacumm error at 2002-11-22 20:51:16 from Stefanos Harhalakis

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Rod Taylor 2002-11-26 14:56:19 Re: RULE: ON DELETE doesn't stack deletes
Previous Message Rison, Stuart 2002-11-26 13:54:03 [SQL/BUGS] (possible) inconsistent behaviour of timestamp?