Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wi6RF-0000zb-1q for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Jul 2026 08:18:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wi6RD-00Gji4-1z for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Jul 2026 08:18:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wi6RD-00Gjhw-0H for pgsql-hackers@lists.postgresql.org; Fri, 10 Jul 2026 08:18:24 +0000 Received: from mail-japanwestazlp170110001.outbound.protection.outlook.com ([2a01:111:f403:c407::1] helo=OS0P286CU010.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wi6RA-00000000cUO-40qO for pgsql-hackers@postgresql.org; Fri, 10 Jul 2026 08:18:23 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=vLJ+YJ5CWJnQLndOKRF8EPi0nSBjAiqZjpJPQpfotDtEhwU1pKGWvX9qAlOIcnPvho8hFOZ/1p72TkdK3NDVWyKd/1FZe8f3+kjx5qVHpnRIJ3qrHOQbAfwqF3s0w+IlrkJTJM9qIn3sgxCu+xTFAztfq9GhB/lhZF09zC337ZpndpSRcacZZuAQpHwZXyjvTKsOF8YQrQjT0eo4HEPJqHMZnQmXOV2+1Snr4GvZx5HspHN0gzjqw2STJt4KdwDnDxljPz+nrzYWuMTjGkXAROalTMdUZNpFtxMUY84CaT0g470OeZYjjZkS6++bWeuWQXfo5a2u/B/qZDA3bABQXg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=XitNm2cRcVxvl5ngA9PafYfAo/DPrkQtQuqH0+biG0U=; b=ncZbq7EoBHfBMLTIuL6VTAtxmXftQFC0E+CLs8+ouqOr55jDciErFnoQztRqHT5JoxEoBZM5+4HEkblO77I1UVtT9PZRphmGgOnlYWebJMybZRUBbBHxBYiFd4vCdMw/RldJUA9T4iBCyraGyIhc58UQr1dFyqBbkhCfxSUQf0NIW+ulNIwy76aRWdHAX0+JJkEr7mp9V+WMqbszLDZQIvU1khKqKbdLx3hdyU0yLoQq99N6Ydxg6XVTmfAeWhNR6hQRnE0mau2wADqvy3x91iUuKNq96tvi19vOX/mzirXM6itoicFyUlqB+aRvoTVO7m6yObfg6otfjReCg6tw2g== 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.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=XitNm2cRcVxvl5ngA9PafYfAo/DPrkQtQuqH0+biG0U=; b=FLlabuVP2ulqOEDwx/3ebhqVaeLNOYyKs5xDe7uxQME2/bgnTdzRt8uRSqNmfznNCg4KD1oTy+9zq/03ETeOlVcJtDFlYT39WZZ7HDTizwFxTXuQtDgtiR89GYgT4uLCeDhlg8MDCY7JbfAhKGjdDW+fh7ohmGnexJeKFFHtU9bpKyCB05oGRiSCmzM4z5RoaetX0oj7vZlEO9tsP1mY4SykbBAq1XdICzZJz3GQfZMV67RnFVI3rgvkDpBGCAaMkDvVT40CNewrVTWRuDbEcV4MFblryc/V9H9qQD4PNGssbB3oC+KJbFfEUip7SKStgLDs/dWZfNViU8BsWeUSKg== Received: from OS9PR01MB12149.jpnprd01.prod.outlook.com (2603:1096:604:2e5::8) by TY4PR01MB17080.jpnprd01.prod.outlook.com (2603:1096:405:33a::19) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.21.181.17; Fri, 10 Jul 2026 08:18:15 +0000 Received: from OS9PR01MB12149.jpnprd01.prod.outlook.com ([fe80::8943:2365:dd16:e893]) by OS9PR01MB12149.jpnprd01.prod.outlook.com ([fe80::8943:2365:dd16:e893%5]) with mapi id 15.21.0181.016; Fri, 10 Jul 2026 08:18:15 +0000 From: "Hayato Kuroda (Fujitsu)" To: 'vignesh C' , Noah Misch CC: "amit.kapila16@gmail.com" , "pgsql-hackers@postgresql.org" Subject: RE: sequencesync worker race with REFRESH SEQUENCES Thread-Topic: sequencesync worker race with REFRESH SEQUENCES Thread-Index: AQHdECfvkp63penoBUO7lflAK+dRd7ZmUyUAgAAJmOA= Date: Fri, 10 Jul 2026 08:18:15 +0000 Message-ID: References: <20260710045217.f0.noahmisch@microsoft.com> In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?= =?utf-8?B?NTBfQWN0aW9uSWQ9ODlhMDUyZDMtZmRjNS00MjQzLWE1NGUtMzg4ZTNlZmE3?= =?utf-8?B?ZTVlO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?utf-8?B?ZWNlMDUwX0NvbnRlbnRCaXRzPTA7TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5?= =?utf-8?B?LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfRW5hYmxlZD10cnVlO01TSVBfTGFi?= =?utf-8?B?ZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX01ldGhv?= =?utf-8?B?ZD1TdGFuZGFyZDtNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9OYW1lPUZVSklUU1UtUkVTVFJJQ1RFROKAiztNU0lQ?= =?utf-8?B?X0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0ZmVjZTA1MF9T?= =?utf-8?B?ZXREYXRlPTIwMjYtMDctMTBUMDc6MzQ6MjJaO01TSVBfTGFiZWxfYTcyOTVj?= =?utf-8?B?YzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX1NpdGVJZD1hMTlmMTIx?= =?utf-8?B?ZC04MWUxLTQ4NTgtYTlkOC03MzZlMjY3ZmQ0Yzc7TVNJUF9MYWJlbF9hNzI5?= =?utf-8?B?NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfVGFnPTEwLCAzLCAw?= =?utf-8?Q?,_1;?= authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: OS9PR01MB12149:EE_|TY4PR01MB17080:EE_ x-ms-office365-filtering-correlation-id: 71fbf431-37db-478c-8859-08dede5bca74 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|366016|376014|23010399003|22082099003|18002099003|11063799006|4143699003|56012099006|1580799027|38070700021; x-microsoft-antispam-message-info: maBjh3vKfyHfsyKORUL6zO8cUWcAZIz/7OyBGZN/IN8jr2jcfNUXJhf21LsFP4z62IBXWsxu9Tt/KYbLJ8FGJOYwtDMHxNqsaC+eas5z9yPZtrS6p8qzz7ciNiIj41nisQWwRJZijvlAI3ya3bFChdagqPGa92KZtiEsSgkwXPtjQDMQgMX1ykkn+rhfILTsLXlNihhm8RcqdWXcuEKCKNTUX4Vpo3wh8vz1aO0xDKXov545hXzBj89VxVgOad5fzt88Hv+qEqkPALhHEXj889KP8XLDRIOFzk4OcSrA0fSjgabb1X6CAbOHT/XG+Hjmr7AEunF6t3dlh9z2n/2F3g6xPw7PZJOWC2lnD4b4BKysjtn0u+QgzjvTNZ6OSX+UoBiFiQeZYHL4FJugXnFR+5mwXLEir8VwkiuskHSMF/NbIya1muZMlsZzg2uclT9UrONmOqP95E5jYY9dowUkpeOUljiDN+x9vK9NGVlpYiWHia+myfGeijy9jVV/wHEXSHrvSFhxKAA2u075qpfqVz75t6NTA3OyM76y/dRRWcyUDVqxVgwHOi47xRbbbpmQA1eIi4bZR6+bq2iXrrX1NRDqwXnYBG/l0EESvkUdRB9lrN7sXYX/O42jgrCVodp0QXdc6mhoRl/aK6fdljjLOCt4oAoHX1FwZUNIEVJ//CmVfP87gWW08f6+FS/ClRroBSK3+JGMjeYXD+Dt5u4mWhcViH7OGoT1m8fE42FDUPy2qY2cRzEGQToFo/ovjrML x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS9PR01MB12149.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(366016)(376014)(23010399003)(22082099003)(18002099003)(11063799006)(4143699003)(56012099006)(1580799027)(38070700021);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?L2VkNktmNlVtSUR5TnBYM2pZQms2dVZPTHEvd2NQbDJpMFJ4UUVHK2h3M2NQ?= =?utf-8?B?WFB4c1ZGNm9Vd2tQMHFaRUVoc3k1bUtQRlo2OFIxNGFtRUxsa1RSTFBIbzFP?= =?utf-8?B?SWtoZ1dUMWpiTG9ZQlhXS3FNOVpobWZpRjdnMXdtcStMcHJWZUFyTXBadTF6?= =?utf-8?B?Uk9RbHoxODVGb2NxNnZ0ODFZUlhTS2x4ZUlrRnRmb3BMWkcvWWwzN0M2anVh?= =?utf-8?B?YzhzVEN3RThtSFNRbXFsZEFMTFVLUVRiTjRHRFI2aHZhblpRSFh5emhLajZq?= =?utf-8?B?Nzk5TFJPUlpsSTN5S21ybVZrWjVvcW8xSzhiVk9mQW9DcFpUQmd5ZmZsTjM1?= =?utf-8?B?a3JsOHFDeGswN000WjlONDc1NUFncjJ2ZmxsWG41aXk0NkNUTU9aQ0x0Q1JJ?= =?utf-8?B?YUtpZTZ5T0hNMFVKSW01WUNHT0NjYmYrenJza1VPcm5TQXBUd21UbllwVFFY?= =?utf-8?B?bldST0pJMlkycUVxdWJvSnZKMGpLVnVBa28wRmhReDQ5RWRLMFJ3NlJyWFQ3?= =?utf-8?B?ZkdwUHJpYjk3aUdrNlh0RFB5NW96blR6TGh0SGJMYmo5elVUS2JKREpxV0Jm?= =?utf-8?B?Y09DMTlNOURDbytCOU0ydHJjdTk5Vld2bjNZYVRJUzlrU3FySXdOREE1SitY?= =?utf-8?B?N1FwQkNSUFZYdXF1YUJVZWxLUW1ldTIyUHpVVWJBQ2p3d0Y4bzJBbU8rdDk0?= =?utf-8?B?VS9IWjBSaHBndSsvSEZaR2hKYXdkUTNEMW0wTEEyalRyMDlPNzA4KzhsWGRz?= =?utf-8?B?Vk9zbG9wdEQzSGh1SXdTa1B2eGJJaXVsNzdBVHlWb3VlbVZJM3hnNytZWjFY?= =?utf-8?B?RWtYdC9ZWXEvOWFuaUMyMjNReUlxNHp6MnJldzBPQWJmNFRaY3orT2hsUnpO?= =?utf-8?B?eFhYNUpWL2pLNHdKZXVJT2R1anB5WUNHVnd6UVFNR0VqL1gzc014UEVDUjRW?= =?utf-8?B?bDJNMjZ4WkR4RzBSV0VkcEM0elIwRHhVdmEzY2d6YStRTi9Udm5zc25wR29Z?= =?utf-8?B?eFVHaER5d3lLbWlnZkg0Q04rWlVsbDJsYmtQSXB5SWRyMGtKazV3UjZ5WTZ1?= =?utf-8?B?cmEwWTdKQWdsNWxvSlJHbnVIcHZyMzlLSS9XV0g2QmpWL2trSEZRdFNWN2s4?= =?utf-8?B?bXVKRVZmSkY1NUhIbFJINXN0Ync1TlJTVXpXUkM0cFNzVmdLeFJkOC9pM3pl?= =?utf-8?B?NnBYODhMZTZRTUdaRGVzd3ZzUUtFY2diOEY5WkRCRlluYXFsU0JYZ2J6YytN?= =?utf-8?B?NHRVVkg1MUdJWlVRaTJOZnhjbjNpSWZRcVZxazhuMDdVN1hNU01FWkt6MGdL?= =?utf-8?B?MDJxeE0xL3dqWUp3Z2NFK1VTbmZEZWNhL3dsSmNIMHk2QUJtVlQxR3lzL3Rt?= =?utf-8?B?VU1mVE5BZEJqT2pBaFU0STZoNWV6VXRyWlZ1SXJDT3RnY0wwakFwM2dlaHhl?= =?utf-8?B?b1phRVQxRks1SnBWTjVnNGJvNVQzYzJWaW0xeGtBaWRpK0pXSVpSOTNsYVBu?= =?utf-8?B?YXdjVVR5bkFaR25HTVFqdi9CWWx2a29iNGNhb0NMUy9raVNXQmVpamd4aWI4?= =?utf-8?B?elVCR3N5YUx5ZlZBUmhTK1dxckVFeEJDTkxkejRZNEQreVYweEpUd3lTMHJz?= =?utf-8?B?MVBOcmpMYjZIWUNtUW1Ja0o0bkZuWTRoMFp5Q1hlMVJSc2ZCMDU1aW9lRFNV?= =?utf-8?B?UGlNL01uU21FeWZDQnh3RmxFckZIUElMWmI1NnVuMzcvbUFLWjRxcVNnaC8y?= =?utf-8?B?blRSUExqTG9aREFxL1h4dnU2RjZDQ0h2UnhlQThtNTNSTExmd3kwUk1UcTZF?= =?utf-8?B?L2pHcFovTVJ1RjBWSVdsakFwZGRaWGh3Q3ArbzhLUFRxTGRsODhnZ2xKS0Q2?= =?utf-8?B?a0d6MUluRzM2MXRKOWY3Q3JrUGNtV2tNNWk1MHkreDZKK0F4eklQWnlnR0FG?= =?utf-8?B?UXNnN3FHZnNLSmtqZGFvL2hpejZvWS94Vm1aVnVCR2orTmc2MkR4blJEOHRL?= =?utf-8?B?bXNzYXVhWkNPME02SjFrNURBTDFITHpQaXZGdmpnYmRPL0d6MW9DMGxTbUlV?= =?utf-8?B?ckVFLzRNempEWkJURnlPOEpsandXd3IxQkFYUGc3cXFyQnYvbHFlczlaOTJB?= =?utf-8?B?TDhqa2habEFacGZFSGFUUS95eGVGWjh0K1Q3Y1V2RVh4SUp3U3crWFVLVXZr?= =?utf-8?B?THVJSTlzei8zendCY2wvd0R3QmpUTFdERzUwWFAreDIyR3VjWlMvQk1UYWhm?= =?utf-8?B?MzNzRTA0WWlJZlVmQ2w0a3BTNCtKSWZrM1k3VFFtOTZuVnUzNWFEZmMxWVVX?= =?utf-8?B?TXR4RVNrVGFBWS93Z2R1cG5mWDk4eTl1QXl2dEcvWEJic21YTERRZz09?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Exchange-RoutingPolicyChecked: Zyr8/SVITknoB5cf7TI/BMR9uJkQWjqMyRtDktzWaGV515TLB/DVXmGPH9TEK5VMK5uG3E31P/xogvyI25kxJqAO2rAz16yQKc6e/ygkWnYXpXVYSYin9BENcefzB30BJtDNV/Z2cCXCC64T/x/Z9Gn0U1pSltg2JpSbUefzNODVNjl9xh37qMEcjkLAjUCKWge24risXfp0UpzJnZi8zHtMdktb3MxRfyy3iinlJcuu7x/F8D789Ch744R7bmY1RZZocCj2IkJvhGFChiJsuJUBQa0WoXL4QnNc6CPauSFHHPjg/jwtl632tFNRWGbnpjEZ8HhF0kjYKWUKO0qokQ== X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OS9PR01MB12149.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 71fbf431-37db-478c-8859-08dede5bca74 X-MS-Exchange-CrossTenant-originalarrivaltime: 10 Jul 2026 08:18:15.3010 (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: TPJmT8RNq5bD1atbBQe3Mjs8w6ngHGUsBR/gvH1N6zVdH2nwznrnH8G1vi3Xa2Kz8Ir4Gj0PljSpSE1f4e4fLwBy92/L4QqDVZzFYEAfmC4= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY4PR01MB17080 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGVhciBWaWduZXNoLCBOb2FoLA0KDQpBZ3JlZSB0aGUgYmFzaWMgYXBwcm9hY2ggdGhhdCB3ZSBh dm9pZCB0aGUgcmUtaW5pdGlhbGl6aW5nIHRoZSBjYXRhbG9nLg0KTXkgcHJpbWl0aXZlIGlkZWEg aXMgdG8gZm9sbG93IHdoYXQgc2xvdHN5bmMgZG9lcy4gU2xvdFN5bmNDdHhTdHJ1Y3Q6OnN5bmNp bmcgaXMNCmNoZWNrZWQgZnJvbSB0aGUgU1FMIGZ1bmN0aW9uIGFuZCB0aGUgc2xvdHN5bmMgd29y a2VyLCBhbmQgZWl0aGVyIG9mIHRoZW0gY2FuDQpjb250aW51ZS4gU28gd2UgbWF5IGJlIGFibGUg dG8gaGF2ZSBMb2dpY2FsUmVwQ3R4U3RydWN0OjpzeW5jaGluZ19zZXFzIG9yDQpzb21ldGhpbmcg dG8gaW5kaWNhdGUgdGhlIHN0YXR1cy4NCkJ1dCB0aGVyZSBtaWdodCBiZSBvdGhlciB3YXlzLCBu ZWVkcyB0byBiZSBpbnZlc3RpZ2F0ZWQuDQoNCkJlc3QgcmVnYXJkcywNCkhheWF0byBLdXJvZGEN CkZVSklUU1UgTElNSVRFRA0KDQo=