Re: VACUUM Error?

Поиск
Список
Период
Сортировка
От Fabrice.Sznajderman@devoteam.com
Тема Re: VACUUM Error?
Дата
Msg-id OFA7B665FB.9540D57F-ONC125712A.00541EB0-C125712A.0054A717@devoteam.com
обсуждение исходный текст
Ответ на Re: VACUUM Error?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: VACUUM Error?  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
Список pgsql-admin

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@sss.pgh.pa.us>

07/03/2006 15:52

A
Fabrice.Sznajderman@devoteam.com
cc
pgsql-admin@postgresql.org
Objet
Re: [ADMIN] VACUUM Error?





Fabrice.Sznajderman@devoteam.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Joost Kraaijeveld
Дата:
Сообщение: Re: Can I delete all WAL logfiles if the database is
Следующее
От: "Andy Shellam"
Дата:
Сообщение: Re: VACUUM Error?