回复: BUG #17695: Failed Assert in logical replication snapbuild. - Mailing list pgsql-bugs

From 施博文
Subject 回复: BUG #17695: Failed Assert in logical replication snapbuild.
Date
Msg-id tencent_B005D6AD58A110B274D083E65A97BBFF2809@qq.com
Whole thread Raw
In response to Re: BUG #17695: Failed Assert in logical replication snapbuild.  (vignesh C <vignesh21@gmail.com>)
List pgsql-bugs
My test branch is REL_14_STABLE in head, and the commit number is c93254424f288557eeef13343be8f72536cb9ffe

I think the problem still exists since SnapRestore function source code has not changed. This problem is hard to reproduce,  may be you can try more times.

------------------ 原始邮件 ------------------
发件人: "vignesh C" <vignesh21@gmail.com>;
发送时间: 2022年11月24日(星期四) 晚上9:09
收件人: "施博文"<zxwsbg@qq.com>;
抄送: "pgsql-bugs"<pgsql-bugs@lists.postgresql.org>;
主题: Re: BUG #17695: Failed Assert in logical replication snapbuild.

On Thu, 24 Nov 2022 at 15:58, 施博文 <zxwsbg@qq.com> wrote:
>
> I write this perl test case to reproduce problem, it needs both superuser and database name 'postgres'.
>
> Also, I write the patch to fix that problem.

Thanks for sharing the script. I was able to reproduce the problem in
PG 14.6 with your scripts. I was not able to reproduce the problem in
HEAD after making the required changes in the script for HEAD. I was
not sure if this issue is only in 14.6 or if the issue is present in
HEAD too. Since the Assert is there and code changes suggested by you
is not in HEAD, I thought this issue might be present in HEAD too.
Does it work for you on HEAD?

Regards,
Vignesh

pgsql-bugs by date:

Previous
From: vignesh C
Date:
Subject: Re: BUG #17695: Failed Assert in logical replication snapbuild.
Next
From: PG Bug reporting form
Date:
Subject: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit