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 1n8jyY-0003yX-AG for pgsql-bugs@arkaria.postgresql.org; Sat, 15 Jan 2022 14:24:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n8jyV-0004OB-AK for pgsql-bugs@arkaria.postgresql.org; Sat, 15 Jan 2022 14:24:11 +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 1n8dyp-00043i-VO for pgsql-bugs@lists.postgresql.org; Sat, 15 Jan 2022 08:00:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n8dyo-00006A-3k for pgsql-bugs@lists.postgresql.org; Sat, 15 Jan 2022 08:00:07 +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=bQIUaVlLRnnFoCU2x0YGl/zKJPzpAAUKyuwsNMch1So=; b=vWqSAXrq00WDMHHfVlLUtibDIX yb5fGfbBoqOAkzocrOtgUV9PsJmFmFyfsinSLsQl2mdXyafiLaWAWSF04hfl/Ls0z7pKpkvxcO/9t hCU1crW0u/ThTD8xLpzUdhP92p1Lac2rWzQlGrdEZEpHjuJCMyalsGYHAEcix2kG+7MMjRdLwZOOq JuzSvZYnaYYNb07bO+ugFAs5QnA4vfctP1rRtohoD4j/tvt1m+g8zPkfS3BdPOwBVvIIRJJH5Bfl6 I0ANTsjzxwBpiAT+6Vgh1FvCgHORr6yfTR1XRjI/pa1aHAM4zYN4kPfPLSIUzLBQ1f3dvTMtxSuQY bMNFmP7Q==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n8dym-0000Cm-Hb for pgsql-bugs@lists.postgresql.org; Sat, 15 Jan 2022 08:00:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n8dyl-0002bU-7X for pgsql-bugs@lists.postgresql.org; Sat, 15 Jan 2022 08:00:03 +0000 Content-Type: multipart/mixed; boundary="===============1034659965144640056==" MIME-Version: 1.0 Subject: BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 15 Jan 2022 08:00:01 +0000 Message-ID: <17368-98a4f99e8e4b4402@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 --===============1034659965144640056== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzM2OApMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTQuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMC4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGlzb2xhdGlvbiB0ZXN0ICJyZWFkLW9ubHktYW5vbWFseS0zIiBtb2RpZmllZCBh cyBmb2xsb3dzOg0Kc2V0dXANCnsNCglDUkVBVEUgVEFCTEUgYmFua19hY2NvdW50IChpZCBURVhU IFBSSU1BUlkgS0VZLCBiYWxhbmNlIERFQ0lNQUwgTk9UCk5VTEwpOw0KCUlOU0VSVCBJTlRPIGJh bmtfYWNjb3VudCAoaWQsIGJhbGFuY2UpIFZBTFVFUyAoJ1gnLCAwKSwgKCdZJywgMCk7DQp9DQoN CnRlYXJkb3duDQp7DQoJRFJPUCBUQUJMRSBiYW5rX2FjY291bnQ7DQp9DQoNCnNlc3Npb24gczEN CnNldHVwIAkJeyBCRUdJTiBUUkFOU0FDVElPTiBJU09MQVRJT04gTEVWRUwgU0VSSUFMSVpBQkxF OyB9DQpzdGVwIHMxcnkJeyBTRUxFQ1QgYmFsYW5jZSBGUk9NIGJhbmtfYWNjb3VudCBXSEVSRSBp ZCA9ICdZJzsgfQ0Kc3RlcCBzMXd5CXsgVVBEQVRFIGJhbmtfYWNjb3VudCBTRVQgYmFsYW5jZSA9 IDIwIFdIRVJFIGlkID0gJ1knOyB9DQpzdGVwIHMxYyAJeyBDT01NSVQ7IH0NCg0Kc2Vzc2lvbiBz Mg0Kc2V0dXAJCXsgQkVHSU4gVFJBTlNBQ1RJT04gSVNPTEFUSU9OIExFVkVMIFNFUklBTElaQUJM RTsgfQ0Kc3RlcCBzMnJ4CXsgU0VMRUNUIGJhbGFuY2UgRlJPTSBiYW5rX2FjY291bnQgV0hFUkUg aWQgPSAnWCc7IH0NCnN0ZXAgczJyeQl7IFNFTEVDVCBiYWxhbmNlIEZST00gYmFua19hY2NvdW50 IFdIRVJFIGlkID0gJ1knOyB9DQpzdGVwIHMyd3gJeyBVUERBVEUgYmFua19hY2NvdW50IFNFVCBi YWxhbmNlID0gLTExIFdIRVJFIGlkID0gJ1gnOyB9DQpzdGVwIHMyYwl7IENPTU1JVDsgfQ0KDQpz ZXNzaW9uIHMzDQpzZXR1cAkJeyBCRUdJTiBUUkFOU0FDVElPTiBJU09MQVRJT04gTEVWRUwgU0VS SUFMSVpBQkxFIFJFQUQgT05MWQpERUZFUlJBQkxFOyB9DQpzdGVwIHMzcgl7IFNFTEVDVCBpZCwg YmFsYW5jZSBGUk9NIGJhbmtfYWNjb3VudCBXSEVSRSBpZCBJTiAoJ1gnLCAnWScpIE9SREVSCkJZ IGlkOyB9DQpzdGVwIHMzYwl7IENPTU1JVDsgfQ0KDQpzZXNzaW9uIHM0DQpzZXR1cAkJeyBCRUdJ TiBUUkFOU0FDVElPTiBJU09MQVRJT04gTEVWRUwgU0VSSUFMSVpBQkxFOyB9DQpzdGVwIHM0dG8J eyBTRVQgbG9ja190aW1lb3V0ID0gJzEwbXMnIH0NCnN0ZXAgczR3eAl7IFVQREFURSBiYW5rX2Fj Y291bnQgU0VUIGJhbGFuY2UgPSAtMTEgV0hFUkUgaWQgPSAnWCc7IH0NCnN0ZXAgczRjCXsgQ09N TUlUOyB9DQoNCnBlcm11dGF0aW9uIHMycnggczJyeSBzMXJ5IHMxd3kgczFjIHMzciBzMnd4IHMy YyBzM2MNCnBlcm11dGF0aW9uIHMycnkgczF3eSBzMWMgczJ3eCBzNHRvIHM0d3ggczRjIHMzciBz MmMgczNjDQoNCmNhdXNlcyBhbiBhc3NlcnRpb24gZmFpbHVyZSB3aXRoIHRoZSBmb2xsb3dpbmcg c3RhY2t0cmFjZToNCkNvcmUgd2FzIGdlbmVyYXRlZCBieSBgcG9zdGdyZXM6IGxhdyBpc29sYXRp b25fcmVncmVzc2lvbiBbbG9jYWxdIFNFTEVDVCAgICAKICAgICAgICAgICAgICAgICAgICAgICAg Jy4NClByb2dyYW0gdGVybWluYXRlZCB3aXRoIHNpZ25hbCBTSUdBQlJULCBBYm9ydGVkLg0KIzAg IF9fR0lfcmFpc2UgKHNpZz1zaWdAZW50cnk9NikgYXQgLi4vc3lzZGVwcy91bml4L3N5c3YvbGlu dXgvcmFpc2UuYzo1MA0KNTAgICAgICAuLi9zeXNkZXBzL3VuaXgvc3lzdi9saW51eC9yYWlzZS5j OiBObyBzdWNoIGZpbGUgb3IgZGlyZWN0b3J5Lg0KKGdkYikgYnQNCiMwICBfX0dJX3JhaXNlIChz aWc9c2lnQGVudHJ5PTYpIGF0IC4uL3N5c2RlcHMvdW5peC9zeXN2L2xpbnV4L3JhaXNlLmM6NTAN CiMxICAweDAwMDA3ZjUzYThhN2M4NTkgaW4gX19HSV9hYm9ydCAoKSBhdCBhYm9ydC5jOjc5DQoj MiAgMHgwMDAwNTVlZGIxZTg5MzgxIGluIEV4Y2VwdGlvbmFsQ29uZGl0aW9uIChjb25kaXRpb25O YW1lPTB4NTVlZGIyODMyOTgwCiJTeGFjdElzUk9TYWZlKE15U2VyaWFsaXphYmxlWGFjdCkiLCAN CiAgICBlcnJvclR5cGU9MHg1NWVkYjI4MzFkYTAgIkZhaWxlZEFzc2VydGlvbiIsIGZpbGVOYW1l PTB4NTVlZGIyODMxZDYwCiJwcmVkaWNhdGUuYyIsIGxpbmVOdW1iZXI9MTYxMikgYXQgYXNzZXJ0 LmM6NjkNCiMzICAweDAwMDA1NWVkYjE3MTQ0NDIgaW4gR2V0U2FmZVNuYXBzaG90IChvcmlnU25h cHNob3Q9MHg1NWVkYjZhYzZlNDAKPEN1cnJlbnRTbmFwc2hvdERhdGE+KSBhdCBwcmVkaWNhdGUu YzoxNjEyDQojNCAgMHgwMDAwNTVlZGIxNzE0YjkxIGluIEdldFNlcmlhbGl6YWJsZVRyYW5zYWN0 aW9uU25hcHNob3QKKHNuYXBzaG90PTB4NTVlZGI2YWM2ZTQwIDxDdXJyZW50U25hcHNob3REYXRh PikNCiAgICBhdCBwcmVkaWNhdGUuYzoxNzAzDQojNSAgMHgwMDAwNTVlZGIyMDFkNjIzIGluIEdl dFRyYW5zYWN0aW9uU25hcHNob3QgKCkgYXQgc25hcG1nci5jOjI5MQ0KIzYgIDB4MDAwMDU1ZWRi MTc2MTNiNSBpbiBleGVjX3NpbXBsZV9xdWVyeSAoDQogICAgcXVlcnlfc3RyaW5nPTB4NjI1MDAw MDA1MjIwICJTRUxFQ1QgaWQsIGJhbGFuY2UgRlJPTSBiYW5rX2FjY291bnQgV0hFUkUKaWQgSU4g KCdYJywgJ1knKSBPUkRFUiBCWSBpZDsiKQ0KICAgIGF0IHBvc3RncmVzLmM6MTEwMw0KIzcgIDB4 MDAwMDU1ZWRiMTc2ZWEyZSBpbiBQb3N0Z3Jlc01haW4gKGFyZ2M9MSwgYXJndj0weDdmZmRmYTcy OTBkMCwKZGJuYW1lPTxvcHRpbWl6ZWQgb3V0PiwgDQogICAgdXNlcm5hbWU9MHg2MjkwMDAwMTEy NTggImxhdyIpIGF0IHBvc3RncmVzLmM6NDQ4Ng0KIzggIDB4MDAwMDU1ZWRiMTNlYTk1MSBpbiBC YWNrZW5kUnVuIChwb3J0PTB4NjE1MDAwMDA0OTAwKSBhdApwb3N0bWFzdGVyLmM6NDUzMA0KIzkg IDB4MDAwMDU1ZWRiMTNlOTE0MiBpbiBCYWNrZW5kU3RhcnR1cCAocG9ydD0weDYxNTAwMDAwNDkw MCkgYXQKcG9zdG1hc3Rlci5jOjQyNTINCiMxMCAweDAwMDA1NWVkYjEzZGYwYTMgaW4gU2VydmVy TG9vcCAoKSBhdCBwb3N0bWFzdGVyLmM6MTc0NQ0KIzExIDB4MDAwMDU1ZWRiMTNkY2YyMCBpbiBQ b3N0bWFzdGVyTWFpbiAoYXJnYz04LCBhcmd2PTB4NjA3MDAwMDAwMTcwKSBhdApwb3N0bWFzdGVy LmM6MTQxNw0KIzEyIDB4MDAwMDU1ZWRiMGYwNzVjMyBpbiBtYWluIChhcmdjPTgsIGFyZ3Y9MHg2 MDcwMDAwMDAxNzApIGF0IG1haW4uYzoyMDkKCg== --===============1034659965144640056==--