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 1m6wLZ-0006fc-Th for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Jul 2021 14:40:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m6wLX-0001pm-T9 for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Jul 2021 14:40:15 +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 1m6w09-0003Oa-PQ for pgsql-bugs@lists.postgresql.org; Fri, 23 Jul 2021 14:18:10 +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 1m6w06-0002zl-6b for pgsql-bugs@lists.postgresql.org; Fri, 23 Jul 2021 14:18: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=UohYekbpBgFtXNDdPpPxzIlPAJ0ISXnS0nc8wuAL6/4=; b=MkXzRavnTl0EO+x6Efgro1yJS0 Q1ZKFUcTXi+Vs3TJoZvnOzx/oSX90SVB+T0qGSVsGYgUwWZcYvNoXKqJCAOfhqqPZLFmQ/pEsiVK2 xbZLGhYuTzqSMLsbFtuMWfaHjiA+Wxj/xR9q1D9QlZRHcsuLca31G7rrsu2YR/dwGhunNwwcGhBXk 1p+nL0YYqTqTD8edo9yiziRt6Dup5pr4AB5/6D6GTPiGIZkQ8w6k46xmZEsB+7WawPr/Avkd6BbaZ HUZJskQNX2CWZXL6EFymVNQrbHzyod3iymVekKYyLkQR86VNq45j0D2Xm3SYL3qsMFaJKUQ4MM+JE aip5Q8nA==; 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 1m6w03-0004WW-R9 for pgsql-bugs@lists.postgresql.org; Fri, 23 Jul 2021 14:18: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 1m6w02-0005jw-Np for pgsql-bugs@lists.postgresql.org; Fri, 23 Jul 2021 14:18:02 +0000 Content-Type: multipart/mixed; boundary="===============6057890240616155338==" MIME-Version: 1.0 Subject: BUG #17122: panic on prepare with subsequent pg_advisory_lock() and pg_advisory_xact_lock_shared() To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: a.pyhalov@postgrespro.ru Reply-To: a.pyhalov@postgrespro.ru, pgsql-bugs@lists.postgresql.org Date: Fri, 23 Jul 2021 14:17:25 +0000 Message-ID: <17122-04f3c32098a62233@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 --===============6057890240616155338== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzEyMgpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBQeWhhbG92 CkVtYWlsIGFkZHJlc3M6ICAgICAgYS5weWhhbG92QHBvc3RncmVzcHJvLnJ1ClBvc3RncmVTUUwg dmVyc2lvbjogMTMuMwpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMC4wNApEZXNjcmlwdGlv bjogICAgICAgIAoKVGhlIGlzc3VlIGlzIHJlcHJvZHVjaWJsZSBhdCBsZWFzdCBvbiAgb24gUEcg MTMuMyBhbmQgMTRiZXRhMg0KDQpta2RpciBkOw0KaW5pdGRiIC1EIGQ7DQoNCkluY3JlYXNlIG1h eF9wcmVwYXJlZF90cmFuc2FjdGlvbnMgaW4gcG9zdGdyZXNxbC5jb25mICAoZm9yIGV4YW1wbGUs IHNldCBpdAp0byAxMCkuDQoNClRoZSBmb2xsb3dpbmcgc3RhdGVtZW50cyBsZWFkIHRvIHBhbmlj Og0KYmVnaW47DQpzZWxlY3QgcGdfYWR2aXNvcnlfbG9jaygxKTsNCnNlbGVjdCBwZ19hZHZpc29y eV94YWN0X2xvY2tfc2hhcmVkKDEpOw0KcHJlcGFyZSB0cmFuc2FjdGlvbiAndGVzdCc7DQoNCjIw MjEtMDctMjMgMTc6MTU6NTkuODY4IE1TSyBbNjE4NTFdIFBBTklDOiAgd2Ugc2VlbSB0byBoYXZl IGRyb3BwZWQgYSBiaXQKc29tZXdoZXJlDQoyMDIxLTA3LTIzIDE3OjE1OjU5Ljg2OCBNU0sgWzYx ODUxXSBTVEFURU1FTlQ6ICBwcmVwYXJlIHRyYW5zYWN0aW9uCid0ZXN0JzsNCg0KKGdkYikgYnQN CiMwICBfX0dJX3JhaXNlIChzaWc9c2lnQGVudHJ5PTYpIGF0IC4uL3N5c2RlcHMvdW5peC9zeXN2 L2xpbnV4L3JhaXNlLmM6NTANCiMxICAweDAwMDA3ZmM3MjkyM2M4NTkgaW4gX19HSV9hYm9ydCAo KSBhdCBhYm9ydC5jOjc5DQojMiAgMHgwMDAwNTVmODBkNGZhY2RkIGluIGVycmZpbmlzaCAoZmls ZW5hbWU9MHg1NWY4MGQ2YjUzYzMgImxvY2suYyIsCmxpbmVubz0zNDY2LCBmdW5jbmFtZT0weDU1 ZjgwZDZiNjIwMCA8X19mdW5jX18uMTM4Mzc+ICJQb3N0UHJlcGFyZV9Mb2NrcyIpCmF0IGVsb2cu Yzo1OTINCiMzICAweDAwMDA1NWY4MGQzNDAxNDMgaW4gUG9zdFByZXBhcmVfTG9ja3MgKHhpZD00 ODUpIGF0IGxvY2suYzozNDY2DQojNCAgMHgwMDAwNTVmODBjZjUwOTQyIGluIFByZXBhcmVUcmFu c2FjdGlvbiAoKSBhdCB4YWN0LmM6MjUxOQ0KIzUgIDB4MDAwMDU1ZjgwY2Y1MTJiOSBpbiBDb21t aXRUcmFuc2FjdGlvbkNvbW1hbmQgKCkgYXQgeGFjdC5jOjMwMzQNCiM2ICAweDAwMDA1NWY4MGQz NWM0ODcgaW4gZmluaXNoX3hhY3RfY29tbWFuZCAoKSBhdCBwb3N0Z3Jlcy5jOjI2NjINCiM3ICAw eDAwMDA1NWY4MGQzNTllZGIgaW4gZXhlY19zaW1wbGVfcXVlcnkgKHF1ZXJ5X3N0cmluZz0weDU1 ZjgwZjA4OTBhMAoicHJlcGFyZSB0cmFuc2FjdGlvbiAndGVzdCc7IikgYXQgcG9zdGdyZXMuYzox MjY0DQojOCAgMHgwMDAwNTVmODBkMzVlNTg3IGluIFBvc3RncmVzTWFpbiAoYXJnYz0xLCBhcmd2 PTB4NTVmODBmMGIzOGIwLApkYm5hbWU9MHg1NWY4MGYwODU2ZDggInBvc3RncmVzIiwgdXNlcm5h bWU9MHg1NWY4MGYwYjM3ZDAgImxlb3JpYyIpIGF0CnBvc3RncmVzLmM6NDMzOQ0KIzkgIDB4MDAw MDU1ZjgwZDI5ZGRmNCBpbiBCYWNrZW5kUnVuIChwb3J0PTB4NTVmODBmMGFiYzIwKSBhdApwb3N0 bWFzdGVyLmM6NDUyNg0KIzEwIDB4MDAwMDU1ZjgwZDI5ZDRmNiBpbiBCYWNrZW5kU3RhcnR1cCAo cG9ydD0weDU1ZjgwZjBhYmMyMCkgYXQKcG9zdG1hc3Rlci5jOjQyMTANCiMxMSAweDAwMDA1NWY4 MGQyOTk3ZWMgaW4gU2VydmVyTG9vcCAoKSBhdCBwb3N0bWFzdGVyLmM6MTczOQ0KIzEyIDB4MDAw MDU1ZjgwZDI5OGY4NSBpbiBQb3N0bWFzdGVyTWFpbiAoYXJnYz0zLCBhcmd2PTB4NTVmODBmMDgz NjUwKSBhdApwb3N0bWFzdGVyLmM6MTQxMg0KIzEzIDB4MDAwMDU1ZjgwZDE5M2RjZCBpbiBtYWlu IChhcmdjPTMsIGFyZ3Y9MHg1NWY4MGYwODM2NTApIGF0IG1haW4uYzoyMTAKCg== --===============6057890240616155338==--