Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lfDTE-0007Tm-ER for pgsql-hackers@arkaria.postgresql.org; Sat, 08 May 2021 03:17:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lfDTD-0001UZ-D3 for pgsql-hackers@arkaria.postgresql.org; Sat, 08 May 2021 03:17:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lfDTC-0001UQ-W3 for pgsql-hackers@lists.postgresql.org; Sat, 08 May 2021 03:17:35 +0000 Received: from mail-oln040092255065.outbound.protection.outlook.com ([40.92.255.65] helo=APC01-HK2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lfDT5-0004ap-DR for pgsql-hackers@lists.postgresql.org; Sat, 08 May 2021 03:17:33 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Rs/OG0K+Ty1WIPxfjri+MkEI2E6UA1eXlyJOhfVaogGx6hEpAkBpD0udGtzt5srckKO933pbh7FoFXXmyzQeuNXs9h+7KBYCo/ktd6+/moRpd4+p9hvLpEsa0IzDpv9mmLSoeSBjZZOdMyuWbstgoOoVE/DhIKcjdKjkZTQTZcTwNHkdmJ/YRBEKhy/RjIn2xztvN5UBG0hi26RMCh5GkhLkNlLqkzK9iLr7XwzpvJT1Glb91PAQGmwbhQXggINtIqa4gQNZ2h8W0qY6CYhfPrhOx2NAIUPHZW52+LUNFfj73erMVzEmHE4x05/17Rep4VbBMeWg2x+S8DalbHLrmQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=durUyPrYWv/1nEyvI+p4+BIBc668fktcqYnOY7O/O6c=; b=J4c66uVdJNhEWVLTpPstyd45/T8JQ6G1WRhsuZBR3tX2jo2ltMHXk2OON9cMyZ5Pu9Gta/Fdx2YPBSKdCxdSM12llt5v0+gHMzWtRzssIpxBYdj8rHnDufZOV17U8fBKhbdOzIhWSft0eQRgInS8yj/Mj10OP83NBurbVQ0Wgg+dIxsy4YLcdUyvOFyoECt9Q54A1WSpMsH7HTFbYFOCLS5vnd5qOfzJhEIDtpbAkM3wL4urkqrJrBIHMyBbShUCoeBUgaw2Iv7NcRUJAnEsI2DetEwjDew9Khj7Da+eXheDMAWDJaw2dgDEadDe715LvVD2VterVAq/N7OaOAA5Kw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=durUyPrYWv/1nEyvI+p4+BIBc668fktcqYnOY7O/O6c=; b=O+727h4HGDqVnIg4ZbCExH0kNH+LtimcAZyF1THdFknWcxidVeeAsb90XkN/o6udoRWkGvmx5tur1rUHgpACTQSnmBp90t9Dm0oT8f4oGG9zKrgJRaMa0bL/4q6yNW/+Z6dkiWbtk3/0GC9hD2a53r1shMXHoYdB/pQvUVC2OreG+HSBqJXN2Wcs/ER62+UmM+oBzebialU1NKejjotRh9NUw9bFhmm7sA1wKWE3yFlSeNQo9vOY83mlkvjBLrMAwX4FjS2OZhL9OD2kKZHBlh5oNK7KJDEo0zLKkxGUEqS3He/PXNzUb+UwZvic/JyWIsGe9BK9ZUbUYNas6DK3VA== Received: from PSXP216CA0038.KORP216.PROD.OUTLOOK.COM (2603:1096:300:5::24) by SI2PR01MB4044.apcprd01.prod.exchangelabs.com (2603:1096:4:ed::6) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4108.25; Sat, 8 May 2021 03:17:22 +0000 Received: from HK2APC01FT029.eop-APC01.prod.protection.outlook.com (2603:1096:300:5:cafe::7c) by PSXP216CA0038.outlook.office365.com (2603:1096:300:5::24) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4087.38 via Frontend Transport; Sat, 8 May 2021 03:17:22 +0000 Received: from MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM (10.152.248.56) by HK2APC01FT029.mail.protection.outlook.com (10.152.248.195) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4108.25 via Frontend Transport; Sat, 8 May 2021 03:17:22 +0000 X-IncomingTopHeaderMarker: OriginalChecksum:197EA8F7C9C3CB01236CB6B5F0FA673F0B0C67316C11B4E0442D48692935A67A;UpperCasedChecksum:BBAEE6F13C387D4EF49A4BEA6D96DFCBE43BAC024D58E6F81D8E3678862F06A2;SizeAsReceived:7583;Count:46 Received: from MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM ([fe80::10fe:a4b6:de07:c5f4]) by MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM ([fe80::10fe:a4b6:de07:c5f4%9]) with mapi id 15.20.4108.030; Sat, 8 May 2021 03:17:20 +0000 References: <81D0D8B0-E7C4-4999-B616-1E5004DBDCD2@amazon.com> <162038822425.16755.16394090984207683374.pgcf@coridan.postgresql.org> User-agent: mu4e 1.4.14; emacs 27.1 From: Japin Li To: ahsan hadi Cc: Bertrand Drouvot , "Minsoo (Mike) Oh" , pgsql-hackers@lists.postgresql.org Subject: Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns In-reply-to: <162038822425.16755.16394090984207683374.pgcf@coridan.postgresql.org> Date: Sat, 08 May 2021 11:17:13 +0800 Message-ID: Content-Type: text/plain X-TMN: [MfpobmIXsLu9go35T2Qezf8KkrhIGnvx] X-ClientProxiedBy: HK2PR04CA0060.apcprd04.prod.outlook.com (2603:1096:202:14::28) To MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:c3::12) X-Microsoft-Original-Message-ID: MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 Received: from MacBook-Pro.local (101.207.125.86) by HK2PR04CA0060.apcprd04.prod.outlook.com (2603:1096:202:14::28) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4108.28 via Frontend Transport; Sat, 8 May 2021 03:17:19 +0000 X-MS-PublicTrafficType: Email X-IncomingHeaderCount: 46 X-EOPAttributedMessage: 0 X-MS-Office365-Filtering-Correlation-Id: d97a8ba0-6ed7-4e62-dad7-08d911cfca8f X-MS-TrafficTypeDiagnostic: SI2PR01MB4044: X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: +3qyv5wqY5WzOs9K/NKwXLDmZrK7r0mES0j0AKFfEjYjELgLgrWBOr7Uyw+6NegJCm0N3mCnx8NDhe2WI90kvKYamZGdiHmpUIaBVx3RvEiAS4e/S+BdMK+r3j4N0BYkkYqaBy9mXxa5qCerwmqbTPCUb5dPjxuX7mX/4juq6lwruFRdNR+NkVihZwzfo+ukEyW2yjpbxK/nQXSnyoJxC4NOUPehrQG5gJe+7VQRWboO6RrdRZ1Ad1qqCKes6a0r5/O3OveTg5SU54vDW/QkRbBuwyFa+5f07GAuOzqmk8wJRW08P0qb5lOoJ+jOsrnB7yneEz6jBwsGKAX5cIxfJcaYOuBtJMu4dxwNMXYqeZqLSDk9FjPF0jmTi3uuG0xWamIHKgrFcl+uTtl6Ey/jKA== X-MS-Exchange-AntiSpam-MessageData: 10VnYwmGAwu8HrIKBEPnuvRypIzTm3aj4HjaML3+d3prxSU1dx4ND3MX8bUrcqPtByvk1BFZIAfp+VZx1Eu7u132YuSjl6hljEEr74FDhAfPqCWGYqSRUiuWvopM8R9Ys38a1QirceF0r2BOrCoVvg== X-OriginatorOrg: sct-15-20-3174-20-msonline-outlook-5c337.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: d97a8ba0-6ed7-4e62-dad7-08d911cfca8f X-MS-Exchange-CrossTenant-OriginalArrivalTime: 08 May 2021 03:17:20.6452 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-AuthSource: HK2APC01FT029.eop-APC01.prod.protection.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Anonymous X-MS-Exchange-CrossTenant-FromEntityHeader: Internet X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: SI2PR01MB4044 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 07 May 2021 at 19:50, ahsan hadi wrote: > The following review has been posted through the commitfest application: > make installcheck-world: tested, passed > Implements feature: tested, passed > Spec compliant: tested, passed > Documentation: not tested > > I have also seen this error with logical replication using pglogical extension, will this patch also address similar problem with pglogical? Does there is a test case to reproduce this problem (using pglogical)? I encountered this, however I'm not find a case to reproduce it. -- Regrads, Japin Li. ChengDu WenWu Information Technology Co.,Ltd.