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 1r6URn-0016D4-1k for pgsql-bugs@arkaria.postgresql.org; Fri, 24 Nov 2023 11:34:11 +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 1r6URl-00AABE-Iv for pgsql-bugs@arkaria.postgresql.org; Fri, 24 Nov 2023 11:34:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r6RfW-0096t5-J0 for pgsql-bugs@lists.postgresql.org; Fri, 24 Nov 2023 08:36:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r6RfU-0076x7-0X for pgsql-bugs@lists.postgresql.org; Fri, 24 Nov 2023 08:36:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=4s2gmebYL0zpm4VcDUc54IeN6xKje7Fi0AoE8z5xAfs=; b=UgCOQxRiJ6jdjI713cMDPMZiws cIq0+AhH5e9SMf6RDqVkjTd2YbXYBnQfEy8s6U5/olEOxfR5vzCoZIllpeTGiV0xEc4xOeQLzeQtR BN5DNufNam/VJFj78fIlNVJ2ee8MIdPtmAchlgmbRLfSIV5xgRBL4uIlsQY71oPn5KdsSDW10GDdq ESxEm8PJRLx1CDgen9GNTPxhmxCilkYBVz6QqlTYTTgZLDBNwaind6f3+Kz7C4vyrrAej6XjTmAt9 6UzZ2gofYdj7D+4zVktA/Ucfhohvd+kTSQyun+LgBAEiFEijE7Ocz1/jwbVN2jjN400yWSPwEwwee IBFih01w==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r6RfR-0084aT-Ny for pgsql-bugs@lists.postgresql.org; Fri, 24 Nov 2023 08:36:07 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r6RfN-009lxW-MV for pgsql-bugs@lists.postgresql.org; Fri, 24 Nov 2023 08:36:02 +0000 Content-Type: multipart/mixed; boundary="===============1496589789495989786==" MIME-Version: 1.0 Subject: BUG #18213: Standby's repeatable read isolation level transaction encountered a "nonrepeatable read" problem To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: feichanghong@qq.com Reply-To: feichanghong@qq.com, pgsql-bugs@lists.postgresql.org Date: Fri, 24 Nov 2023 08:35:08 +0000 Message-ID: <18213-dbcf8d67b0e687f5@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1496589789495989786== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODIxMwpMb2dnZWQgYnk6ICAgICAgICAgIEZlaSBDaGFuZ2hvbmcKRW1h aWwgYWRkcmVzczogICAgICBmZWljaGFuZ2hvbmdAcXEuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTYuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIE9wZXJhdGluZyBzeXN0ZW06IGNlbnRvcyA3LEtlcm5l bCB2ZXJzaW9uOiA1LjEwLjEzCkRlc2NyaXB0aW9uOiAgICAgICAgCgpXZSBmb3VuZCB0aGF0IHRy YW5zYWN0aW9ucyB3aXRoIHJlcGVhdGFibGUgcmVhZCBpc29sYXRpb24gbGV2ZWwgb24gU3RhbmRi eQpoYXZlIGEgIm5vbnJlcGVhdGFibGUgcmVhZCIgcHJvYmxlbSwgdGhhdCBpcywgdGhlIHJlc3Vs dHMgb2YgdHdvIHNlbGVjdCBhcmUKZGlmZmVyZW50LCBhbmQgdGhlIGhvdF9zdGFuZGJ5X2ZlZWRi YWNrIGd1YyBoYXMgYmVlbiBzZXQgdG8gb24uIFRoaXMgcHJvYmxlbQpvY2N1cnMgd2hlbiAiY3Jl YXRlIGluZGV4IGNvbmN1cnJlbnRseSIgaXMgZXhlY3V0ZWQgb24gUlcsIGFuZCBjYW4gYmUKcmVw cm9kdWNlZCB0aHJvdWdoIHRoZSBmb2xsb3dpbmcgc3RlcHM6DQpSVyBpbml0aWFsaXphdGlvbiBk YXRhOg0KYGBgDQpjcmVhdGUgdGFibGUgdChhIGludCwgYiBpbnQsIGMgY2hhcigxMDI0KSk7DQpj cmVhdGUgaW5kZXggb24gdChiKTsNCmluc2VydCBpbnRvIHQgc2VsZWN0IGksIGksIGkgZnJvbSBn ZW5lcmF0ZV9zZXJpZXMoMSwgNilpOw0KYGBgDQpTdGFydCBhIHJlcGVhdGFibGUgcmVhZCB0cmFu c2FjdGlvbiBvbiBTdGFuZGJ5Og0KYGBgDQpCRUdJTiBUUkFOU0FDVElPTiBJU09MQVRJT04gTEVW RUwgUkVQRUFUQUJMRSBSRUFEOw0Kc2VsZWN0IHR4aWRfY3VycmVudF9zbmFwc2hvdCgpOw0Kc2Vs ZWN0IGEsIGIgZnJvbSB0IHdoZXJlIGEgPSA1Ow0KYGBgDQpSVyBleGVjdXRlIHVwZGF0ZSBhbmQg Y3JlYXRlIGluZGV4IGNvbmN1cnJlbnRseToNCmBgYA0KdXBkYXRlIHQgc2V0IGIgPSAtMSB3aGVy ZSBhID0gNTsNCmNyZWF0ZSBpbmRleCBDT05DVVJSRU5UTFkgdDFfaWR4X2J0cmVlX2lkIG9uIHQo YSk7DQpgYGANClN0YW5kYnkgZXhlY3V0ZXMgc2VsZWN0IGFnYWluIChzdGlsbCB3aXRoaW4gdGhl IGV4aXN0aW5nIHJlcGVhdGFibGUgcmVhZAp0cmFuc2FjdGlvbikuIFdlIGV4cGVjdCB0aGF0IHRo ZSByZXN1bHRzIG9mIHRoZSB0d28gc2VsZWN0IHNob3VsZCBiZSB0aGUKc2FtZSwgYnV0IHRoZSBz ZWNvbmQgc2VsZWN0IGRpZCBub3QgZ2V0IGFueSBkYXRhLg0KYGBgDQpwb3N0Z3Jlcz0qIyBzZWxl Y3QgYSwgYiBmcm9tIHQgd2hlcmUgYSA9IDU7DQogIGEgfCBiDQotLS0rLS0tDQogIDUgfCA1DQoo MSByb3cpDQoNCnBvc3RncmVzPSojIHNldCBlbmFibGVfc2Vxc2NhbiB0byBvZmY7DQpTRVQNCnBv c3RncmVzPSojIHNlbGVjdCBhLCBiIGZyb20gdCB3aGVyZSBhID0gNTsNCiAgYSB8IGINCi0tLSst LS0NCigwIHJvd3MpDQpgYGANCg0KVGhlIGVudmlyb25tZW50IGluIHdoaWNoIHRoZSBwcm9ibGVt IG9jY3VyczoNCk9wZXJhdGluZyBzeXN0ZW06IGNlbnRvcyA3DQpLZXJuZWwgdmVyc2lvbjogNS4x MC4xMzQNClBvc3RncmVTUUwgY29kZSBicmFuY2gvY29tbWl0OgptYXN0ZXIvZDA1M2E4NzliYjM2 MGZiNzJjNDZkZTJhMDEzZTc0MWQzZjdjOWU4ZA0KQ2xpZW50OiBwc3FsDQoNCldlIGhhdmUgYWxz byBhbmFseXplZCB0aGUgY2F1c2VzIG9mIHRoaXMgcHJvYmxlbSwgYXMgZm9sbG93czoNCjEuIFJX IHVzZXMgYW4gTVZDQyBzbmFwc2hvdCB3aGVuIGV4ZWN1dGluZyAiY3JlYXRlIGluZGV4IGNvbmN1 cnJlbnRseSIsIHNvCnRoZSB1cGRhdGVkIG9sZCB0dXBsZSBjYW5ub3QgYmUgYWNjZXNzZWQgdGhy b3VnaCB0aGUgaW5kZXggaWYgdGhlIHVwZGF0ZSBpcwpub3QgYSBIT1QuDQoyLiBSVyBkaWQgbm90 IGNvbnNpZGVyIHRoZSBvbGRlc3QgeG1pbiBvZiB0aGUgc25hcHNob3Qgb24gU3RhbmRieSB3aGVu CmNyZWF0aW5nIHRoZSBpbmRleCBjb25jdXJyZW50bHkuDQozLiBFdmVuIGluIGEgcmVwZWF0YWJs ZSByZWFkIHRyYW5zYWN0aW9uLCBjYXRsb2cgc25hcHNob3Qgd2lsbCBnZXQgbmV3IG9uZSwKc28g dGhlIHR1cGxlICg1LCA1KSBjYW5ub3QgYmUgYWNjZXNzZWQgd2hlbiBzZWxlY3RpbmcgdGhyb3Vn aCB0aGUgbmV3bHkKY3JlYXRlZCBpbmRleCwgYnV0IHNlcXNjYW4gY2FuIHN0aWxsIGFjY2VzcyBp dC4NCg0KV2UgaGF2ZSBzZXZlcmFsIGlkZWFzIHRvIGZpeCB0aGlzIHByb2JsZW0sIGJ1dCB0aGV5 IGFsbCBoYXZlIG9idmlvdXMKZmxhd3M6DQoxLiBJbiB0aGUgV2FpdEZvck9sZGVyU25hcHNob3Rz IGZ1bmN0aW9uIGluIHRoZSBmaW5hbCBzdGFnZSBvZiAiY3JlYXRlIGluZGV4CmNvbmN1cnJlbnRs eSIsIHdhaXQgZm9yIHJlcGxpY2F0aW9uX3Nsb3RfeG1pbiB0byBleGNlZWQgbGltaXRYbWluLiBJ biB0aGlzCnNvbHV0aW9uLCB3aGVuIHRoZXJlIGFyZSBsb25nIHRyYW5zYWN0aW9ucyBvbiBTdGFu ZGJ5LCAiY3JlYXRlIGluZGV4CmNvbmN1cnJlbnRseSIgb3BlcmF0aW9ucyBtYXkgYmUgYmxvY2tl ZC4NCjIuIFdoZW4gc2VsZWN0aW5nIGFuIGluZGV4IHBhdGggaW4gU3RhbmRieSwgc25hcHNob3Qt PnhtaW4gbXVzdCBiZSBncmVhdGVyCnRoYW4gdGhlIHRyYW5zYWN0aW9uIElEIHRoYXQgY3JlYXRl cyB0aGUgaW5kZXguIFRoaXMgc29sdXRpb24gd2lsbCBtYWtlIHRoZQppbnZhbGlkYXRlIG9mIHRo ZSBwbGFuY2FjaGUgdmVyeSBjb21wbGljYXRlZCwgb3RoZXJ3aXNlIHRoZSBwcm9jZXNzIHdpbGwg bm90CmJlIGFibGUgdG8gdXNlIHRoZSBuZXdseSBjcmVhdGVkIGluZGV4IGluIHRoZSBmdXR1cmUu DQozLiBDb25zaWRlciByZXBsaWNhdGlvbl9zbG90X3htaW4gd2hlbiBjcmVhdGluZyBzbmFwc2hv dHMgZm9yIHNjYW5pbmcgdGhlCmhlYXAgdGFibGUsIGFuZCBhZGQgYWxsIHRoZSB0dXBsZSB0aGF0 IFN0YW5kYnkgbWF5IGFjY2VzcyB0byB0aGUgaW5kZXguIFRoaXMKc29sdXRpb24gaXMgcmVsYXRp dmVseSBoYWNreSBhbmQgd2lsbCBpbmNyZWFzZSB0aGUgc3BhY2Ugb2NjdXBpZWQgYnkgdGhlCmlu ZGV4LgoK --===============1496589789495989786==--