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 1lmVZA-0005Jn-JW for pgsql-hackers@arkaria.postgresql.org; Fri, 28 May 2021 06:01:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lmVZ9-0008Kw-Cv for pgsql-hackers@arkaria.postgresql.org; Fri, 28 May 2021 06:01:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lmVZ9-0008Ko-46 for pgsql-hackers@lists.postgresql.org; Fri, 28 May 2021 06:01:51 +0000 Received: from esa13.fujitsucc.c3s2.iphmx.com ([68.232.156.96]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lmVZ5-0003UC-1W for pgsql-hackers@postgresql.org; Fri, 28 May 2021 06:01:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1622181708; x=1653717708; h=from:to:subject:date:message-id:references:in-reply-to: content-transfer-encoding:mime-version; bh=zw5Lb92gML1BVObKeLwAupteiRVrmbk0l9eEIQngE3U=; b=DV++IWHQ6HWzgX/4pG8eGHrOVJbt+onnwphuzjEFLYtbKo3TLkD+/qJH MtE0dj8o4T7GmdaY1KaAG2XL8A+qNWA8gEJcy+/W+XN9lG55qSD9jscRZ RHnS17I8M6Y/S3KgS7p6qD8a6mW0gajguk8fI4LOtBK8b26I/5CGq46l0 bdSxwbSrIrhn2LrscAsjZRc0jxgdqrOOvrh05fVpoPrqEK6/v61dKKxFG +59qQeO1AnWxzJ2LMcFREfKnEd9VzylP4dWAn8Vz2MsGxIC8mvs5V5jRG YbT2SvOdJoCrrBBKUwZ/dPVWwJgv4SuAONaqeDgSFb5Cao3V4mXMNfjFN Q==; IronPort-SDR: uv5qNCiT3L+amSM15FoNRTPUuh/t/t6EzTkeQs9BPfb2uX7ByEgYKQpiGnZlsq1LkCGHEEOVvp cVPN7Nak3SW/44dLFYsz4E0FPsaFL3UYs6X2qwzh/2h3GhAQfYEQq/ml2tVjGlFl6mKYmI7bFU VUL3MirVPJvuqhGPbZ8coihbGItsgoy7Swee4HMZkQE+66RbXLmgHbnWox9ukiyXBIN4fgcw9V z+a2pYs7B2Xo0nyX1bm29K5ccgxCkSGA62CrJxjVWTSj0n73qX+tLhayU/k3nSjOAomn1mPpaM UqU= X-IronPort-AV: E=McAfee;i="6200,9189,9997"; a="31874167" X-IronPort-AV: E=Sophos;i="5.83,229,1616425200"; d="scan'208";a="31874167" Received: from mail-os2jpn01lp2057.outbound.protection.outlook.com (HELO JPN01-OS2-obe.outbound.protection.outlook.com) ([104.47.92.57]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 28 May 2021 15:01:45 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=V5hG2qbqNtofiOA9EDUEwxu/+AJjFYPPcosIHsPvP3e2mkDDjvsFBVCuC07pXAlVr81QYCRfBnbbpXb6zooeoMn7ndENgeJZ/POoBAtTd9h3meS3DjGi6v280Z9CWh+4AlqwGroP4+7DycsEeiP2fioalDve5S2MAWthDVju2WB2cjzn09BhFHQ5qQjc8ksGxPvlnlQczvYl7yq1EiorrasfSeOiQVDX6XEd5fWEiXgGBFqBVOfd1xz7Zp6EzuyitBvmxzTfyow5EvqtF8wp7JElQRjtX/IIgViNSarK1DC/M86hMcgcJfTbRFUOjZAO3LjgTiXFd4vZwOIsI/cB5Q== 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=zw5Lb92gML1BVObKeLwAupteiRVrmbk0l9eEIQngE3U=; b=bP7/efyjiZJLti78wuKNgFGCW928jEVMsIKoQtwEjJh8Tz59ONTaOZXYgZ/Wtz3zGmqVtbU/7HlAmPqS6d3QGUBjP5i3YlCwnkJF6V9WzCkQiNU8Y3L6Z+PWMKOKH8h0UrSrOOk8to9lCtfGUKew1x3jcrs9iLqaccQajB6p47DTLY51F6NmSOZKhEVEBIPAq4c244T7/2V+RqUuyfVtW/BLhkdzy2zKFL4oO6GFGXXT9je5AKGaKcl6/KO4kQjZihA2H6fyU2mFmaNcqcZ/p5BdpsyHyotaCs4rVdElbTiUL5YP0orrwSIxc+DS7sVHyL5W167ZPpeaSghroFTcKQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fujitsu.onmicrosoft.com; s=selector2-fujitsu-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=zw5Lb92gML1BVObKeLwAupteiRVrmbk0l9eEIQngE3U=; b=NTeTn3bOf/eSTl7WDjFogfiywpFyex7ieSE/dmI0EyGfziaxz9HsqqCqtJtfJx4eYSZnoazKg8txe/+8IG+Upq3T6igBoX9ee/BA4v6FVUjbT2ye8LO/86q6EJoTkB7IlHRJQ4KU9QmaFyOMqQ+CaNb8hUWsmrIDjR4NvwPO62I= Received: from OS0PR01MB6113.jpnprd01.prod.outlook.com (2603:1096:604:c9::13) by OSZPR01MB6277.jpnprd01.prod.outlook.com (2603:1096:604:e8::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4173.20; Fri, 28 May 2021 06:01:41 +0000 Received: from OS0PR01MB6113.jpnprd01.prod.outlook.com ([fe80::f122:4a24:2100:4896]) by OS0PR01MB6113.jpnprd01.prod.outlook.com ([fe80::f122:4a24:2100:4896%7]) with mapi id 15.20.4173.022; Fri, 28 May 2021 06:01:41 +0000 From: "tanghy.fnst@fujitsu.com" To: pgsql-hackers Subject: RE: [BUG]Update Toast data failure in logical replication Thread-Topic: [BUG]Update Toast data failure in logical replication Thread-Index: AddTcgv8Nt5BglTBRrmPdu/DTUfpFAAFG9Rw Date: Fri, 28 May 2021 06:01:41 +0000 Message-ID: References: In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=fujitsu.com; x-originating-ip: [223.111.68.150] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 54177317-a834-4a4d-4ff2-08d9219e1092 x-ms-traffictypediagnostic: OSZPR01MB6277: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:6430; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: s++VJaTg4XZrwyMtPbHPvKlmm63PHEOnoD676ugCGFjfLkUoyGQ4FweqDc9i9nJsMD0J7nbwAnlutBkoAFpr4HFNCMQD7vXeX7Az0Ae/AL4bajnA0wffIkH0Ryuj0MWyNjZyPEaeDJl51ZNakTb7o10lwwCPfPP7NQaA6F7Phzw5vf3wMjuAGgMuf26VeZ4H/JpWgLYkuecXTQuBq/KgjSpcckvip/UjDe2VExWSRikk9ShLaYh3JRZI7bppXZxynvQZ3gWHn26yhZP61heCh/owQNEZh26qJiyX6Na5B9kySKo01Qc9mWM0JC+hzguM5xMd7TLxRiYhhbJKTSP4Wb0P1J6DURF7Z4iIpN3wN3TrG8otMeEvDQNKJZZVRNPScqSM/7ObWfHHppWiucjkq6HVbHyUUATwCMOwh5SQLGiB/6EjzUHB73+4waPCfr+FiUIM/627gYdbdGosZt0ue1Xh0MHfduPKnK5ALRLywnLn6j0SM3+MLVzj+bSIawZoNhlbCKMl0iAKRTB4PyNeTpxNkTXCDJm3lJPbzamrXmS8taBACQgT8eHPSA/IurOegBDsEomjPH8qbAR+qJGiP5DFKmZhFLrgbgFKqal5v3A= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS0PR01MB6113.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(366004)(39860400002)(136003)(346002)(376002)(396003)(26005)(6506007)(38100700002)(53546011)(52536014)(4744005)(55016002)(7696005)(6916009)(2940100002)(478600001)(86362001)(66556008)(122000001)(85182001)(9686003)(71200400001)(66946007)(33656002)(2906002)(66476007)(64756008)(5660300002)(66446008)(76116006)(316002)(8936002)(8676002)(186003);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?iso-2022-jp?B?Z0tSbzFnUExudGl1a1VpdVhUTVRHWkpoQzJITlpXVlQrM2owWXRGay93?= =?iso-2022-jp?B?anIySktDLzFiek8rN2h1eWYrQWt4L09EeGRyeEpWUnhPb05NeHdwZ0dw?= =?iso-2022-jp?B?dGxTNHRhMkRUMnZsdFdtTkYvdXFXdHNZNFhoRFhXWFJXSzU3aVdqTjBZ?= =?iso-2022-jp?B?YWxaa1lIUHhHY3M1NWh4M0FUWEhxZ21zZEt0WkFKVEdHVnNHQllRckZn?= =?iso-2022-jp?B?Z3ZyOWVtd01zaGpxcmF4SEI2NElQTHM0SDJMZ1dmVUNDODhqN3BUMGh6?= =?iso-2022-jp?B?VUJ0a2V3N3B6L01IblhOV09zaFVQRWhUeGN2UkQycnNGU0NOdlJoN1Nr?= =?iso-2022-jp?B?SzVOQUdLSThxNG5lMzgwcVpGZkRMYkd6MVJtS1dmZUhXWE93dVJmN25p?= =?iso-2022-jp?B?b0ZCeUk3T0dXOXJuUmdpQTdlWWdma3RzNGw1Umd5NURiN011dkR1NlR1?= =?iso-2022-jp?B?SGlGcFgvZkw3RzBJS3JMMnArOHoxdWFLYUdrbmdXZGUydFkxL2tWNFlW?= =?iso-2022-jp?B?eUtxUXNnN2JMZnB3Q21SM3ZHM2NhRTVOTGZJNFptUTZJa3VCNzF1UUtL?= =?iso-2022-jp?B?N1JFOGtjdFQzUEZWL0hJMGx1ejhuNVBzcEoyQnprNGJPK1Urcld5c0ZH?= =?iso-2022-jp?B?SmdYUzJ4MVRRMlJ0TFpNcW5yVVBiY1Z0SE5iWFVuQzZzaVhSLythY3Y5?= =?iso-2022-jp?B?QXI2RG8zbnlEanYxM0RVU0QxRmxqU09nbm1aNFV6QndXVDZYTGdxcXlW?= =?iso-2022-jp?B?YUlpM1pSdnMzeXN2amRJcFV5cTZrM2tuc2tFY0tySVZGY1Y0VHdhaVVX?= =?iso-2022-jp?B?bjlxcjBGZHZSREVVV0RYVlpaSE1KaS82dWovRTV6T05XTWtXdFpoK3NL?= =?iso-2022-jp?B?dzhHWU9qZlQzcUZSYUZuMnFHcHFZZktwUTdQTkIzTFhWbVR1ME1nRlMr?= =?iso-2022-jp?B?dW9HNVdVVks3c0Q4dG9lREwvVytJditlVmtTV3d6U3pUMzRKKzVNcEZE?= =?iso-2022-jp?B?aHJjZjZuenFqekZ6UExtOXNSMXl2TzNnMEhsbG15WFp0MG4rd3NQZzFa?= =?iso-2022-jp?B?R2UwMHNkaUczL2VwQzdDVVVvSGE0NSsyVUo0eldwRXdRZ3BEdGp2dTJK?= =?iso-2022-jp?B?YlVSNktrY2FsQ2wxbVhXbVA1YUJZcHhJV1J0b3dLN1R6WkFSQytPNXJ0?= =?iso-2022-jp?B?Z2JYUkRHOHVWTkYyYTdNbVgvT1JoTFd1KzR0TEsxWWJNLzdEVjNKTlpY?= =?iso-2022-jp?B?WHNJcW84aFE5WmVlSFFuRGhtYnVsc3NGemZXelFCVUVtY3lqWTBWR0ZG?= =?iso-2022-jp?B?VjBmYmVrakJ6QjlCZzdzQXl4R1ZXVFpTcHRaTW4zdHNDTi9Dck9YSTRQ?= =?iso-2022-jp?B?NkZaaGM2UEpaTmxjVTVnbURHZEFGSlkvSCt6Z3d1Vkp4Ym5iamJCaGlL?= =?iso-2022-jp?B?L0oyV2FVN1FWbDU4NTFiYXBIVGVwTVlhUElIZld3bXplNkhVY01CejRl?= =?iso-2022-jp?B?SXFoeWEyTXVMR2d5WUFqZDRtN0hmZ0IyOXFBQ2EzYlU0L2g4aDZhb0xL?= =?iso-2022-jp?B?TmVsREhIVklpUDZCY0tMTzFPUGJ2aVBOa2pNNG16Z3hraGhuOERUWjVP?= =?iso-2022-jp?B?bVF2QzBTL09iMDJUZHkzd2RUSUJRdGIyQW1rdk41UWdWbW1Rb2daN0U5?= =?iso-2022-jp?B?QlM3RU1SdWhGQXFYTkQ2ZmZKL3JnbmZqMFNyOGlsa0VXUHpWQW9pSjhM?= =?iso-2022-jp?B?UlMxa211TEUwa0g3b1Fvb2Z0cmsyMm5Dd2czdVowVVpPM0tmeWFUUnMv?= =?iso-2022-jp?B?Njk5RjM5bGx5aWwyc1YvVE10bnF0Mzk3RXFnSXN6SEJIV3JSY1A0Yjgr?= =?iso-2022-jp?B?TExLUzZ3aUhBd09qVHF1WDlmTkVjaEhmYnd3eHFYUUhXWHNraWJpY0VN?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OS0PR01MB6113.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 54177317-a834-4a4d-4ff2-08d9219e1092 X-MS-Exchange-CrossTenant-originalarrivaltime: 28 May 2021 06:01:41.5452 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: zfB2oPp1Q+lGRq1K86/VKPNfInLkWPruiLjT/3/wkSS7OAPjjg9UNS4V9M98hFQ+i1rOuy1M4bvKHXE13mrG+A== X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSZPR01MB6277 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Friday, May 28, 2021 2:16 PM, tanghy.fnst@fujitsu.com wrote:=20 >I think I just found a bug in logical replication. Data couldn't be synchr= onized while updating toast data.=20 >Could anyone take a look at it? FYI. The problem also occurs in PG-13. I will try to check from which versi= on it got introduced. Regards, Tang