Re: VACUUM Error?

Hello Tom Lane,

Thank you very much for your answer!!

My PG version is older than 7.3 , I know it so old and so much old.. but I
can't update this version... :-((

However, could you explain me how I can close open transaction?

Thanks in advance!!

best regard

Fabrice

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
07/03/2006 15:52

A
Fabrice(dot)Sznajderman(at)devoteam(dot)com
cc
pgsql-admin(at)postgresql(dot)org
Objet
Re: [ADMIN] VACUUM Error?

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

+---------------------------------------------------------------------+
About Devoteam:

Devoteam is an IT consulting group.
Combining consulting and technology solutions offers enables
Devoteam to provide its customers with independent advice and
effective solutions to align their information system's technical
infrastructure with their operational objectives.
The group achieved a turnover of 199 million euros in 2005
an operating margin of 7% and counts 2,100 employees through
12 European countries and the Middle East.
Listed on the Euronext Paris Nouveau Marche and part of the Nexteconomy,
IT CAC, IT CAC 50, SBF 250 index of Euronext Paris.
www.devoteam.com
+---------------------------------------------------------------------+