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.94.2) (envelope-from ) id 1sbvN7-002WoJ-TR for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Aug 2024 05:07:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sbvN5-00BlUT-Ur for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Aug 2024 05:07:31 +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.94.2) (envelope-from ) id 1sbvN5-00BlUL-GY for pgsql-hackers@lists.postgresql.org; Thu, 08 Aug 2024 05:07:31 +0000 Received: from esa19.fujitsucc.c3s2.iphmx.com ([216.71.158.62]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sbvMy-003kB5-6T for pgsql-hackers@lists.postgresql.org; Thu, 08 Aug 2024 05:07:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1723093644; x=1754629644; h=from:to:cc:subject:date:message-id:mime-version; bh=gVZjsi9On+A8bt/gZmWKuctE9DKQWf6dOnJa43Tl17g=; b=TIlfduxIVnAd68vRLLHbnwuROx2ELQ/0hZaoXjXxhtPymRU+xv8UE+jc us3qymZfvOMH/dIiOWSoMKTVScSR1MX8MY+kBPchc/vzmJm7k2EU2SGSW CI3ZgRvFQeRCeYpn6STizRXddQYETzGlOMd6FLJ52hwPcwOLKXkhXEsmV CFBLzPF1F432mQHBTwUw8sduWlbVfdYTDwGrthjacuG3I34hv+IuIId/i s3uyjl1XBoAUj5pHXeUc9EnKUiBi3zOJIVfVEPMxxsx24WQWPo/grqiCh YBb803yFcMZyiPbmqu/62eIeankYuz+METEAWoMNxHNTGuGFd0VhCZmUV g==; X-CSE-ConnectionGUID: S/DyERGiQ2GNBSHBWkzMRw== X-CSE-MsgGUID: LdcQJJQ0SSK4tWkUV850wg== X-IronPort-AV: E=McAfee;i="6700,10204,11157"; a="127113618" X-IronPort-AV: E=Sophos;i="6.09,272,1716217200"; d="sh'?scan'208,223";a="127113618" Received: from mail-japanwestazlp17010002.outbound.protection.outlook.com (HELO OS0P286CU011.outbound.protection.outlook.com) ([40.93.130.2]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 08 Aug 2024 14:07:22 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=G8WTg2aXgFt2Ov6NxWwzzn3x/fJGeL6zPNf2BL+ADORmX9mktudwL46Zw4ALVqp6siLoYz5RwKz7B64ZWg5EqWO+IeE1+aY0ESsn4tDbMof/ExPoHdEXMugMOjizIU5YPlKEthseV71GEGyCkgGSg6ETIro7oyi1NsDvX9ezm4wdutkMjot/gmS85tFkWEu12Q3sr6MdTc7RwL3gxz/8yiMRjuDywyPTJc/EavlSfYQY+Xp8ob3MXvhFNOr7Q50Z/QpfbZvQqO3OEPQFKfK5i9sV0D4zbs53yMS/tLJEF+YWmFIZ5xkn0Yi1CUohz8subkTysUyb843wTJM0HKMlbg== 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=lwjffGVHMwlLL2AjrOuGPO5R1zOL0omB/q1LXNMSwKQ=; b=y+qiDAQwiCbyuULGHD7SJKAJ9HuTwteFUKhwMVNWE8fQOT/w6MKF3gWxCGWnCrimCu/mfjF8VTWhhs/b/bCPMyFPzl3RSOl897wxX/RKI6hiSi4XTdw8sBN89SQuz31POKzwm4nJEmON8hN9V0BUYcP5j/Sa02TWHHIuLJ8uY4B6DcbFXTJiDY5OHgI7IMfAFKDEaeGvi8mYqpNf+ePr4BzZuN9Y/0h3CwwQ7lehQHDzwLQFF9Bhztdz9VasNwvZ1KwzuTyRqSW+wpSz4UpZmzuQ05gW1eONIQKV9ev5KFRCc3xPzaMXO0PSozdQUE2bf1zdrnzmFifJCIuCzm2DEw== 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 Received: from TYAPR01MB5692.jpnprd01.prod.outlook.com (2603:1096:404:8052::10) by TYYPR01MB6825.jpnprd01.prod.outlook.com (2603:1096:400:d0::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7849.14; Thu, 8 Aug 2024 05:07:18 +0000 Received: from TYAPR01MB5692.jpnprd01.prod.outlook.com ([fe80::6a57:b8bb:28f:6591]) by TYAPR01MB5692.jpnprd01.prod.outlook.com ([fe80::6a57:b8bb:28f:6591%5]) with mapi id 15.20.7849.013; Thu, 8 Aug 2024 05:07:18 +0000 From: "Hayato Kuroda (Fujitsu)" To: "'pgsql-hackers@lists.postgresql.org'" CC: Amit Kapila , "shveta.malik@gmail.com" Subject: [bug fix] prepared transaction might be lost when max_prepared_transactions is zero on the subscriber Thread-Topic: [bug fix] prepared transaction might be lost when max_prepared_transactions is zero on the subscriber Thread-Index: AdrpUMp7BEoQ2P+xR7iU3zY3bjFG1w== Date: Thu, 8 Aug 2024 05:07:18 +0000 Message-ID: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: yes X-MS-TNEF-Correlator: msip_labels: MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ActionId=d5a28e20-0ea5-4109-b754-a03cf95720fb;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ContentBits=0;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Enabled=true;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Method=Standard;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Name=FUJITSU-RESTRICTED?;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SetDate=2024-08-08T04:54:07Z;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SiteId=a19f121d-81e1-4858-a9d8-736e267fd4c7; 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: TYAPR01MB5692:EE_|TYYPR01MB6825:EE_ x-ms-office365-filtering-correlation-id: f4e5d202-4227-4224-aa44-08dcb767f9ee x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|366016|376014|1580799027|38070700018; x-microsoft-antispam-message-info: =?iso-2022-jp?B?citIZngrVVVBbkswcS9pWTJ5aGx0bU9Ba2g4STQ3UWJLVzVlNk55OTlt?= =?iso-2022-jp?B?WkpLQjgva1pwM3RiVStpemUxa2hhZlRoZWVMK3c0MFFmZ1RGZi85SHF3?= =?iso-2022-jp?B?NzhnMVl4NlFGRG1mNjZ3bHpMOFZjUzRWOStxVHhuQTh2ZFBzSkZ3OU5P?= =?iso-2022-jp?B?SHRaSFhKYWVUc0tCRnA0V2tyam1HWk53SGg4OEdSNDhhaFZOYXZ6MXEr?= =?iso-2022-jp?B?K0pDVUJUZ1ZUUGxsSVlxU2FWSHArUUc5TFF4MzRBZGl2ekhCOW9RQ096?= =?iso-2022-jp?B?bldOQ0VMd0JwVTdjQnRxc2ptek9CSTIvUHNsekltcW9FdVJCYW5GR1lp?= =?iso-2022-jp?B?VXRwaTFEakw2WE9zZ3ArYVVDVGRiSkJIMHk5Z3ZKYXdYYzdtYklDbEJv?= =?iso-2022-jp?B?dm52MXdWQzM5emFpTDNlY216RUEwNTBVQzlaUjRSd1lRV3RaYk12K05a?= =?iso-2022-jp?B?cmtqQy9SSGFRSU1SVHVqSnZWSFR0ZGJFV2UzbnJMNEltY0JKUmhQcmJy?= =?iso-2022-jp?B?TmxnayswbkJpMUVxK0VhS2JzcW12NUZnSEJRSGpXM1AwS2t5M1RDWFRy?= =?iso-2022-jp?B?cjVwYTM2VG8vc0diUzhzZ1FJcHJkOGNmZGJTVzZpa2F5MW1MNmliZTZl?= =?iso-2022-jp?B?ekIzeVAycjI2ZWsySWNDUkNVOXZNazVkaWtDbFhGTWVNMWlPd2U3by9O?= =?iso-2022-jp?B?K0FRRWRwWlZGeUtwb1p3anQyWUhjTWdIYXRnWERuWDd0T1hUbVoyaVZ0?= =?iso-2022-jp?B?QU4yZnBhdkdZK21Fb3doT3l2YUhKMERkT2dZQnBQMlBoSUNvcDhtWGdn?= =?iso-2022-jp?B?UHhVQzFHKytwNVFWVHFNeWkwNFRTby8yODJFcDFROEFvc2lNUmFud042?= =?iso-2022-jp?B?WHVGSm5ZbFVqUjc1V3liUG5JV1VhamJuaFhHYmpRZU56VUdtUnRlUnBi?= =?iso-2022-jp?B?YUY2NjFvNUt3WTM2ZTlyVVpkbHJJbDZkUVpienlSR0JBTlhmVWFmVG5u?= =?iso-2022-jp?B?M2krb1JPb3NDRGdBZCtpa1hvNjhtZUliQzVkTWJxMkcwOGlkZFhCMjlD?= =?iso-2022-jp?B?MkpSU1ZKcGJJRkgrMG9qSThEQ3dkOTkwREFuZ1lsc0wwQlhJT3JWcm1C?= =?iso-2022-jp?B?cDBEOW9GZW03OFBFd1MyeFowczVmbWRrOVE0M1JqL3ltZGhjQmpEa2N2?= =?iso-2022-jp?B?OVlGS2JJOVpxS1VRZE4wY3ZqaVk3WnpzdUdLMldYSkVXM2NGUTkwZG4r?= =?iso-2022-jp?B?R3BaT1NVTXhmajc2Q0Yra1pnMDhBS2NZMU5IbjVPNnhpT2RYRlJtZWR2?= =?iso-2022-jp?B?YmxoanYrSy9ia3gwZ3REMmIrZDRPK0xrK2pSbEgraTRVVHpKdHFYWDlq?= =?iso-2022-jp?B?djgwUk1UYURhem1iVk9Oc1NPQ0RENGxJcHMzT0V6cXJHUisweHQwSHlG?= =?iso-2022-jp?B?UmtITEZLSU13NHp1QUNrbmRsSFRCelJLR0NWWU1OVTkvMGozRktqd3Yz?= =?iso-2022-jp?B?aFp2dUVoZHE1Z0JHU3duVTQzTEl3RXBTMVY4T0FxYS83RGFUYVVaUlV0?= =?iso-2022-jp?B?dTVtN3EzaDdiZm9BYzJJSGp1a3p0NlZ5dWswQmdQakJrQ3doOTVGRnpu?= =?iso-2022-jp?B?OFA3OHk5M0RQbEEwb0NBMWc0WjZvdjVtQThrUFh1QlJ4OWN1ajhIbE9m?= =?iso-2022-jp?B?dkt5c2U1S292OWU3bFdJd0tNMXJNSVdza0pIN2lHcWxsbWRmaVI2aGZB?= =?iso-2022-jp?B?eFNWOS9mZnFraVlpOFE4VHl4ejZKVGZwMUNYSTVVWi9QU1JVVzQ0SzRz?= =?iso-2022-jp?B?K29LVGIzRlFQRmdZckNLeHBkMEg4UHpSWWczdE5PQnA3R013aldGSHVm?= =?iso-2022-jp?B?dXJMcjg2KzNBMjFhRFIyRlVXRm1MelgvRmpuZk9HQkV5NExZWmRvb2Rv?= =?iso-2022-jp?B?WWxUQi9HRTJLVEl4ZStISUVROGkxYmx5a2VMUXFTZUlSaVhQM1JPTXdH?= =?iso-2022-jp?B?QkQwR2k3cnE2QzRaZ1B1emNXcWYxdlJJR3VwNEFBcFU1S1p3OHVkNG00?= =?iso-2022-jp?B?Nnc9PQ==?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYAPR01MB5692.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(366016)(376014)(1580799027)(38070700018);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-2022-jp?B?UjR6Q1FFa1JNREpOS2F3eFdCWW9mVHRXRjZsak9BVnI2TlM1T3FtZDdo?= =?iso-2022-jp?B?eGkrOTlHRTNyWmdUWkdJU0czcmNlcDZRWEk2V2p5ZnVQcGhuaWFsWTBC?= =?iso-2022-jp?B?d3FEUVlzd2g4c0R6ZnZ6VXg2MndicXdHeUx2WExKbFZadzVzRHBkOXZL?= =?iso-2022-jp?B?bmlnWlcyRnhGUWZyZkJMdnE0UFNVdTZleXF0eUdhN3JkWXBFUDgwWFQz?= =?iso-2022-jp?B?aDBWZi84TG5yS0l3NkhnMjRmNzR3emFOQ1RWZFRGVVFJblpkdzB3UWdQ?= =?iso-2022-jp?B?Yk04NWRsQjdDZkZhSFRHNVdoeFQrcFk2NWsrbGZxSzlDaFhsL29telRv?= =?iso-2022-jp?B?cVdWUU5sYWRQZ1o4Y29EYitLSG5zSG5HS3lZWDA0WmFTUk1QeURZVm9K?= =?iso-2022-jp?B?ZW9wSlVhVEN0ZWlIYWZTcUY4RjZnTnBwZm9mbGkzRkhOU1RFbU5Gd0dr?= =?iso-2022-jp?B?a25DL3M2RExRSnorbUp5Wk00NS9YL21zQkwxOGE0U0YyNnRVcnhzWGpz?= =?iso-2022-jp?B?WktQTFJuSXdoOStJUVYvVVlGZEJkZ0ZMQXprU0o5MktaTEVnY3NZNUNm?= =?iso-2022-jp?B?aDRROWprN1QxR3d3L3E1bTNTc2ViaG9GOXNaUnF1V3dhazJUMW9VeVpZ?= =?iso-2022-jp?B?TnoxeEk5RTJMMndacWtEejJwdkw3SEM0Mnhvb3RBdGVpMElYVEFlQTNL?= =?iso-2022-jp?B?cWFKQ1ZLOS9PRkUvQ0NjbXIvRVJ2WjltOE93RTJXR2h4dWtMdUFpQitz?= =?iso-2022-jp?B?ZEpGQmpBQk1ueENCRzF1UWcrSU1IaVlpSXhVeitQaEx6cEtsejBpQTBB?= =?iso-2022-jp?B?RkFqcHlnNVMzbUR2VzVQcldSZ05Wc1BnbXZmU3FodTEyTmVuazlDdC9J?= =?iso-2022-jp?B?M1lLd3dNMFczMGhzVWVnd21IZ3dXd1VKWVVHRzUxQXIvV2hGMTEvN1Fj?= =?iso-2022-jp?B?djVDQVNDQTRPK0RDZ29mR0pmZitaTjFWV1M4VElycnhPZzF1SHpTSHRo?= =?iso-2022-jp?B?c3dmdDY5c0J3bVI0bXAwSEJmN2tvZktrbHpzUERyalp5QkJSNEI0dGhZ?= =?iso-2022-jp?B?RkJBRTgxSjFueHcvemdqdUI1YUJBMGxwNElybXVMNzhXMDVMeFBJOFZu?= =?iso-2022-jp?B?ZytaY1hxV3ZiZ2hPVGRXLzA5S01XQlpTandvb2hUdGhsc3NOVHBRWHZJ?= =?iso-2022-jp?B?dy94ZlZESkhVVHJCQ2pyZnQzVEpvZ3JjRzFCc3IySDFiS3ZlM3UyTGNU?= =?iso-2022-jp?B?dzQwRXVadEN3bjdIbys4RzNvbHNVcVlpbk96S1dkUDJzZmpyRXhOWERU?= =?iso-2022-jp?B?RGsxZWVXTUFNbUNUZ3BsVDNRbGdJOXBKL3QxL3dRZzVyNFhpZnBIRmIv?= =?iso-2022-jp?B?R3VKQnZqaHRhOVVSVVRNRzdUM0FyNFJqMjhscVB5c1hqbVg3Vkc3OVpZ?= =?iso-2022-jp?B?eEszamUzL1lZK3QzcU1tYWVCWnp1aU5Mcm05ZUVXZDhvSjl2bGdxeHpx?= =?iso-2022-jp?B?ZDF6QnJPZmlsbjIzRzBoMEorTnppNEhZL3lyWFhaTHpiR2c1K3Q4M21a?= =?iso-2022-jp?B?R3dWdUdmQmtSNFFHb3QrNnk4aDNMT3NoZ0pjTXpaWlduRE40d1lGYitn?= =?iso-2022-jp?B?ZkF2WHVhdFZKT1dnYlI5L3cyWDd3SXhxSDVLOFRrZ3ZwcEJwcXZGRGg2?= =?iso-2022-jp?B?TmNFTzNBTDI5cEVWWWxsZ0pZUVAxaHVWMXdlY3JZUkRoZ2tXbnl3a0Nn?= =?iso-2022-jp?B?d0RLV0JwTGxqYnFlaWFNb3VNdDBVV3FXYjdSMTJZZFJsZjB1eDZEL2sx?= =?iso-2022-jp?B?Ykx5TzVYZlJnUmc0MTNyQVRtRG1JN3NQRzQzZ2R3RFo4U2tJc1JScmJu?= =?iso-2022-jp?B?ZVFOOVlPY0FCdjBoSTE1VERna0RFTmpYM2YvbEFSNVNYTkh0WHNMY2ha?= =?iso-2022-jp?B?MDBPNUFSRk9JekpSSng0K0ljN25XdHh5bUJXcUVWV3EwQkZxdXBsc05P?= =?iso-2022-jp?B?S0lIWk1yRURiRUR6TWJqbUdvNWFjTmhkMCtnZWUrcFdzNFZGMVlOSUVP?= =?iso-2022-jp?B?MWlIUmgrOVhkajNuWnhJVFVsZ2VrZEI1ejN6K3dJSkhtU202MXBTRjRT?= =?iso-2022-jp?B?WlZ3UFN5MTFCRTYzRURKNEVNSURrTnpUZlVBblFNSUk0Zng4azk2aEd0?= =?iso-2022-jp?B?MlhUUlkvTEl4YzVjWGhvU1lTeXJCNGxKVFdTZ0d4V0tncDlGb0czT1BQ?= =?iso-2022-jp?B?R1dpM3MvNVZYMnI0TW1hTWs5emlvemJhUGNiTm0zdG4vNDk2TmYrYXc4?= =?iso-2022-jp?B?M0VnUw==?= Content-Type: multipart/mixed; boundary="_003_TYAPR01MB5692FAC23BE40C69DA8ED4AFF5B92TYAPR01MB5692jpnp_" MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: g9weUzqvYRjHEOib021qNTQIkVi8eta8KaGHIui2iO31Mo8hEjXbcJvtORjijBbN+cwpl6FhKx0d8MGEEJoqbOBxaIfBo9p6OgGGAuNmRzBnI2COsO1BenxTqsk/ktqU8Nz/+ne0n170hhNXhfJhWavtUFwsiCFotolRidBBafVNWf4eB1AKEc6vGPIFmugzVlOqVWbn/9FS1TxcUkuqmRyUmyRRgmNZVl0hHGcsCEn1rJGpHYwf6yBrbqRrMMBBCyvQdu1mPTqDwVb39sQ4qHgUSwvxn0SUuFctV4NxIuCFu+L3SxyDe6lcehi+9aviEv9etBNAibzs7nc9Ms8q8J9aQ4peUe5eyFWfOSsam61oHOahpnBvf1j95e8mSUSZ5nOcTZdHNqdycp2lRPaOkts+QdmdhOVCLBihovc8rS2CYQfx1sB6nVZlPLtCzaN1ZQSHqzhh1yn8Ph/W4lX/r49yJONoUJX7cjV1Cf8wK7O/vlHTKuRLuEJRIomz+UEOmkTsd4mLYfnzjEL5SikNjoQeDidrHLynfCp8xcW4LjkL9DagzIzpqStSTJXCbZMklp/sZ2BFu53kKs+dItcwxo1siChM7mhyIIHBFBBfFzCjRyBm77zz3+kJ8k8M42fV X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYAPR01MB5692.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: f4e5d202-4227-4224-aa44-08dcb767f9ee X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Aug 2024 05:07:18.2096 (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: 8dUEkJB53E3wQ/2/3G5ect7rFC8xhoacEAqISs0xLJFlu1qVLp2oRTkVpFhuEUMzuqgCkBLG4iN/jhkvOw/qP9JmUCyGRMMhPSP/M8fH9g8= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYYPR01MB6825 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_003_TYAPR01MB5692FAC23BE40C69DA8ED4AFF5B92TYAPR01MB5692jpnp_ Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable Dear hackers, This thread forks from [1]. Here can be used to discuss second item. Below part contains the same statements written in [1], but I did copy-and-= paste just in case. Attached patch is almost the same but bit modified based on t= he comment from Amit [2] - an unrelated change is removed. Found issue =3D=3D=3D=3D=3D When the subscriber enables two-phase commit but doesn't set max_prepared_t= ransaction >0 and a transaction is prepared on the publisher, the apply worker reports an= ERROR on the subscriber. After that, the prepared transaction is not replayed, wh= ich means it's lost forever. Attached script can emulate the situation. -- ERROR: prepared transactions are disabled HINT: Set "max_prepared_transactions" to a nonzero value. -- The reason is that we advanced the origin progress when aborting the transaction as well (RecordTransactionAbort->replorigin_session_advance). S= o, after setting replorigin_session_origin_lsn, if any ERROR happens when prep= aring the transaction, the transaction aborts which incorrectly advances the orig= in lsn. An easiest fix is to reset session replication origin before calling the RecordTransactionAbort(). I think this can happen when 1) LogicalRepApplyLo= op() raises an ERROR or 2) apply worker exits. Attached patch can fix the issue = on HEAD. [1]: https://www.postgresql.org/message-id/TYAPR01MB5692FA4926754B91E9D7B5F= 0F5AA2%40TYAPR01MB5692.jpnprd01.prod.outlook.com [2]: https://www.postgresql.org/message-id/CAA4eK1L-r8OKGdBwC6AeXSibrjr9xKs= g8LjGpX_PDR5Go-A9TA%40mail.gmail.com Best regards, Hayato Kuroda FUJITSU LIMITED --_003_TYAPR01MB5692FAC23BE40C69DA8ED4AFF5B92TYAPR01MB5692jpnp_ Content-Type: application/octet-stream; name="v2-0001-Prevent-origin-progress-advancement-if-failed-to-.patch" Content-Description: v2-0001-Prevent-origin-progress-advancement-if-failed-to-.patch Content-Disposition: attachment; filename="v2-0001-Prevent-origin-progress-advancement-if-failed-to-.patch"; size=4172; creation-date="Thu, 08 Aug 2024 05:01:30 GMT"; modification-date="Thu, 08 Aug 2024 05:02:46 GMT" Content-Transfer-Encoding: base64 RnJvbSBlYjRlOTczNzA0MGJlYjA4ZTRhMjU2NzY0M2RlZTJkZmUwMmM0ZThiIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBIYXlhdG8gS3Vyb2RhIDxrdXJvZGEuaGF5YXRvQGZ1aml0c3Uu Y29tPgpEYXRlOiBUdWUsIDIzIEp1bCAyMDI0IDA4OjQwOjI5ICswMDAwClN1YmplY3Q6IFtQQVRD SCB2Ml0gUHJldmVudCBvcmlnaW4gcHJvZ3Jlc3MgYWR2YW5jZW1lbnQgaWYgZmFpbGVkIHRvIGFw cGx5IGEKIHRyYW5zYWN0aW9uCgpUaGUgb3JpZ2luIHByb2dyZXNzIGlzIGFkdmFuY2VkIHdoZW4g YWJvcnRpbmcgYSB0cmFuc2FjdGlvbiwgaW50ZW50ZWQgdG8Kc2lnbmlmeSB0aGUgc3VjY2Vzc2Z1 bCBzdHJlYW1pbmcgYW5kIGFwcGxpY2F0aW9uIG9mIHRoZSBST0xMQkFDSyBmcm9tIHRoZQpwdWJs aXNoZXIgdG8gdGhlIHN1YnNjcmliZXIgaW4gc3RyZWFtaW5nIHBhcmFsbGVsIG1vZGUuIEJ1dCB3 aGVuIGFuIGVycm9yCm9jY3VycmVkIGR1cmluZyB0aGUgY29tbWl0IG9yIHByZXBhcmUgYWZ0ZXIg c2V0dGluZwpyZXBsb3JpZ2luX3Nlc3Npb25fb3JpZ2luX2xzbiwgdGhlIG9yaWdpbiBwcm9ncmVz cyB3YXMgYWR2YW5jZWQgYXMgd2VsbCB3aGljaAppcyB1bmV4cGVjdGVkLiBUaGlzIGxlZCB0byBz a2lwcGVkIHRyYW5zYWN0aW9ucyB0aGF0IHdlcmUgbm90IHJlcGxpY2F0ZWQgYWdhaW4uCgpGaXgg aXQgYnkgcmVzZXR0aW5nIHJlcGxvcmlnaW5fc2Vzc2lvbl9vcmlnaW5fbHNuIGluIGNhc2Ugb2Yg ZXJyb3IuCgpPcmlnaW5hbGx5IHJlcG9ydGVkIGJ5IEhvdSBaaGlqaWUKLS0tCiBzcmMvYmFja2Vu ZC9yZXBsaWNhdGlvbi9sb2dpY2FsL3dvcmtlci5jIHwgMjggKysrKysrKysrKysrKysrKysrKysr KysrCiBzcmMvdGVzdC9zdWJzY3JpcHRpb24vdC8wMjFfdHdvcGhhc2UucGwgIHwgMTQgKysrKysr KysrKystCiAyIGZpbGVzIGNoYW5nZWQsIDQxIGluc2VydGlvbnMoKyksIDEgZGVsZXRpb24oLSkK CmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9sb2dpY2FsL3dvcmtlci5jIGIv c3JjL2JhY2tlbmQvcmVwbGljYXRpb24vbG9naWNhbC93b3JrZXIuYwppbmRleCA2ZGM1NGM3Mjgz Li43MGU0MTEzNjQ0IDEwMDY0NAotLS0gYS9zcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9sb2dpY2Fs L3dvcmtlci5jCisrKyBiL3NyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwvd29ya2VyLmMK QEAgLTQ0MDksNiArNDQwOSwxNCBAQCBzdGFydF9hcHBseShYTG9nUmVjUHRyIG9yaWdpbl9zdGFy dHBvcykKIAl9CiAJUEdfQ0FUQ0goKTsKIAl7CisJCS8qCisJCSAqIFJlc2V0IHRoZSBvcmlnaW4g ZGF0YSB0byBwcmV2ZW50IHRoZSBhZHZhbmNlbWVudCBvZiBvcmlnaW4gcHJvZ3Jlc3MKKwkJICog aWYgdGhlIHRyYW5zYWN0aW9uIGZhaWxlZCB0byBhcHBseS4KKwkJICovCisJCXJlcGxvcmlnaW5f c2Vzc2lvbl9vcmlnaW4gPSBJbnZhbGlkUmVwT3JpZ2luSWQ7CisJCXJlcGxvcmlnaW5fc2Vzc2lv bl9vcmlnaW5fbHNuID0gSW52YWxpZFhMb2dSZWNQdHI7CisJCXJlcGxvcmlnaW5fc2Vzc2lvbl9v cmlnaW5fdGltZXN0YW1wID0gMDsKKwogCQlpZiAoTXlTdWJzY3JpcHRpb24tPmRpc2FibGVvbmVy cikKIAkJCURpc2FibGVTdWJzY3JpcHRpb25BbmRFeGl0KCk7CiAJCWVsc2UKQEAgLTQ2MTksNiAr NDYyNywxOSBAQCBJbml0aWFsaXplTG9nUmVwV29ya2VyKHZvaWQpCiAJQ29tbWl0VHJhbnNhY3Rp b25Db21tYW5kKCk7CiB9CiAKKy8qCisgKiBSZXNldCB0aGUgb3JpZ2luIHN0YXRlLiBUaGlzIGlz IG5lZWRlZCB0byBwcmV2ZW50IHRoZSBhZHZhbmNlbWVudCBvZiBvcmlnaW4KKyAqIHByb2dyZXNz IGlmIHRoZSB0cmFuc2FjdGlvbiBmYWlsZWQgdG8gYXBwbHkuCisgKi8KK3N0YXRpYyB2b2lkCity ZXBsb3JpZ2luX3Jlc2V0KGludCBjb2RlLCBEYXR1bSBhcmcpCit7CisJcmVwbG9yaWdpbl9zZXNz aW9uX29yaWdpbiA9IEludmFsaWRSZXBPcmlnaW5JZDsKKwlyZXBsb3JpZ2luX3Nlc3Npb25fb3Jp Z2luX2xzbiA9IEludmFsaWRYTG9nUmVjUHRyOworCXJlcGxvcmlnaW5fc2Vzc2lvbl9vcmlnaW5f dGltZXN0YW1wID0gMDsKK30KKworCiAvKiBDb21tb24gZnVuY3Rpb24gdG8gc2V0dXAgdGhlIGxl YWRlciBhcHBseSBvciB0YWJsZXN5bmMgd29ya2VyLiAqLwogdm9pZAogU2V0dXBBcHBseU9yU3lu Y1dvcmtlcihpbnQgd29ya2VyX3Nsb3QpCkBAIC00NjQ3LDYgKzQ2NjgsMTMgQEAgU2V0dXBBcHBs eU9yU3luY1dvcmtlcihpbnQgd29ya2VyX3Nsb3QpCiAKIAlJbml0aWFsaXplTG9nUmVwV29ya2Vy KCk7CiAKKwkvKgorCSAqIFJlZ2lzdGVyIGEgY2FsbGJhY2sgdG8gcmVzZXQgdGhlIG9yaWdpbiBz dGF0ZSBiZWZvcmUgYWJvcnRpbmcgdGhlCisJICogdHJhbnNhY3Rpb24gaW4gU2h1dGRvd25Qb3N0 Z3JlcygpLiBUaGlzIGlzIHRvIHByZXZlbnQgdGhlIGFkdmFuY2VtZW50CisJICogb2Ygb3JpZ2lu IHByb2dyZXNzIGlmIHRoZSB0cmFuc2FjdGlvbiBmYWlsZWQgdG8gYXBwbHkuCisJICovCisJYmVm b3JlX3NobWVtX2V4aXQocmVwbG9yaWdpbl9yZXNldCwgKERhdHVtKSAwKTsKKwogCS8qIENvbm5l Y3QgdG8gdGhlIG9yaWdpbiBhbmQgc3RhcnQgdGhlIHJlcGxpY2F0aW9uLiAqLwogCWVsb2coREVC VUcxLCAiY29ubmVjdGluZyB0byBwdWJsaXNoZXIgdXNpbmcgY29ubmVjdGlvbiBzdHJpbmcgXCIl c1wiIiwKIAkJIE15U3Vic2NyaXB0aW9uLT5jb25uaW5mbyk7CmRpZmYgLS1naXQgYS9zcmMvdGVz dC9zdWJzY3JpcHRpb24vdC8wMjFfdHdvcGhhc2UucGwgYi9zcmMvdGVzdC9zdWJzY3JpcHRpb24v dC8wMjFfdHdvcGhhc2UucGwKaW5kZXggNWU1MGYxYWYzMy4uMTkxNDdmMzFlMiAxMDA2NDQKLS0t IGEvc3JjL3Rlc3Qvc3Vic2NyaXB0aW9uL3QvMDIxX3R3b3BoYXNlLnBsCisrKyBiL3NyYy90ZXN0 L3N1YnNjcmlwdGlvbi90LzAyMV90d29waGFzZS5wbApAQCAtMjMsNyArMjMsNyBAQCAkbm9kZV9w dWJsaXNoZXItPnN0YXJ0OwogbXkgJG5vZGVfc3Vic2NyaWJlciA9IFBvc3RncmVTUUw6OlRlc3Q6 OkNsdXN0ZXItPm5ldygnc3Vic2NyaWJlcicpOwogJG5vZGVfc3Vic2NyaWJlci0+aW5pdDsKICRu b2RlX3N1YnNjcmliZXItPmFwcGVuZF9jb25mKCdwb3N0Z3Jlc3FsLmNvbmYnLAotCXFxKG1heF9w cmVwYXJlZF90cmFuc2FjdGlvbnMgPSAxMCkpOworCXFxKG1heF9wcmVwYXJlZF90cmFuc2FjdGlv bnMgPSAwKSk7CiAkbm9kZV9zdWJzY3JpYmVyLT5zdGFydDsKIAogIyBDcmVhdGUgc29tZSBwcmUt ZXhpc3RpbmcgY29udGVudCBvbiBwdWJsaXNoZXIKQEAgLTY3LDEyICs2NywyNCBAQCAkbm9kZV9z dWJzY3JpYmVyLT5wb2xsX3F1ZXJ5X3VudGlsKCdwb3N0Z3JlcycsICR0d29waGFzZV9xdWVyeSkK ICMgdGhlbiBDT01NSVQgUFJFUEFSRUQKICMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMK IAorIyBTYXZlIHRoZSBsb2cgbG9jYXRpb24sIHRvIHNlZSB0aGUgZmFpbHVyZSBvZiB0aGUgYXBw bGljYXRpb24KK215ICRsb2dfbG9jYXRpb24gPSAtcyAkbm9kZV9zdWJzY3JpYmVyLT5sb2dmaWxl OworCiAkbm9kZV9wdWJsaXNoZXItPnNhZmVfcHNxbCgKIAkncG9zdGdyZXMnLCAiCiAJQkVHSU47 CiAJSU5TRVJUIElOVE8gdGFiX2Z1bGwgVkFMVUVTICgxMSk7CiAJUFJFUEFSRSBUUkFOU0FDVElP TiAndGVzdF9wcmVwYXJlZF90YWJfZnVsbCc7Iik7CiAKKyMgQ29uZmlybSB0aGUgRVJST1IgaXMg cmVwb3J0ZWQgYmVjYXN1ZSBtYXhfcHJlcGFyZWRfdHJhbnNhY3Rpb25zIGlzIHplcm8KKyRub2Rl X3N1YnNjcmliZXItPndhaXRfZm9yX2xvZygKKwlxci9FUlJPUjogKCBbQS1aMC05XSs6KT8gcHJl cGFyZWQgdHJhbnNhY3Rpb25zIGFyZSBkaXNhYmxlZC8pOworCisjIFNldCBtYXhfcHJlcGFyZWRf dHJhbnNhY3Rpb25zIHRvIGNvcnJlY3QgdmFsdWUgdG8gcmVzdW1lIHRoZSByZXBsaWNhdGlvbgor JG5vZGVfc3Vic2NyaWJlci0+YXBwZW5kX2NvbmYoJ3Bvc3RncmVzcWwuY29uZicsCisJcXEobWF4 X3ByZXBhcmVkX3RyYW5zYWN0aW9ucyA9IDEwKSk7Ciskbm9kZV9zdWJzY3JpYmVyLT5yZXN0YXJ0 OworCiAkbm9kZV9wdWJsaXNoZXItPndhaXRfZm9yX2NhdGNodXAoJGFwcG5hbWUpOwogCiAjIGNo ZWNrIHRoYXQgdHJhbnNhY3Rpb24gaXMgaW4gcHJlcGFyZWQgc3RhdGUgb24gc3Vic2NyaWJlcgot LSAKMi40My4wCgo= --_003_TYAPR01MB5692FAC23BE40C69DA8ED4AFF5B92TYAPR01MB5692jpnp_ Content-Type: application/octet-stream; name="test_2pc.sh" Content-Description: test_2pc.sh Content-Disposition: attachment; filename="test_2pc.sh"; size=1610; creation-date="Thu, 08 Aug 2024 05:03:07 GMT"; modification-date="Thu, 08 Aug 2024 05:04:01 GMT" Content-Transfer-Encoding: base64 IyEvYmluL2Jhc2gKCiMgc2V0IC1lCgpwb3J0XzE9NTQzMQpwb3J0XzI9NTQzMgoKZWNobyAnQ2xl YW4gdXAnCgpwZ19jdGwgc3RvcCAtRCBkYXRhX04yCnBnX2N0bCBzdG9wIC1EIGRhdGFfTjEKCnJt IC1yIGRhdGFfKiAqbG9nCgplY2hvICdTZXQgdXAnCgojIFNldHVwIGFuZCBzdGFydCBwdWJsaXNo ZXIKaW5pdGRiIC1EIGRhdGFfTjEgLVUgcG9zdGdyZXMKY2F0IDw8IEVPRiA+PiBkYXRhX04xL3Bv c3RncmVzcWwuY29uZgp3YWxfbGV2ZWwgPSBsb2dpY2FsCnBvcnQgPSAkcG9ydF8xCmxvZ19yZXBs aWNhdGlvbl9jb21tYW5kcyA9IHRydWUKbWF4X3ByZXBhcmVkX3RyYW5zYWN0aW9ucyA9IDEwCkVP RgpwZ19jdGwgLUQgZGF0YV9OMSBzdGFydCAtdyAtbCBOMS5sb2cKCigKICAgIGVjaG8gLWUgIkNS RUFURSBUQUJMRSBmb28gKGEgaW50IFBSSU1BUlkgS0VZKTsiCiAgICBlY2hvIC1lICJDUkVBVEUg VEFCTEUgdmFyIChhIGludCk7IgogICAgZWNobyAtZSAiQ1JFQVRFIFBVQkxJQ0FUSU9OIHB1YiBG T1IgQUxMIFRBQkxFUzsiCikgfCBwc3FsIC1VIHBvc3RncmVzIC1wICRwb3J0XzEKCiMgU2V0dXAg YW5kIHN0YXJ0IHN1YnNjcmliZXIgd2l0aCB0d29fcGhhc2UgPSB0cnVlIGJ1dCBtYXhfcHJlcGFy ZWRfdHJhbnNhY3Rpb25zID0gMAppbml0ZGIgLUQgZGF0YV9OMiAtVSBwb3N0Z3JlcwpjYXQgPDwg RU9GID4+IGRhdGFfTjIvcG9zdGdyZXNxbC5jb25mCnBvcnQgPSAkcG9ydF8yCm1heF9wcmVwYXJl ZF90cmFuc2FjdGlvbnMgPSAwCkVPRgpwZ19jdGwgLUQgZGF0YV9OMiBzdGFydCAtdyAtbCBOMi5s b2cKCigKICAgIGVjaG8gLWUgIkNSRUFURSBUQUJMRSBmb28gKGEgaW50IFBSSU1BUlkgS0VZKTsi CiAgICBlY2hvIC1lICJDUkVBVEUgVEFCTEUgdmFyIChhIGludCk7IgogICAgZWNobyAtZSAiQ1JF QVRFIFNVQlNDUklQVElPTiBzdWIgQ09OTkVDVElPTiAndXNlcj1wb3N0Z3JlcyBwb3J0PSRwb3J0 XzEnIFBVQkxJQ0FUSU9OIHB1YiBXSVRIICh0d29fcGhhc2U9dHJ1ZSwgY29weV9kYXRhPWZhbHNl KTsiCikgfCBwc3FsIC1VIHBvc3RncmVzIC1wICRwb3J0XzIKCiMgUFJFUEFSRSBhIHRyYW5zYWNp dG9uLiBJdCB3aWxsIGZhaWwgb24gdGhlIHN1YnNjcmliZXIgYmVjYXVzZSBtYXhfcHJlcGFyZWRf dHJhbnNhY3Rpb25zIGlzIHplcm8uCiMgTm90ZSB0aGF0IHRoaXMgd2lsbCBiZSByZXBsaWNhdGVk IG9ubHkgb25jZSBiZWNhdXNlIHRoZSByZXBsaWNhdGlvbiBvcmlnaW4gaXMgdXBkYXRlZC4KKAog ICAgZWNobyAtZSAiQkVHSU47IElOU0VSVCBJTlRPIGZvbyBWQUxVRVMgKGdlbmVyYXRlX3Nlcmll cygxLCA1KSk7IFBSRVBBUkUgVFJBTlNBQ1RJT04gJ3R4bjEnOyIKKSB8IHBzcWwgLVUgcG9zdGdy ZXMgLXAgJHBvcnRfMQoKIyBJZiB0aGUgdHJhbnNhY3Rpb24gaXMgY29tbWl0dGVkIG9uIHRoZSBw dWJsaXNoZXIncyBzaWRlLCB0aGUgc3Vic2NyaWJlciB0cmllcwojIHRvIGNvbW1pdCB0aGUgbm9u LWV4aXN0aW5nIHRyYW5zYWN0aW9uIHNvIHRoYXQgdGhlIHJlcGxpY2F0aW9uIHN0b3BzLgojKAoj ICAgIGVjaG8gLWUgIkNPTU1JVCBQUkVQQVJFRCAndHhuMSc7IgojKSB8IHBzcWwgLVUgcG9zdGdy ZXMgLXAgJHBvcnRfMQo= --_003_TYAPR01MB5692FAC23BE40C69DA8ED4AFF5B92TYAPR01MB5692jpnp_--