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 1r6UQB-00166a-VC for pgsql-bugs@arkaria.postgresql.org; Fri, 24 Nov 2023 11:32:32 +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 1r6UQ9-00A8vl-QE for pgsql-bugs@arkaria.postgresql.org; Fri, 24 Nov 2023 11:32:29 +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 1r6Pgg-008NRh-49 for pgsql-bugs@lists.postgresql.org; Fri, 24 Nov 2023 06:29:14 +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.94.2) (envelope-from ) id 1r6PgY-008F9M-CU for pgsql-bugs@lists.postgresql.org; Fri, 24 Nov 2023 06:29:13 +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=AYG34xFnsv2Z0QvSs/0HtHP1s3CORm1hyzksokAjMwc=; b=nQGG7hFpBbTh+124SAMtL/PXtU jY7VezoJzBi7oglOj/9S0VRmDWNhpu8qvBZMtxE5co7MGxUL5fVDCSvOLLLa/V6qfL5kgXk6xfL1e 7Dg2Oyq8Grj89Z+DDTQig0ZnAZNyjtizoBwta4FsBiL5nJgfJrl1MFaeUtWbKwDQWRCQPL/GYbceN qGqZHyxGugQjk3p3rwsYiD79fdaCWVxqbHjwBd3uiLrrjIRp4wxd3C9Q8UDhHZImhbT7vImKQS1Ne OM597HjaSbC9sBJaHYCyUMwMZqNbsZxwKCX1RH9kjTASlBF1DhLJ+NKyOk10eUTRTLJz1ZZi/EHKv fr9IQLCw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r6PgW-0081S7-7o for pgsql-bugs@lists.postgresql.org; Fri, 24 Nov 2023 06:29: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 1r6PgT-009iIW-K2 for pgsql-bugs@lists.postgresql.org; Fri, 24 Nov 2023 06:29:02 +0000 Content-Type: multipart/mixed; boundary="===============8544663558941822655==" MIME-Version: 1.0 Subject: BUG #18212: Functions txid_status() and pg_xact_status() return invalid status of the specified transaction To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kyzevan23@mail.ru Reply-To: kyzevan23@mail.ru, pgsql-bugs@lists.postgresql.org Date: Fri, 24 Nov 2023 06:28:26 +0000 Message-ID: <18212-547307f8adf57262@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 --===============8544663558941822655== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODIxMgpMb2dnZWQgYnk6ICAgICAgICAgIEVnb3IgQ2hpbmR5YXNraW4K RW1haWwgYWRkcmVzczogICAgICBreXpldmFuMjNAbWFpbC5ydQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE2LjEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjMuMTAKRGVzY3JpcHRpb246ICAgICAg ICAKCkhlbGxvISBSZWNlbnRseSwgTWUgYW5kIEFuZHJldyBCaWxsZSBjYW1lIGFjcm9zcyBhIHNp dHVhdGlvbiB3aGVyZSB0aGUKdHhpZF9zdGF0dXMoKSBhbmQgcGdfeGFjdF9zdGF0dXMoKSBmdW5j dGlvbnMgcmV0dXJuIGludmFsaWQgc3RhdHVzIG9mIHRoZQpzcGVjaWZpZWQgdHJhbnNhY3Rpb24g aWYgeGlkIGlzIHZlcnkgZmFyIGFoZWFkLg0KDQpUaGUgZm9sbG93aW5nIHNjcmlwdCByZXByb2R1 Y2VzIHRoZSBzaXR1YXRpb246DQoNCiMgVGhpcyBzY3JpcHQgdXNlcyBwZ19yZXNldHdhbCBhbmQg ZGQuIFRoaXMgaXMgYSBoYWNrIHRvIG1vdmUgeGlkIGZhcgphaGVhZA0KDQpQR0RBVEE9L3RtcC9w Z3NxbC9kYXRhDQoNCmtpbGxhbGwgcG9zdGdyZXMNCnJtIC1yZiAkUEdEQVRBDQppbml0ZGIgLVUg cG9zdGdyZXMgLWsgLUQgJFBHREFUQQ0KDQpwZ19jdGwgLUQgJFBHREFUQSAtbCBsb2cgc3RhcnQN CnBzcWwgLVUgcG9zdGdyZXMgLWMgIlVQREFURSBwZ19kYXRhYmFzZSBTRVQgZGF0YWxsb3djb25u ID0gJ3QnIFdIRVJFIGRhdG5hbWUKPSAndGVtcGxhdGUwJzsiDQpwZ19jdGwgLUQgJFBHREFUQSAt bCBsb2cgc3RvcA0KIA0KcGdfcmVzZXR3YWwgLXggNTM2ODcwOTExIC1sIDAwMDAwMDAxMDAwMDAw MDAwMDAwMDAwNCAkUEdEQVRBIA0KZGQgaWY9L2Rldi96ZXJvIG9mPSRQR0RBVEEvcGdfeGFjdC8w MUZGIGJzPTgxOTIgY291bnQ9MjA0OCANCg0KcGdfY3RsIC1EICRQR0RBVEEgLWwgbG9nIHN0YXJ0 DQp2YWN1dW1kYiAtLWFsbCAtVSBwb3N0Z3Jlcw0KcGdfY3RsIC1EICRQR0RBVEEgLWwgbG9nIHN0 b3ANCg0KcGdfcmVzZXR3YWwgLXggMTA3Mzc0MTgyMiAtbCAwMDAwMDAwMTAwMDAwMDAwMDAwMDAw MDQgJFBHREFUQSANCmRkIGlmPS9kZXYvemVybyBvZj0kUEdEQVRBL3BnX3hhY3QvMDNGRiBicz04 MTkyIGNvdW50PTIwNDggDQoNCnBnX2N0bCAtRCAkUEdEQVRBIC1sIGxvZyBzdGFydA0KdmFjdXVt ZGIgLS1hbGwgLVUgcG9zdGdyZXMNCnBnX2N0bCAtRCAkUEdEQVRBIC1sIGxvZyBzdG9wDQoNCnBn X3Jlc2V0d2FsIC14IDE2MTA2MTI3MzMgLWwgMDAwMDAwMDEwMDAwMDAwMDAwMDAwMDA0ICRQR0RB VEEgDQpkZCBpZj0vZGV2L3plcm8gb2Y9JFBHREFUQS9wZ194YWN0LzA1RkYgYnM9ODE5MiBjb3Vu dD0yMDQ4IA0KDQpwZ19jdGwgLUQgJFBHREFUQSAtbCBsb2cgc3RhcnQNCnZhY3V1bWRiIC0tYWxs IC1VIHBvc3RncmVzDQpwZ19jdGwgLUQgJFBHREFUQSAtbCBsb2cgc3RvcA0KDQpwZ19yZXNldHdh bCAteCAyMTQ3NDg0MzgyIC1sIDAwMDAwMDAxMDAwMDAwMDAwMDAwMDAwNCAkUEdEQVRBIA0KZGQg aWY9L2Rldi96ZXJvIG9mPSRQR0RBVEEvcGdfeGFjdC8wODAwIGJzPTgxOTIgY291bnQ9MjA0OCAN Cg0KcGdfY3RsIC1EICRQR0RBVEEgLWwgbG9nIHN0YXJ0DQp2YWN1dW1kYiAtLWFsbCAtVSBwb3N0 Z3Jlcw0KDQpwc3FsIC1VIHBvc3RncmVzIC1jICJTRUxFQ1QgdHhpZF9jdXJyZW50KCkiDQpwc3Fs IC1VIHBvc3RncmVzIC1jICJTRUxFQ1QgdHhpZF9zdGF0dXMoMykiIC1jICJTRUxFQ1QKcGdfeGFj dF9zdGF0dXMoJzMnOjp4aWQ4KSINCg0KQXMgYSByZXN1bHQsIHdlIGdldCB0aGF0LCBpbnN0ZWFk IG9mIHRoZSBleHBlY3RlZCBOVUxMLCB0aGUgZnVuY3Rpb25zIHJldHVybgp0aGUgImluIHByb2dy ZXNzIiBzdGF0dXMgb2YgdHJhbnNhY3Rpb24gMywgd2hpY2ggaXMgZmFyIGluIHRoZSBwYXN0Og0K DQouLi4NCiB0eGlkX2N1cnJlbnQgDQotLS0tLS0tLS0tLS0tLQ0KICAgMjE0NzQ4NDM4Mg0KKDEg cm93KQ0KDQogdHhpZF9zdGF0dXMgDQotLS0tLS0tLS0tLS0tDQogaW4gcHJvZ3Jlc3MNCigxIHJv dykNCg0KIHBnX3hhY3Rfc3RhdHVzIA0KLS0tLS0tLS0tLS0tLS0tLQ0KIGluIHByb2dyZXNzDQoo MSByb3cpDQoNCi0tLQ0KQmVzdCByZWdhcmRzLA0KRWdvciBDaGluZHlhc2tpbg0KUG9zdGdyZXMg UHJvZmVzc2lvbmFsOiBodHRwOi8vcG9zdGdyZXNwcm8uY29tCgo= --===============8544663558941822655==--