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 1nDSrh-0004sb-P8 for pgsql-bugs@arkaria.postgresql.org; Fri, 28 Jan 2022 15:08:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nDSrg-0006O1-B0 for pgsql-bugs@arkaria.postgresql.org; Fri, 28 Jan 2022 15:08:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nDNEl-0004AN-5K for pgsql-bugs@lists.postgresql.org; Fri, 28 Jan 2022 09:08:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nDNEi-0004eF-Iw for pgsql-bugs@lists.postgresql.org; Fri, 28 Jan 2022 09:08:06 +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=MuyGZRb+ng0sFv/snQn9jnupdTzz+l7/xsw989y7buw=; b=nUK0lAGmE73N7YEtMIORKujJXk wmItZstIr2RME5R3krlxBG2Fhu7pA4NH5OVFBMM78cX8blPFkYkGBbnF843eHcNGUUFday5vqPLRY g75kF6VJqyT4qRostW12sgc69tumI/3Szg7TRoq7HX/nmIvjK8rwZ08YpCP/mXGT1WNsdNY2/SMne LjOzaFucnGBA9+qK4m86UknGUnpRhbdYofQ7o908bXu2t2P7AlE7xpbyDjqDseyITRpaDyV39oDy1 s3Yi4nMO/lLY9KnwPYOXkPJ4ZLX+fz4UUIx/WUhjQ0PQoO7CbRlzpnZr2lYMhHIyfVjjsOjlRDrhW JAxEm8Og==; 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 1nDNEi-0005ob-6B for pgsql-bugs@lists.postgresql.org; Fri, 28 Jan 2022 09:08: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 1nDNEg-00019q-2Q for pgsql-bugs@lists.postgresql.org; Fri, 28 Jan 2022 09:08:02 +0000 Content-Type: multipart/mixed; boundary="===============5287038508190073099==" MIME-Version: 1.0 Subject: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: andrewbille@gmail.com Reply-To: andrewbille@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 28 Jan 2022 09:07:40 +0000 Message-ID: <17385-9ee529fb091f0ce5@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 --===============5287038508190073099== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzM4NQpMb2dnZWQgYnk6ICAgICAgICAgIEFuZHJldyBCaWxsZQpFbWFp bCBhZGRyZXNzOiAgICAgIGFuZHJld2JpbGxlQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE0LjEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRpb246ICAgICAg ICAKCkhpIQ0KDQoiUkVTRVQgdHJhbnNhY3Rpb25faXNvbGF0aW9uIiBpbnNpZGUgc2VyaWFsaXph YmxlIHRyYW5zYWN0aW9uIGNhdXNlcyBBc3NlcnQKYXQgdGhlIHRyYW5zYWN0aW9uIGVuZC4NCkZv ciBleGFtcGxlIChvbiBSRUxfMTBfU1RBQkxFKSB0aGUgZm9sbG93aW5nIHF1ZXJ5Og0KQ1JFQVRF IFRBQkxFIGFiYyAoYSBpbnQpOw0KQkVHSU4gVFJBTlNBQ1RJT04gSVNPTEFUSU9OIExFVkVMIFNF UklBTElaQUJMRTsNCiAgICAgICAgU0VMRUNUICogRlJPTSBhYmM7DQogICAgICAgIFJFU0VUIHRy YW5zYWN0aW9uX2lzb2xhdGlvbjsNCkVORDsNCg0KY2F1c2VzIGFuIGFzc2VydGlvbiBmYWlsdXJl IHdpdGggdGhlIGZvbGxvd2luZyBzdGFjazoNCg0KW05ldyBMV1AgODM5MDE3XQ0KW1RocmVhZCBk ZWJ1Z2dpbmcgdXNpbmcgbGlidGhyZWFkX2RiIGVuYWJsZWRdDQpVc2luZyBob3N0IGxpYnRocmVh ZF9kYiBsaWJyYXJ5ICIvbGliL3g4Nl82NC1saW51eC1nbnUvbGlidGhyZWFkX2RiLnNvLjEiLg0K Q29yZSB3YXMgZ2VuZXJhdGVkIGJ5IGBwb3N0Z3JlczogYW5kcmV3IHJlZ3Jlc3Npb24gW2xvY2Fs XSBDT01NSVQgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAnLg0KUHJvZ3JhbSB0 ZXJtaW5hdGVkIHdpdGggc2lnbmFsIFNJR0FCUlQsIEFib3J0ZWQuDQojMCAgX19HSV9yYWlzZSAo c2lnPXNpZ0BlbnRyeT02KSBhdCAuLi9zeXNkZXBzL3VuaXgvc3lzdi9saW51eC9yYWlzZS5jOjUw DQo1MCAgICAgIC4uL3N5c2RlcHMvdW5peC9zeXN2L2xpbnV4L3JhaXNlLmM6IE5vIHN1Y2ggZmls ZSBvciBkaXJlY3RvcnkuDQooZ2RiKSBidA0KIzAgIF9fR0lfcmFpc2UgKHNpZz1zaWdAZW50cnk9 NikgYXQgLi4vc3lzZGVwcy91bml4L3N5c3YvbGludXgvcmFpc2UuYzo1MA0KIzEgIDB4MDAwMDdm MTRiN2Y1OTg1OSBpbiBfX0dJX2Fib3J0ICgpIGF0IGFib3J0LmM6NzkNCiMyICAweDAwMDA1NTg2 ZGE4MmM0ZDIgaW4gRXhjZXB0aW9uYWxDb25kaXRpb24gKGNvbmRpdGlvbk5hbWU9MHg1NTg2ZGFh MDFlNDIKIklzb2xhdGlvbklzU2VyaWFsaXphYmxlKCkiLCBlcnJvclR5cGU9MHg1NTg2ZGFhMDE5 NWMgIkZhaWxlZEFzc2VydGlvbiIsCmZpbGVOYW1lPTB4NTU4NmRhYTAxOTUwICJwcmVkaWNhdGUu YyIsIGxpbmVOdW1iZXI9NDgzOCkgYXQgYXNzZXJ0LmM6NjkNCiMzICAweDAwMDA1NTg2ZGE2NTli MmYgaW4gUHJlQ29tbWl0X0NoZWNrRm9yU2VyaWFsaXphdGlvbkZhaWx1cmUgKCkgYXQKcHJlZGlj YXRlLmM6NDgzOA0KIzQgIDB4MDAwMDU1ODZkYTIwZjMyZSBpbiBDb21taXRUcmFuc2FjdGlvbiAo KSBhdCB4YWN0LmM6MjE2OA0KIzUgIDB4MDAwMDU1ODZkYTIxMDIwYyBpbiBDb21taXRUcmFuc2Fj dGlvbkNvbW1hbmQgKCkgYXQgeGFjdC5jOjMwMTUNCiM2ICAweDAwMDA1NTg2ZGE2NmFmY2IgaW4g ZmluaXNoX3hhY3RfY29tbWFuZCAoKSBhdCBwb3N0Z3Jlcy5jOjI3MjENCiM3ICAweDAwMDA1NTg2 ZGE2Njg2NDMgaW4gZXhlY19zaW1wbGVfcXVlcnkgKHF1ZXJ5X3N0cmluZz0weDU1ODZkYWRhMTAy MAoiRU5EOyIpIGF0IHBvc3RncmVzLmM6MTIzOQ0KIzggIDB4MDAwMDU1ODZkYTY2ZDRkYiBpbiBQ b3N0Z3Jlc01haW4gKGFyZ2M9MSwgYXJndj0weDdmZmZlZmQxYzA1MCwKZGJuYW1lPTB4NTU4NmRh ZGNjMTY4ICJyZWdyZXNzaW9uIiwgdXNlcm5hbWU9MHg1NTg2ZGFkY2MxNDggImFuZHJldyIpIGF0 CnBvc3RncmVzLmM6NDQ4Ng0KIzkgIDB4MDAwMDU1ODZkYTU5MWJlMyBpbiBCYWNrZW5kUnVuIChw b3J0PTB4NTU4NmRhZGMyMDEwKSBhdApwb3N0bWFzdGVyLmM6NDUzMA0KIzEwIDB4MDAwMDU1ODZk YTU5MTQzZSBpbiBCYWNrZW5kU3RhcnR1cCAocG9ydD0weDU1ODZkYWRjMjAxMCkgYXQKcG9zdG1h c3Rlci5jOjQyNTINCiMxMSAweDAwMDA1NTg2ZGE1OGQyMzMgaW4gU2VydmVyTG9vcCAoKSBhdCBw b3N0bWFzdGVyLmM6MTc0NQ0KIzEyIDB4MDAwMDU1ODZkYTU4Yzk5MCBpbiBQb3N0bWFzdGVyTWFp biAoYXJnYz0zLCBhcmd2PTB4NTU4NmRhZDliMjQwKSBhdApwb3N0bWFzdGVyLmM6MTQxNw0KIzEz IDB4MDAwMDU1ODZkYTQ3YmU5ZCBpbiBtYWluIChhcmdjPTMsIGFyZ3Y9MHg1NTg2ZGFkOWIyNDAp IGF0IG1haW4uYzoyMDkNCg0KUmVwcm9kdWNlZCBvbiBSRUxfMTBfU1RBQkxFLi5tYXN0ZXIuDQpI b3dldmVyIFNFVCB0cmFuc2FjdGlvbl9pc29sYXRpb249J3JlYWQgY29tbWl0dGVkJyBpbnNpZGUg dHJhbnNhY3Rpb24ganVzdAplbWl0cw0KIkVSUk9SOiAgU0VUIFRSQU5TQUNUSU9OIElTT0xBVElP TiBMRVZFTCBtdXN0IGJlIGNhbGxlZCBiZWZvcmUgYW55IHF1ZXJ5Ii4NCg0KUmVnYXJkcywgQW5k cmV3IQoK --===============5287038508190073099==--