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 1u258D-00CcMR-5e for pgsql-bugs@arkaria.postgresql.org; Tue, 08 Apr 2025 09:20:33 +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 1u258B-007Qqw-Jx for pgsql-bugs@arkaria.postgresql.org; Tue, 08 Apr 2025 09:20: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 1u2375-006nBY-FQ for pgsql-bugs@lists.postgresql.org; Tue, 08 Apr 2025 07:11:16 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u236x-0045CF-0M for pgsql-bugs@lists.postgresql.org; Tue, 08 Apr 2025 07:11:15 +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=qrq010SWO6REreA/snwcP37ELKoZ1gNWrbnM4fxYZ4M=; b=FcqOQ9PVKANrFga4OWptzQYZug ZUF461iMxMCMobdbDt/bd4KuAbXKsCw8QmmTStLWLqH74vqwJnKoxZ/0/72AdFNY5f4s+0fsvRpsH zAUzngLwPqGMG2FyP9Yfrj1grUt5SbwOeHEmZ4V5WGTXMFbxQB/lJOSKkTDQzUwrYRvFlNXQDRqrl GJ/61sQ0vL//BdDtTE8Pfn4iAQxvMtud674mU0kEuzgQb0yrcP3et6JrAU73xXGuFIZDj7V16xWE8 RmURnQdN8QyYiocxh4ParaP/0Rp5TCWTKH5tzB+ziwDuiLs3W7dYGc4s0VhMcAfqN7ekgr7mcQxZd AVgNWZhw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u236u-001rdL-OZ for pgsql-bugs@lists.postgresql.org; Tue, 08 Apr 2025 07:11:05 +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 1u236t-002jzO-6q for pgsql-bugs@lists.postgresql.org; Tue, 08 Apr 2025 07:11:03 +0000 Content-Type: multipart/mixed; boundary="===============6168489708918112973==" MIME-Version: 1.0 Subject: BUG #18882: Unexpected write skew at SERIALIZABLE with psycopg2.connect() To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 2023103793@ruc.edu.cn Reply-To: 2023103793@ruc.edu.cn, pgsql-bugs@lists.postgresql.org Date: Tue, 08 Apr 2025 07:10:11 +0000 Message-ID: <18882-d30fd598ffc3fbb2@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 --===============6168489708918112973== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODg4MgpMb2dnZWQgYnk6ICAgICAgICAgIEh1aWNvbmcgWHUKRW1haWwg YWRkcmVzczogICAgICAyMDIzMTAzNzkzQHJ1Yy5lZHUuY24KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ny4yCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDIyLjA0CkRlc2NyaXB0aW9uOiAgICAgICAg CgpIZWxsby4NCldoZW4gSSB3YXMgdXNpbmcgUHl0aG9uIHRvIGNvbm5lY3QgdG8gdGhlIFBHIGRh dGFiYXNlIGZvciBsYXJnZS1zY2FsZQp0ZXN0aW5nLCBJIG5vdGljZWQgYSBwcm9ibGVtLg0KQXMg dGhlIGV4YW1wbGUgYmVsb3cgZGVtb25zdHJhdGVzLCB0aGlzIGV4YW1wbGUgc2hvdWxkIHJlcG9y dCBhbiBlcnJvciBhdAp0aGUgc2VyaWFsaXphYmxlIGlzb2xhdGlvbiBsZXZlbCBiZWNhdXNlIHRo ZXJlIGlzIGEgY3ljbGUgYmV0d2VlbiB0aGUgdHdvCnRyYW5zYWN0aW9ucy4gSG93ZXZlciwgd2hl biBJIGV4ZWN1dGVkIHRoaXMgc2NyaXB0IGl0IGRpZCBub3QgcmVwb3J0IGFuCmVycm9yLCBidXQg d2hlbiBJIHVzZWQgU1FMIGl0IGRpZC4NCldoYXQgZG8geW91IHRoaW5rIGFib3V0IHRoaXMgbWF0 dGVyPyBUaGFuayB5b3UgdmVyeSBtdWNoIGZvciB5b3VyIGhlbHAuDQoNCi0tLSBJbml0IERhdGFi YXNlDQpDUkVBVEUgVEFCTEUgdEo2bXRvU2wgKElEIElOVCwgVkFMIElOVCwgYzAgUkVBTCAgVU5J UVVFIFBSSU1BUlkgS0VZIE5PVApOVUxMLCBjMSBJTlQgIE5VTEwgLCBjMiBURVhUICk7DQpDUkVB VEUgVEFCTEUgdEVKeWJtcXMgKElEIElOVCwgVkFMIElOVCwgYzAgQk9PTEVBTiAsIGMxIEJPT0xF QU4gLCBjMgpERUNJTUFMKDUwLCAyOCkgKTsNCklOU0VSVCBJTlRPIHRKNm10b1NsIChJRCwgVkFM LCBjMCwgYzEsIGMyKSBWQUxVRVMgKDE0NzEwLCAxNjcyNiwgMzc5NS45NjAxLAo5NTM1LCAnLTYz NjU1NDg5NScpOw0KSU5TRVJUIElOVE8gdEo2bXRvU2wgKElELCBWQUwsIGMwLCBjMSwgYzIpIFZB TFVFUyAoMTQ2OTEsIDE2NzA1LCA0MDkxLjYwMTgsCjEzNTEsICcnKTsNCklOU0VSVCBJTlRPIHRK Nm10b1NsIChJRCwgVkFMLCBjMCwgYzEsIGMyKSBWQUxVRVMgKDE0NzExLCAxNjcyNywgOTY4NS4z MTcyLAoyODI0LCAnPCcpOw0KSU5TRVJUIElOVE8gdEVKeWJtcXMgKElELCBWQUwsIGMwLCBjMSwg YzIpIFZBTFVFUyAoMTQ3MTQsIDE2NzMwLCBUUlVFLApGQUxTRSwgNDA3NC44NDU5KTsNCklOU0VS VCBJTlRPIHRFSnlibXFzIChJRCwgVkFMLCBjMCwgYzEsIGMyKSBWQUxVRVMgKDE0NzE1LCAxNjcz MSwgRkFMU0UsCkZBTFNFLCA3NTkyLjA0MTIpOw0KDQotLS1jYXNlDQpjb25uMSA9IHBzeWNvcGcy LmNvbm5lY3QoKipkYmNvbmZpZykNCmNvbm4yID0gcHN5Y29wZzIuY29ubmVjdCgqKmRiY29uZmln KQ0KY3VyMSA9IGNvbm4xLmN1cnNvcigpDQpjdXIyID0gY29ubjIuY3Vyc29yKCkNCnRyeToNCiAg ICBjdXIxLmV4ZWN1dGUoIlNFVCBTRVNTSU9OIENIQVJBQ1RFUklTVElDUyBBUyBUUkFOU0FDVElP TiBJU09MQVRJT04gTEVWRUwKU0VSSUFMSVpBQkxFOyIpDQogICAgY3VyMS5leGVjdXRlKCJTVEFS VCBUUkFOU0FDVElPTjsiKQ0KDQogICAgY3VyMi5leGVjdXRlKCJTRVQgU0VTU0lPTiBDSEFSQUNU RVJJU1RJQ1MgQVMgVFJBTlNBQ1RJT04gSVNPTEFUSU9OIExFVkVMClNFUklBTElaQUJMRTsiKQ0K ICAgIGN1cjIuZXhlY3V0ZSgiU1RBUlQgVFJBTlNBQ1RJT047IikNCg0KICAgIGN1cjEuZXhlY3V0 ZSgiU0VMRUNUICogRlJPTSB0SjZtdG9TbCBXSEVSRSAoIHRKNm10b1NsLmMxIDwgMTY0NiBBTkQK dEo2bXRvU2wuYzEgPj0gMTA2MSApIEFORCAodEo2bXRvU2wuYzAgPj0gMTAwKSBPUkRFUiBCWSB0 SjZtdG9TbC5JRDsiKQ0KICAgIHByaW50KGN1cjEuZmV0Y2hhbGwoKSkNCg0KICAgIGN1cjIuZXhl Y3V0ZSgiU0VMRUNUICogRlJPTSB0RUp5Ym1xcyBXSEVSRSAoIHRFSnlibXFzLmMxID0gRkFMU0Ug KSBPUkRFUgpCWSB0RUp5Ym1xcy5JRDsiKQ0KICAgIHByaW50KGN1cjIuZmV0Y2hhbGwoKSkNCiAg ICBjdXIyLmV4ZWN1dGUoIlVQREFURSB0SjZtdG9TbCBTRVQgVkFMID0gMTY3MzIgV0hFUkUgKCB0 SjZtdG9TbC5jMSA8IDE2NDYKQU5EIHRKNm10b1NsLmMxID49IDEwNjEgKSBBTkQgKHRKNm10b1Ns LmMwID49IDEwMCk7IikNCiAgICBjdXIyLmV4ZWN1dGUoIkNPTU1JVDsiKQ0KDQogICAgY3VyMS5l eGVjdXRlKCJERUxFVEUgRlJPTSB0RUp5Ym1xcyBXSEVSRSAoIHRFSnlibXFzLmMxID0gRkFMU0Ug KTsiKQ0KICAgIGN1cjEuZXhlY3V0ZSgiQ09NTUlUOyIpDQpleGNlcHQgRXhjZXB0aW9uIGFzIGU6 DQogICAgcHJpbnQoZSkNCmN1cjEuY2xvc2UoKQ0KY3VyMi5jbG9zZSgpDQoNCi0tLSBJIHNlZQ0K WygxNDY5MSwgMTY3MDUsIDQwOTEuNjAxOCwgMTM1MSwgJycpXQ0KWygxNDcxNCwgMTY3MzAsIFRy dWUsIEZhbHNlLCBEZWNpbWFsKCc0MDc0Ljg0NTkwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAnKSks CigxNDcxNSwgMTY3MzEsIEZhbHNlLCBGYWxzZSwgRGVjaW1hbCgnNzU5Mi4wNDEyMDAwMDAwMDAw MDAwMDAwMDAwMDAwMDAwJykpXQoK --===============6168489708918112973==--