Re: VACUUM Error?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fabrice(dot)Sznajderman(at)devoteam(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: VACUUM Error?
Date: 2006-03-07 14:52:46
Message-ID: 18276.1141743166@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Fabrice(dot)Sznajderman(at)devoteam(dot)com writes:
> But I had error :"ERROR: Parent tuple was not found

What PG version is this? We recently fixed some bugs that could lead to
this error.

The error could only occur if you have some old open transaction(s) that
could possibly still see since-updated tuples in the vacuumed table.
So it'll go away if you close out open transactions.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-03-07 15:07:39 Re: Can I delete all WAL logfiles if the database is shutdown without errors?
Previous Message Tom Lane 2006-03-07 14:49:55 Re: New database: SQL_ASCII vs UTF-8 trade-offs