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 1thtMX-0088nN-FR for pgsql-bugs@arkaria.postgresql.org; Tue, 11 Feb 2025 16:43:53 +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 1thtMW-00CvaY-87 for pgsql-bugs@arkaria.postgresql.org; Tue, 11 Feb 2025 16:43:52 +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 1tht6K-00CePV-O7 for pgsql-bugs@lists.postgresql.org; Tue, 11 Feb 2025 16:27:08 +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 1tht6H-000GB0-2g for pgsql-bugs@lists.postgresql.org; Tue, 11 Feb 2025 16:27:08 +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=i8e3l3ef316/JGhGv4A5nyZj8CCjjN8c4xLRybzv+0k=; b=pn0GZjInY5uLXoNnjLfYIaIFPS hfO+Q2+oyj8UdJNvTXLwVhl6KJBh7lYpDDuo9GWccAz0usGpMdsOjuNOY2hgdLUPcE05DtFBiB7Xh ymiRCQeufy5p5kfmBtVVpZos1zOE1ctKsi/QLtu5MQjE73+0QQlMn37yQJ24yuHpuhPvoVVLgAzrH 7UAdkip3xvcrYCcnrwt/4ZzYARvhfhAvJTD/C2IB3n/j6zT0JgMBGTF6+9tsKAoaFT/G47H4Xcn5P 62ABvHEUXl9HvDbahzFhlSdLmGdEfze0bRm75CbPIv6Dt/URtYOPBo1OvMq0WDYPUJxltvamj9aYi DxV1RdPQ==; 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 1tht6G-001sB7-ON for pgsql-bugs@lists.postgresql.org; Tue, 11 Feb 2025 16:27:04 +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 1tht6E-00194Z-PY for pgsql-bugs@lists.postgresql.org; Tue, 11 Feb 2025 16:27:03 +0000 Content-Type: multipart/mixed; boundary="===============2795896649330964659==" MIME-Version: 1.0 Subject: BUG #18804: LISTEN on channel fails with "could not access status of transaction" To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: voroshen.av@gmail.com Reply-To: voroshen.av@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 11 Feb 2025 16:26:26 +0000 Message-ID: <18804-bccbbde5e77a68c2@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 --===============2795896649330964659== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODgwNApMb2dnZWQgYnk6ICAgICAgICAgIEFuZHJlaSBWYXJhc2hlbgpF bWFpbCBhZGRyZXNzOiAgICAgIHZvcm9zaGVuLmF2QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDE2LjMKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gR05VL0xpbnV4IDEyIChib29rd29y bSkKRGVzY3JpcHRpb246ICAgICAgICAKCkhpIHRoZXJlLCANCg0KSSd2ZSBlbmNvdW50ZXJlZCB0 aGUgZXJyb3Igd2hpbGUgdHJ5aW5nIHRvIHJlZ2lzdGVyIGEgbGlzdGVuZXIgd2l0aCB0aGUKTElT VEVOIGNoYW5uZWxfbmFtZSBzdGF0ZW1lbnQgaW4gbXkgcHJvZHVjdGlvbiBkYXRhYmFzZToNCg0K U1RBVEVNRU5UOiBMSVNURU4gcml2ZXJfbGVhZGVyc2hpcA0KRVJST1I6IGNvdWxkIG5vdCBhY2Nl c3Mgc3RhdHVzIG9mIHRyYW5zYWN0aW9uIDIwNDg4NDE4OTQNCkRFVEFJTDogQ291bGQgbm90IG9w ZW4gZmlsZSAicGdfeGFjdC8wN0ExIjogTm8gc3VjaCBmaWxlIG9yIGRpcmVjdG9yeS4NCg0KVGhh dCBhbHNvIGxlZCB0byBhbiBlcnJvciB3aGVuIGF0dGVtcHRpbmcgdG8gcmVnaXN0ZXIgYSBsaXN0 ZW5lciBmb3IgYW55Cm90aGVyIGNoYW5uZWwgaW4gdGhhdCBkYXRhYmFzZS4NCg0KQWZ0ZXIgc29t ZSBpbnZlc3RpZ2F0aW9uLCBJIGZvdW5kIHRoYXQgc2ltaWxhciBpc3N1ZSBoYXMgYmVlbiByZXBv cnRlZApzZXZlcmFsIHRpbWVzIGFscmVhZHksIGJ1dCBub25lIG9mIHRoZSBpbnZlc3RpZ2F0aW9u cyBjb2NsdWRlZCB3aXRoIGEKc29sdXRpb24gZXhjZXB0IGZvciByZWNvbW1lbmRhdGlvbiB0byBy ZXN0YXJ0IHBvc3RtYXN0ZXIgaW4gb3JkZXIgdG8gY2xlYW4KdXAgdGhlIExJU1RFTi9OT1RJRlkg cXVldWUgKGFzIGZhciBhcyBJIHVuZGVyc3Rvb2QpLiBUaGlzIHdvcmthcm91bmQgd29ya3MsCmJ1 dCB0aGUgcm9vdCBjYXVzZSBvZiB0aGlzIGJlaGF2aW91ciByZW1haW5zIHVuYWRkcmVzc2VkLiBT aW1pbGFyIGJ1ZwpyZXBvcnRzOg0KDQoxLgpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNz YWdlLWlkLzE2OTYxLTI1ZjI5Zjk1YjM2MDRhOGElNDBwb3N0Z3Jlc3FsLm9yZw0KMi4KaHR0cHM6 Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC8xODM5NC1lNzQ1OTI0NTE0ODU3OGIyQHBv c3RncmVzcWwub3JnDQoNCkkgbWFuYWdlZCB0byByZXByb2R1Y2UgdGhlIGlzc3VlIGxvY2FsbHku IA0KDQpQcmUtY29uZGl0aW9uczogDQoNCjEuIHBvc3RncmVzIGlzIGRlcGxveWVkIHVzaW5nIGRv Y2tlci4gaW1hZ2U6Cmh0dHBzOi8vaHViLmRvY2tlci5jb20vbGF5ZXJzL2xpYnJhcnkvcG9zdGdy ZXMvMTYuMy9pbWFnZXMvc2hhMjU2LTFiMjc3ZDBhZjIyNzM1NzdkODU0N2IyOTVlMzgzNGJhYWYw YzA0ZjViM2I4MjM4ODJmNjg2YmFjMjM1MDJjZjcNCg0KMi4gYXV0b3ZhY3V1bSBpcyBkaXNhYmxl ZCAodG8gYXZvaWQgYW55IGF1dG9tYXRpYyBpbnRlcnZlbnRpb24pLCBhbGwgb3RoZXIKcHJvcGVy dGllcyB1c2UgZGVmYXVsdCB2YWx1ZXM6DQoNCj4gY2F0IHBvc3RncmVzLXRlc3QuY29uZiB8IGdy ZXAgJ2F1dG92YWN1dW0gPSBvZmYnDQphdXRvdmFjdXVtID0gb2ZmDQoNCjMuIHRlc3QgdGFibGUg aXMgY3JlYXRlZCBpbiBwb3N0Z3JlcyBkYXRhYmFzZSAodXNlZCBsYXRlciB0byBnZW5lcmF0ZSBh IGhpZ2gKbnVtYmVyIG9mIHVwZGF0ZSB0cmFuc2FjdGlvbnMpOg0KDQpwb3N0Z3Jlcz0jIGNyZWF0 ZSB0YWJsZSB0ZXN0KGlkIGludCk7DQpDUkVBVEUgVEFCTEUNCnBvc3RncmVzPSMgaW5zZXJ0IGlu dG8gdGVzdCB2YWx1ZXMgKDEpOw0KSU5TRVJUIDAgMQ0KDQoNClN0ZXBzIHRvIHJlcHJvZHVjZToN Cg0KMS4gbGlzdGVuIHRvIHRoZSBjaGFubmVsIChiYWNrZW5kIDEpOiANCg0KcG9zdGdyZXM9IyBM SVNURU4gdGVzdF9jaGFuOw0KTElTVEVODQoNCjIuIG5vdGlmeSB0aGUgY2hhbm5lbCAoYmFja2Vu ZCAyKTogDQoNCnBvc3RncmVzPSMgTk9USUZZIHRlc3RfY2hhbjsNCk5PVElGWQ0KcG9zdGdyZXM9 IyBzZWxlY3QgdHhpZF9jdXJyZW50KCk7DQogdHhpZF9jdXJyZW50DQotLS0tLS0tLS0tLS0tLQ0K ICAgICAgICAgIDczNA0KKDEgcm93KQ0KDQozLiByZWNlaXZlIG5vdGlmaWNhdGlvbiAoYmFja2Vu ZCAxKToNCg0KcG9zdGdyZXM9IyBMSVNURU4gdGVzdF9jaGFuOw0KTElTVEVODQpBc3luY2hyb25v dXMgbm90aWZpY2F0aW9uICJ0ZXN0X2NoYW4iIHJlY2VpdmVkIGZyb20gc2VydmVyIHByb2Nlc3Mg d2l0aCBQSUQKODYuDQoNCjQuIGV4ZWN1dGUgYSBzaW1wbGUgdXBkYXRlIGNvbW1hbmQgb24gdGVz dCB0YWJsZSAoZnJvbSB0aGUgcHJlLWNvbmRpdGlvbnMKc2VjdGlvbikgdXNpbmcgcGdiZW5jaCBp biBvcmRlciB0byBnZW5lcmF0ZSBlbm91Z2ggdHJhbnNhY3Rpb25zIHRvIGNyZWF0ZQpwZ194YWN0 LzAwMDEgZmlsZToNCg0KPiBwZ2JlbmNoIC0tdmVyc2lvbiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQpwZ2Jl bmNoIChQb3N0Z3JlU1FMKSAxNi4zIChEZWJpYW4gMTYuMy0xLnBnZGcxMjArMSkNCj4gY2F0IHRl c3Quc3FsDQpVUERBVEUgdGVzdCBTRVQgaWQgPSAxOw0KPiBscyAtbGFoIC92YXIvbGliL3Bvc3Rn cmVzcWwvZGF0YS9wZ194YWN0DQp0b3RhbCAxNksNCmRyd3gtLS0tLS0gIDIgcG9zdGdyZXMgcG9z dGdyZXMgNC4wSyBGZWIgMTEgMTI6NDUgLg0KZHJ3eC0tLS0tLSAxOSBwb3N0Z3JlcyBwb3N0Z3Jl cyA0LjBLIEZlYiAxMSAxMjo0NSAuLg0KLXJ3LS0tLS0tLSAgMSBwb3N0Z3JlcyBwb3N0Z3JlcyA4 LjBLIEZlYiAxMSAxMjo0NSAwMDAwDQo+IGV4cG9ydCBQR1BBU1NXT1JEPXBvc3RncmVzOyBwZ2Jl bmNoIC1oIGxvY2FsaG9zdCAtcCA1NDMyIC1VIHBvc3RncmVzIC1jIDgwCi1qIDEwIC10IDE1MDAw IC1mIHRlc3Quc3FsIHBvc3RncmVzDQoNCihwZ2JlbmNoIGdlbmVyYXRlcyAxXzIwMF8wMDAgdHJh bnNhY3Rpb25zIGluIHRvdGFsLCBhbiBlbXBpcmljYWxseSBmb3VuZApudW1iZXIgdGhhdCBjb21w bGV0ZWx5IGZpbGxzIHBnX3hhY3QvMDAwMCBhbmQgbGVhZHMgdG8gcGdfeGFjdC8wMDAxCmNyZWF0 aW9uKQ0KDQo1LiBmbHVzaCBjaGFuZ2VzIGZyb20gc2hhcmVkIGJ1ZmZlcmVkIHRvIGRpc2sgKGJh Y2tlbmQgMyk6DQoNCnBvc3RncmVzPSMgQ0hFQ0tQT0lOVDsNCkNIRUNLUE9JTlQNCg0KNi4gdmVy aWZ5IHRoYXQgcGdfeGFjdC8wMDAxIGlzIGNyZWF0ZWQ6DQoNCj4gbHMgLWxhaCAvdmFyL2xpYi9w b3N0Z3Jlc3FsL2RhdGEvcGdfeGFjdA0KdG90YWwgMzA0Sw0KZHJ3eC0tLS0tLSAgMiBwb3N0Z3Jl cyBwb3N0Z3JlcyA0LjBLIEZlYiAxMSAxMzowMCAuDQpkcnd4LS0tLS0tIDE5IHBvc3RncmVzIHBv c3RncmVzIDQuMEsgRmViIDExIDEyOjQ1IC4uDQotcnctLS0tLS0tICAxIHBvc3RncmVzIHBvc3Rn cmVzIDI1NksgRmViIDExIDEzOjAwIDAwMDANCi1ydy0tLS0tLS0gIDEgcG9zdGdyZXMgcG9zdGdy ZXMgIDQwSyBGZWIgMTEgMTM6MDAgMDAwMQ0KDQo3LiBleGVjdXRlIFZBQ1VVTSBGUkVFWkUgb24g ZWFjaCBkYXRhYmFzZSBhdCB0aGUgc2VydmVyIHRvIGZyZWV6ZSByb3dzIGFuZApwdXJnZSBwZ194 YWN0LzAwMDAgKGJhY2tlbmQgNCk6DQoNCnBvc3RncmVzPSMgVkFDVVVNIEZSRUVaRTsNClZBQ1VV TQ0KDQpwb3N0Z3Jlcz0jIFxjIHRlbXBsYXRlMQ0KWW91IGFyZSBub3cgY29ubmVjdGVkIHRvIGRh dGFiYXNlICJ0ZW1wbGF0ZTEiIGFzIHVzZXIgInBvc3RncmVzIi4NCnRlbXBsYXRlMT0jIFZBQ1VV TSBGUkVFWkU7DQpWQUNVVU0NCg0KdGVtcGxhdGUxPSMgQUxURVIgREFUQUJBU0UgdGVtcGxhdGUw IFdJVEggQUxMT1dfQ09OTkVDVElPTlMgdHJ1ZTsNCkFMVEVSIERBVEFCQVNFDQp0ZW1wbGF0ZTE9 IyBcYyB0ZW1wbGF0ZTANCllvdSBhcmUgbm93IGNvbm5lY3RlZCB0byBkYXRhYmFzZSAidGVtcGxh dGUwIiBhcyB1c2VyICJwb3N0Z3JlcyIuDQp0ZW1wbGF0ZTA9IyBWQUNVVU0gRlJFRVpFOw0KVkFD VVVNDQoNCnRlbXBsYXRlMD0jIHNlbGVjdCBkYXRuYW1lLCBkYXRmcm96ZW54aWQgZnJvbSBwZ19k YXRhYmFzZTsNCiAgZGF0bmFtZSAgfCBkYXRmcm96ZW54aWQNCi0tLS0tLS0tLS0tKy0tLS0tLS0t LS0tLS0tDQogcG9zdGdyZXMgIHwgICAgICAxMjAwNzM2DQogdGVtcGxhdGUwIHwgICAgICAxMjAw NzM3DQogdGVtcGxhdGUxIHwgICAgICAxMjAwNzM2DQooMyByb3dzKQ0KDQpwb3N0Z3Jlcz0jIFxj IHRlbXBsYXRlMQ0KWW91IGFyZSBub3cgY29ubmVjdGVkIHRvIGRhdGFiYXNlICJ0ZW1wbGF0ZTEi IGFzIHVzZXIgInBvc3RncmVzIi4NCnRlbXBsYXRlMT0jIFZBQ1VVTSBGUkVFWkU7DQpWQUNVVU0N Cg0KOC4gZW5zdXJlIHRoYXQgcGdfeGFjdC8wMDAwIGlzIGdvbmUNCg0KPiBscyAtbGFoIC92YXIv bGliL3Bvc3RncmVzcWwvZGF0YS9wZ194YWN0DQp0b3RhbCA0OEsNCmRyd3gtLS0tLS0gIDIgcG9z dGdyZXMgcG9zdGdyZXMgNC4wSyBGZWIgMTEgMTU6MjMgLg0KZHJ3eC0tLS0tLSAxOSBwb3N0Z3Jl cyBwb3N0Z3JlcyA0LjBLIEZlYiAxMSAxMjo0NSAuLg0KLXJ3LS0tLS0tLSAgMSBwb3N0Z3JlcyBw b3N0Z3JlcyAgNDBLIEZlYiAxMSAxMzowMCAwMDAxDQoNCjkuIHRyeSB0byBsaXN0ZW4gdG8gdGVz dF9jaGFuIChiYWNrZW5kIDUpOg0KDQpwb3N0Z3Jlcz0jIExJU1RFTiB0ZXN0X2NoYW47DQpFUlJP UjogIGNvdWxkIG5vdCBhY2Nlc3Mgc3RhdHVzIG9mIHRyYW5zYWN0aW9uIDczMw0KREVUQUlMOiAg Q291bGQgbm90IG9wZW4gZmlsZSAicGdfeGFjdC8wMDAwIjogTm8gc3VjaCBmaWxlIG9yIGRpcmVj dG9yeS4NCg0KMTAuIGVuc3VyZSB0aGF0IGl0IGlzIGltcG9zc2libGUgdG8gbGlzdGVuIHRvIGFu eSBvdGhlcmNoYW5uZWwgKGJhY2tlbmQKNik6DQoNCnBvc3RncmVzPSMgTElTVEVOIGFub3RoZXJf dGVzdF9jaGFuOw0KRVJST1I6ICBjb3VsZCBub3QgYWNjZXNzIHN0YXR1cyBvZiB0cmFuc2FjdGlv biA3MzMNCkRFVEFJTDogIENvdWxkIG5vdCBvcGVuIGZpbGUgInBnX3hhY3QvMDAwMCI6IE5vIHN1 Y2ggZmlsZSBvciBkaXJlY3RvcnkNCg0KRXhwZWN0ZWQgYmVoYXZpb3VyOiANCg0KSSBzaG91bGQg YmUgYWJsZSB0byBsaXN0ZW4gdG8gYW55IGNoYW5uZWwgaW4gdGhlIGRhdGFiYXNlIGFmdGVyIFN0 ZXAgNw0KDQpOT1RFOg0KDQpJIGhhdmUgdHJpZWQgdGhlIHNhbWUgc3RlcHMgb24gdGhlIGxhdGVz dCBtaW5vciByZWxlYXNlIGZvciBteSBtYWpvciB2ZXJzaW9uCigxNi42LCB0byBiZSBwcmVjaXNl KSBhbmQgdGhlIGlzc3VlIHN0aWxsIHBlcnNpc3RzLgoK --===============2795896649330964659==--