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