From: ocean_li_996 <ocean_li_996@163.com>
To: Alexander Lakhin <exclusion@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re:Re: BUG #18369: logical decoding core on AssertTXNLsnOrder()
Date: Thu, 29 Feb 2024 10:25:37 +0800 (CST)
Message-ID: <3900f282.3f49.18df2ae796a.Coremail.ocean_li_996@163.com> (raw)
In-Reply-To: <c79e5171-cce8-9bd7-9578-5b3a440361f9@gmail.com>
References: <18369-ad61699bf91c5bc0@postgresql.org>
<6d0e80d6.c1fc.18deeb8120a.Coremail.ocean_li_996@163.com>
<3d696d51.cfa6.18deeccd483.Coremail.ocean_li_996@163.com>
<c79e5171-cce8-9bd7-9578-5b3a440361f9@gmail.com>
Hi Alexander,
At 2024-02-28 17:00:00, "Alexander Lakhin" <exclusion@gmail.com> wrote:
> Please see the similar issue discussed last year:
> https://www.postgresql.org/message-id/f158d9ca-2057-2836-a522-0b1278be5a53%40gmail.comWell, I have to say that the whole thread is a bit long. AFAIC, the two issues exhibited the same symptoms, but they occured in different scenarios. The patch I provided may not solve the problem you're referring to.
> With your patch applied (on REL_14_STABLE) I still get:
> TRAP: FailedAssertion("builder->next_phase_at == InvalidTransactionId", File: "snapbuild.c", Line: 1623, PID: 92772)
>
> when running make -s installcheck-force -C contrib/test_decoding...
> as specified in that message.
> (You might need to disable REGRESS tests in the Makefile to reach
> isolation tests.)
I'm not sure if I fully get your mind. I disabled the REGRESS tests in the test_decoding/Makefile and then manually run the command "make -s installcheck-force -C contrib/test_decoding" a few times. I didn't encounter the issue you mentioned. Is this problem consistently reproducible in your environment? BTW, the issue mentioned in [1] is more similar to your problem. And the patch was not applied to v14. Maybe it is another issue.
[1]: https://www.postgresql.org/message-id/7e4d4a80-3e3c-231f-f886-6cada2aa582b@gmail.com
Thanks
Haiyang Li
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: ocean_li_996@163.com, exclusion@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re:Re: BUG #18369: logical decoding core on AssertTXNLsnOrder()
In-Reply-To: <3900f282.3f49.18df2ae796a.Coremail.ocean_li_996@163.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox