Re: [HACKERS] VACUUM's "No one parent tuple was found", redux

2002-08-13 Thread Barry Lind
Tom Lane wrote: > >Also, for Mario and Barry: does this test case look anything like what >your real applications do? In particular, do you ever do a SELECT FOR >UPDATE in a transaction that commits some changes, but does not update >or delete the locked-for-update row? If not, it's possible

Re: [HACKERS] VACUUM's "No one parent tuple was found", redux

2002-08-12 Thread Mario Weilguni
> Also, for Mario and Barry: does this test case look anything like what > your real applications do? In particular, do you ever do a SELECT FOR > UPDATE in a transaction that commits some changes, but does not update > or delete the locked-for-update row? If not, it's possible there are > yet

[HACKERS] VACUUM's "No one parent tuple was found", redux

2002-08-12 Thread Tom Lane
I've been studying the "No one parent tuple was found" problem some more, and I've realized there are actually two distinct problems that manifest at the same place. Here are test procedures for duplicating the problems on-demand (these work in either 7.2 or CVS tip): CASE 1 (transient failure):