| From: | Melanie Plageman <melanieplageman(at)gmail(dot)com> |
|---|---|
| To: | Bowen Shi <zxwsbg12138(at)gmail(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, Alexander Lakhin <exclusion(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de> |
| Subject: | Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae |
| Date: | 2024-05-15 13:26:57 |
| Message-ID: | CAAKRu_YzDyVD4aRgKjpeQRx8b6FRjCNJh=N-0+0NZ5Qv55QFdQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, May 14, 2024 at 10:43 PM Bowen Shi <zxwsbg12138(at)gmail(dot)com> wrote:
>
>
>> On Wed, May 15, 2024 at 7:33 AM Melanie Plageman <melanieplageman(at)gmail(dot)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.
You saw this problem on PG16? Did you see vacuum hanging or you saw
some kind of incorrect relfrozenxid advancement? My repro does not
work for PG16, and I do not see how we could face this problem on
PG16. It would be very helpful if you have any more details.
- Melanie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rémi Cura | 2024-05-15 13:30:59 | Re: BUG #18464: Replacing a SQL function silently drops the generated columns that use this function |
| Previous Message | David Rowley | 2024-05-15 11:39:35 | Re: BUG #18466: Wrong row estimate for nested loop |