回复: BUG #17695: Failed Assert in logical replication snapbuild.

From: 施博文 <zxwsbg(at)qq(dot)com>
To: vignesh C <vignesh21(at)gmail(dot)com>
Cc: pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: 回复: BUG #17695: Failed Assert in logical replication snapbuild.
Date: 2022-11-24 13:09:56
Message-ID: tencent_B005D6AD58A110B274D083E65A97BBFF2809@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

My test branch is REL_14_STABLE in head, and the commit number is&nbsp;c93254424f288557eeef13343be8f72536cb9ffe

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

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

On Thu, 24 Nov 2022 at 15:58, 施博文 <zxwsbg(at)qq(dot)com&gt; wrote:
&gt;
&gt; I write this perl test case to reproduce problem, it needs both superuser and database name 'postgres'.
&gt;
&gt; 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2022-11-24 15:58:45 BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit
Previous Message vignesh C 2022-11-24 12:39:15 Re: BUG #17695: Failed Assert in logical replication snapbuild.