From: | Mario Weilguni <mweilguni(at)sime(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Interesting VACUUM notice |
Date: | 2002-11-01 08:38:31 |
Message-ID: | 200211010938.31134.mweilguni@sime.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I found a message I've never seen before in VACUUM, its:
NOTICE: Too old parent tuple found - can't continue repair_frag
The version is Postgresql 7.2.1.
The problem occurs in vacuum.c, around line 1700, but the interesting part is the comment around:
/*
* Read above about cases when
* !ItemIdIsUsed(Citemid) (child item is
* removed)... Due to the fact that at the moment
* we don't remove unuseful part of update-chain,
* it's possible to get too old parent row here.
* Like as in the case which caused this problem,
* we stop shrinking here. I could try to find
* real parent row but want not to do it because
* of real solution will be implemented anyway,
* latter, and we are too close to 6.5 release. -
* vadim 06/11/99
*/
This sounds like a solution should be available, but it seems to happen anyway. Yesterday I've found no way to fix this problem,
but today it's not reproduceable any more. Might this notice indicate a serious problem?
Best regards,
Mario Weilguni
From | Date | Subject | |
---|---|---|---|
Next Message | am | 2002-11-01 10:43:48 | Cursors: getting the number of tuples; moving backwards |
Previous Message | Alessio Bragadini | 2002-11-01 08:25:41 | Re: Request for supported platforms |