Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae - Mailing list pgsql-bugs

From Bowen Shi
Subject Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae
Date
Msg-id CAM_vCufYfYxHdFD=1zNjcAzg-cehcUqpWkyQP-s8paPUvVEzqA@mail.gmail.com
Whole thread Raw
In response to Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae  (Melanie Plageman <melanieplageman@gmail.com>)
Responses Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae
List pgsql-bugs

On Wed, May 15, 2024 at 7:33 AM Melanie Plageman <melanieplageman@gmail.com> wrote:

Are you reproducing the hang locally with my repro? Or do you have
your own repro? How are you testing pg_terminate_backend() and seeing
that the InterruptHoldoffCount is 1?

I noticed this problem occurring several times on PG16, but I didn't use your repro, and haven't found a way to reproduce the problem. Instead, I simply force the vacuum to enter a retry loop with the following code and found InterruptHoldoffCount is 1.

// if (unlikely(res == HEAPTUPLE_DEAD))
    goto retry;

Sorry, I should have mentioned that patch was against REL_14_STABLE.
Attached patch has the same functionality but should apply cleanly
against REL_15_STABLE.
 
Thanks, I would try that.


--
Regards
Bowen Shi

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18466: Wrong row estimate for nested loop
Next
From: Peter Eisentraut
Date:
Subject: Re: BUG #18362: unaccent rules and Old Greek text