Horton
Menu

Re: BUG #17695: Failed Assert in logical replication snapbuild.

zxwsbg <zxwsbg@qq.com>

View thread
From: bowenshi <zxwsbg@qq.com>
To: Hayato Kuroda (Fujitsu) <kuroda.hayato@fujitsu.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>, Masahiko Sawada <sawada.mshk@gmail.com>
Date: 2022-11-25T09:56:37Z
Lists: pgsql-bugs

Attachments

<html>
<head>
    <meta http-equiv='Content-Type' content='text/html; charset=UTF-8'>
</head>
<body>
<style>
    font{
        line-height: 1.6;
    }
    ul,ol{
        padding-left: 20px;
        list-style-position: inside;
    }
</style>
<div style = 'font-family:Helvetica,Helvetica,微软雅黑, 宋体; line-height:1.6;'>
    <div ></div><div>
    <div><div>I add my fix code which in the patch. The code fix the origin problem, but it failed for the following new reason.</div><div><div style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;">TRAP: FailedAssertion("TransactionIdPrecedesOrEquals(safeXid, snap-&gt;xmin)", File: "snapbuild.c", Line: 593, PID: 1576)<br></div><span style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;">postgres: master: walsender postgres [local] CREATE_REPLICATION_SLOT(ExceptionalCondition+0xb9)[0xb1ca28]</span><br style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;"><span style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;">postgres: master: walsender postgres [local] CREATE_REPLICATION_SLOT(SnapBuildInitialSnapshot+0x1b3)[0x8f3c79]</span><br style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;"><span style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;">postgres: master: walsender postgres [local] CREATE_REPLICATION_SLOT[0x9136b9]</span><br style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;"><span style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;">postgres: master: walsender postgres [local] CREATE_REPLICATION_SLOT(exec_replication_command+0x398)[0x91456a]</span><br style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;"><span style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;">postgres: master: walsender postgres [local] CREATE_REPLICATION_SLOT(PostgresMain+0x7be)[0x984e4a]</span><br style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;"><span style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;">postgres: master: walsender postgres [local] CREATE_REPLICATION_SLOT[0x8c0d5b]</span><br style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;"><span style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;">postgres: master: walsender postgres [local] CREATE_REPLICATION_SLOT[0x8c06cd]</span><br style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;"><span style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;">postgres: master: walsender postgres [local] CREATE_REPLICATION_SLOT[0x8bc9de]</span><br style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;"><span style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;">postgres: master: walsender postgres [local] CREATE_REPLICATION_SLOT(PostmasterMain+0x117a)[0x8bc2b5]</span><br style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;"><span style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;">postgres: master: walsender postgres [local] CREATE_REPLICATION_SLOT[0x7bdb13]</span><br></div></div></div><div><span style="font-family: Helvetica, Helvetica, 微软雅黑, 宋体;"><br></span></div>
<!--�-->
</div>
</body>
</html>

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Fix assertion failure in snapshot building

  2. Fix perl warning from commit 9b4eafcaf4