Обсуждение: VACUUM Error?

Поиск
Список
Период
Сортировка

VACUUM Error?

От
Fabrice.Sznajderman@devoteam.com
Дата:


Hello,


I executed a Vacuum on my Postgres database.
You can see the command line : /vacuumdb -f -z -v -d ccm > /tmp/vacuum.txt 2> /tmp/vacuumError.txt  I used  performed the vacuum.

But I had error :"ERROR:  Parent tuple was not found
vacuumdb: vacuum  ccm failed"
 each time I am executed the vacuum

have you any idea about this error? And may be any solution ?

Thanks in advance,

best regard,

Fabrice

Re: VACUUM Error?

От
Tom Lane
Дата:
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

Re: VACUUM Error?

От
Fabrice.Sznajderman@devoteam.com
Дата:

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

Re: VACUUM Error?

От
"Andy Shellam"
Дата:
If you do "ps auxwww|grep postgres" on your console command line - you should find processes with a status of "IDLE IN TRANSACTION" or similar, and use that data and the PG server status to identify where it came from, and submit a COMMIT or ROLLBACK command on that connection.


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Fabrice.Sznajderman@devoteam.com
Sent: Tuesday, 07 March, 2006 3:25 pm
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] 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@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

!DSPAM:14,440da5fc49411673628609!

Re: VACUUM Error?

От
Fabrice.Sznajderman@devoteam.com
Дата:

Hello Andy,

Thanks a lot for your answer,

I'll retry with this new information!

I will give you feedback when I would had made this new way !

Best regard

Fabrice


"Andy Shellam" <andy.shellam@mailnetwork.co.uk>
Envoyé par : pgsql-admin-owner@postgresql.org

07/03/2006 16:34

Veuillez répondre à
<andy.shellam@mailnetwork.co.uk>

A
<Fabrice.Sznajderman@devoteam.com>
cc
Objet
Re: [ADMIN] VACUUM Error?





If you do "ps auxwww|grep postgres" on your console command line - you should find processes with a status of "IDLE IN TRANSACTION" or similar, and use that data and the PG server status to identify where it came from, and submit a COMMIT or ROLLBACK command on that connection.


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Fabrice.Sznajderman@devoteam.com
Sent:
Tuesday, 07 March, 2006 3:25 pm
To:
pgsql-admin@postgresql.org
Subject:
Re: [ADMIN] 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@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


!DSPAM:14,440da5fc49411673628609!

Re: VACUUM Error?

От
Fabrice.Sznajderman@devoteam.com
Дата:

Hello Andy,

I tried last night, the way which you suggested me.. I looked at the log file of the vacuum process... and there is no error..
I tried to run the vacuum without the -f option , last night.

So to the next night, I will add the -f option and will run again the vacuum process.

Thanks again for your help!

I will give you a feedback!

Best regard

Fabrice





"Andy Shellam" <andy.shellam@mailnetwork.co.uk>
Envoyé par : pgsql-admin-owner@postgresql.org

07/03/2006 16:34

Veuillez répondre à
<andy.shellam@mailnetwork.co.uk>

A
<Fabrice.Sznajderman@devoteam.com>
cc
Objet
Re: [ADMIN] VACUUM Error?





If you do "ps auxwww|grep postgres" on your console command line - you should find processes with a status of "IDLE IN TRANSACTION" or similar, and use that data and the PG server status to identify where it came from, and submit a COMMIT or ROLLBACK command on that connection.


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Fabrice.Sznajderman@devoteam.com
Sent:
Tuesday, 07 March, 2006 3:25 pm
To:
pgsql-admin@postgresql.org
Subject:
Re: [ADMIN] 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@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


!DSPAM:14,440da5fc49411673628609!

Re: VACUUM Error?

От
Fabrice.Sznajderman@devoteam.com
Дата:

Victory!!

The Vacuum works well !!!

Thanks for your help!!!

cheers

Fabrice SZNAJDERMAN

DSI : Application Rendez-Vous - CCM
tel : 01 41 49 60 77
Fabrice Sznajderman/Solutions/FR/Devoteam@Devoteam



"Andy Shellam" <andy.shellam@mailnetwork.co.uk>
Envoyé par : pgsql-admin-owner@postgresql.org

07/03/2006 16:34

Veuillez répondre à
<andy.shellam@mailnetwork.co.uk>

A
<Fabrice.Sznajderman@devoteam.com>
cc
Objet
Re: [ADMIN] VACUUM Error?





If you do "ps auxwww|grep postgres" on your console command line - you should find processes with a status of "IDLE IN TRANSACTION" or similar, and use that data and the PG server status to identify where it came from, and submit a COMMIT or ROLLBACK command on that connection.


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Fabrice.Sznajderman@devoteam.com
Sent:
Tuesday, 07 March, 2006 3:25 pm
To:
pgsql-admin@postgresql.org
Subject:
Re: [ADMIN] 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@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


!DSPAM:14,440da5fc49411673628609!