| 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: | Whole Thread | Raw Message | 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 |