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 1qRNat-001UMF-U8 for pgsql-bugs@arkaria.postgresql.org; Thu, 03 Aug 2023 01:57:40 +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 1qRNZu-009AET-1K for pgsql-bugs@arkaria.postgresql.org; Thu, 03 Aug 2023 01:56:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qRN9K-0092mV-Lr for pgsql-bugs@lists.postgresql.org; Thu, 03 Aug 2023 01:29:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qRN9F-000EAM-Ez for pgsql-bugs@lists.postgresql.org; Thu, 03 Aug 2023 01:29: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=JqOKYBKyzw6YfGFC55o0vm7G4Ox9VkiTxV2pDYd9Sow=; b=TK/B/xZW3/BmgObOPgJ828CybW ogU4RGga37anBiVuuGTXCZW3uiNxtJhFbVrRqw8Pu9/nvtyi7LlBk/EZSVgsqDNylNfxlOnDCK8mo 7fzBLivyTTHN4N0BTIb+FRfcUdcYHmJlxviqPGciQbwcwAwRQfORhKwYOROwRqwmQZwdrVso1xM/H wRXhuRGvmOG1cw5h0aX5Qsyn2LQmLPZhrb6G3LBwLhavPcKfRK+q0nn/kYef1pEJVA4swuBNc1JvC 6NN92ZPfD6KXbRxDFxFD1yiMVJ+fv5dAVVyk9yFQmAC6swzTCuCV+xGvyCD3ykRJ1o6GixbX8xxif W7ePXSsA==; 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 1qRN9E-0008SL-NI for pgsql-bugs@lists.postgresql.org; Thu, 03 Aug 2023 01: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 1qRN9C-000idT-PQ for pgsql-bugs@lists.postgresql.org; Thu, 03 Aug 2023 01:29:02 +0000 Content-Type: multipart/mixed; boundary="===============2566401847649606345==" MIME-Version: 1.0 Subject: BUG #18047: ODBC to PG long transaction causes PANIC To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: justin@tocci.org Reply-To: justin@tocci.org, pgsql-bugs@lists.postgresql.org Date: Thu, 03 Aug 2023 01:28:45 +0000 Message-ID: <18047-02a64967c9174466@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 --===============2566401847649606345== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODA0NwpMb2dnZWQgYnk6ICAgICAgICAgIEp1c3RpbiBUb2NjaQpFbWFp bCBhZGRyZXNzOiAgICAgIGp1c3RpbkB0b2NjaS5vcmcKUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNS4z Ck9wZXJhdGluZyBzeXN0ZW06ICAgRnJlZUJTRApEZXNjcmlwdGlvbjogICAgICAgIAoKb24gdGhl IHNlcnZlcjoNCmV2ZXJ5dGhpbmcgZ29pbmcgbmljZWx5Og0KQXVnICAyIDE5OjQxOjEyIGJ2YyBw b3N0Z3Jlc1syMDI3Nl06IFs3LTI0XQ0KQXVnICAyIDE5OjQxOjEyIGJ2YyBwb3N0Z3Jlc1syMDI3 Nl06IFs3LTI1XQ0KQXVnICAyIDE5OjQxOjEyIGJ2YyBwb3N0Z3Jlc1syMDI3Nl06IFs3LTI2XQ0K VGhlbiB0aGUgc2VydmVyIGNyYXNoZXMuLi4uDQpBdWcgIDIgMTk6NDE6MTIgYnZjIGVudmVsb3Bl LmV4ZVs0NzgzMV06IEZJTEU6CmNvbW1vbl93ZWJzb2NrZXQuYzo0MDg6V1Nfc2VuZEZyYW1lX3N0 ZXAyKCkgRVJST1IgID09PSBDRVJSOiAzNSAoUmVzb3VyY2UKdGVtcG9yYXJpbHkgdW5hdmFpbGFi bGUpID09PSB3cml0ZSgpIGZhaWxlZA0KLi4uDQpBdWcgIDIgMTk6NDE6MTIgYnZjIGVudmVsb3Bl LmV4ZVs0NzgzMV06IEZJTEU6CmNvbW1vbl93ZWJzb2NrZXQuYzo0MzU6V1Nfc2VuZEZyYW1lX3N0 ZXAyKCkgRVJST1IgID09PSBDRVJSOiAzNSAoUmVzb3VyY2UKdGVtcG9yYXJpbHkgdW5hdmFpbGFi bGUpID09PSBzaG91bGQgbmV2ZXIgZ2V0IHRvIEVBR0FJTiB3aXRoIGxpYmV2DQpBdWcgIDIgMTk6 NDE6MTIgYnZjIHBvc3RncmVzWzEwMTYxXTogWzUtMV0gMjAyMy0wOC0wMiAxOTo0MToxMi41MDIg Q0RUClsxMDE2MV0gUEFOSUM6ICBjb3VsZCBub3Qgb3BlbiBmaWxlICJwZ193YWwvMDAwMDAwMDEw MDAwMDAwMDAwMDAwMDA2IjogTm8Kc3VjaCBmaWxlIG9yIGRpcmVjdG9yeQ0KQXVnICAyIDE5OjQx OjEyIGJ2YyBlbnZlbG9wZS5leGVbNDc4MzFdOiBGSUxFOgpjb21tb25fY2xpZW50LmM6MzI2OmNs aWVudF9ub3RpZnlfY2IoKSBFUlJPUiAgPT09IExvc3QgcG9zdGdyZXNxbApjb25uZWN0aW9uOiBz ZXJ2ZXIgY2xvc2VkIHRoZSBjb25uZWN0aW9uIHVuZXhwZWN0ZWRseSAgICBUaGlzIHByb2JhYmx5 IG1lYW5zCnRoZSBzZXJ2ZXIgdGVybWluYXRlZCBhYm5vcm1hbGx5ICAgIGJlZm9yZSBvciB3aGls ZSBwcm9jZXNzaW5nIHRoZQpyZXF1ZXN0Lg0KQXVnICAyIDE5OjQxOjEyIGJ2YyBzeXNsb2dkOiBs YXN0IG1lc3NhZ2UgcmVwZWF0ZWQgMyB0aW1lcw0KQXVnICAyIDE5OjQxOjEyIGJ2YyBwb3N0Z3Jl c1sxMzA0OV06IFs3LTFdIDIwMjMtMDgtMDIgMTk6NDE6MTIuNjI3IENEVApbMTMwNDldIEZBVEFM OiAgdGhlIGRhdGFiYXNlIHN5c3RlbSBpcyBpbiByZWNvdmVyeSBtb2RlDQoNCm9rLCB3ZSBnb3Qg dG8gcmVjb3ZlcnkgbW9kZS4uLg0KDQpBdWcgIDIgMTk6NDE6MTIgYnZjIGVudmVsb3BlLmV4ZVs0 NzgzMV06IEZJTEU6CmNvbW1vbl9jbGllbnQuYzoyNDE6Y254bl9yZXNldF9jYigpIEVSUk9SICA9 PT0gQ29ubmVjdCBmYWlsZWQ6IGNvbm5lY3Rpb24gdG8Kc2VydmVyIG9uIHNvY2tldCAiL3RtcC8u cy5QR1NRTC41NDM0IiBmYWlsZWQ6IEZBVEFMOiAgdGhlIGRhdGFiYXNlIHN5c3RlbSBpcwppbiBy ZWNvdmVyeSBtb2RlDQpBdWcgIDIgMTk6NDE6MTIgYnZjIHBvc3RncmVzWzEzNTY4XTogWzctMV0g MjAyMy0wOC0wMiAxOTo0MToxMi42MjggQ0RUClsxMzU2OF0gRkFUQUw6ICB0aGUgZGF0YWJhc2Ug c3lzdGVtIGlzIGluIHJlY292ZXJ5IG1vZGUNCkF1ZyAgMiAxOTo0MToxMiBidmMgcG9zdGdyZXNb MTM2MjNdOiBbNy0xXSAyMDIzLTA4LTAyIDE5OjQxOjEyLjYyOCBDRFQKWzEzNjIzXSBGQVRBTDog IHRoZSBkYXRhYmFzZSBzeXN0ZW0gaXMgaW4gcmVjb3ZlcnkgbW9kZQ0KQXVnICAyIDE5OjQxOjEy IGJ2YyBlbnZlbG9wZS5leGVbNDc4MzFdOiBGSUxFOgpjb21tb25fY2xpZW50LmM6MjQxOmNueG5f cmVzZXRfY2IoKSBFUlJPUiAgPT09IENvbm5lY3QgZmFpbGVkOiBjb25uZWN0aW9uIHRvCnNlcnZl ciBvbiBzb2NrZXQgIi90bXAvLnMuUEdTUUwuNTQzNCIgZmFpbGVkOiBGQVRBTDogIHRoZSBkYXRh YmFzZSBzeXN0ZW0gaXMKaW4gcmVjb3ZlcnkgbW9kZQ0KQXVnICAyIDE5OjQxOjEyIGJ2YyBzeXNs b2dkOiBsYXN0IG1lc3NhZ2UgcmVwZWF0ZWQgMSB0aW1lcw0KQXVnICAyIDE5OjQxOjEyIGJ2YyBw b3N0Z3Jlc1sxNTQ5Ml06IFs4LTFdIDIwMjMtMDgtMDIgMTk6NDE6MTIuNjM4IENEVApbMTU0OTJd IEZBVEFMOiAgdGhlIGRhdGFiYXNlIHN5c3RlbSBpcyBpbiByZWNvdmVyeSBtb2RlDQpBdWcgIDIg MTk6NDE6MTIgYnZjIGVudmVsb3BlLmV4ZVs0NzgzMV06IEZJTEU6CmNvbW1vbl9jbGllbnQuYzoy NDE6Y254bl9yZXNldF9jYigpIEVSUk9SICA9PT0gQ29ubmVjdCBmYWlsZWQ6IGNvbm5lY3Rpb24g dG8Kc2VydmVyIG9uIHNvY2tldCAiL3RtcC8ucy5QR1NRTC41NDM0IiBmYWlsZWQ6IEZBVEFMOiAg dGhlIGRhdGFiYXNlIHN5c3RlbSBpcwppbiByZWNvdmVyeSBtb2RlDQpBdWcgIDIgMTk6NDE6MTIg YnZjIHBvc3RncmVzWzE0MDMyXTogWzE1LTFdIDIwMjMtMDgtMDIgMTk6NDE6MTIuODM4IENEVApb MTQwMzJdIFBBTklDOiAgY291bGQgbm90IG9wZW4gZmlsZSAicGdfd2FsLzAwMDAwMDAxMDAwMDAw MDAwMDAwMDAwNiI6IE5vCnN1Y2ggZmlsZSBvciBkaXJlY3RvcnkNCg0Kb2ggbm8hIGEgUEFOSUMh IGFwcGFyZW50bHkgd2UgY291bGQgbm90IHJlY292ZXIuDQoNCmZyb20gdGhlIGNsaWVudCBpIGdl dCBub3RoaW5nIHVzZWZ1bDoNCkZBVEFMDQpjb21tb25fY2xpZW50LmM6Y254bl9jYjogRkFUQUwN CmNvbW1vbl9jbGllbnQuYzpjbGllbnRfbm90aWZ5X2NiOiBQUXJlc2V0U3RhcnQgZmFpbGVkDQpj YW5ub3Qgc3RhcnQgY29ubmVjdDogY29ubmVjdGlvbiB0byBzZXJ2ZXIgb24gc29ja2V0ICIvdG1w Ly5zLlBHU1FMLjU0MzQiCmZhaWxlZDogTm8gc3VjaCBmaWxlIG9yIGRpcmVjdG9yeQ0KCUlzIHRo ZSBzZXJ2ZXIgcnVubmluZyBsb2NhbGx5IGFuZCBhY2NlcHRpbmcgY29ubmVjdGlvbnMgb24gdGhh dCBzb2NrZXQ/DQpsYXN0IG1lc3NhZ2UgcmVwZWF0ZWQgMSB0aW1lcw0KDQpxdWlja2VzdCB3YXkg dG8gcmVjb3ZlciBpcyB0byBzdSAtIHBvc3RncmVzOg0KcGdfcmVzZXR3YWwgLWYgL29wdC9lbnYu ZC81NDM0L2RhdGENCmV4aXQNCnNlcnZpY2UgcG9zdGdyZXNxbCByZXN0YXJ0IDU0MzQNCg0KYW5k IHdlIGFyZSBiYWNrIGluIGJ1c2luZXNzLg0KDQpJIHN1c3BlY3QgYW55IGxvbmcgc2NyaXB0IHdp bGwgYmUgYSBwcm9ibGVtIGJ1dCBJIGhhcHBlbiB0byBoYXZlIHRoZSBzY2hlbWEKdGhhdCBjcmFz aGVzIHRoZSBzZXJ2ZXIgZm9yIG1lLiBJdCdzIGhlcmU6IGh0dHBzOi8vcGFzdGViaW4uY29tL0dy Nmd2UEhhIApidXQgaXQgaXMgbG9uZy4gaXQncyBhIHNhZ2UgMTAwIHRhYmxlIHNjaGVtYS4gSSB3 b3VsZCBzYXkgZXZlcnkgb25lIHRvIGZvdXIKdGltZXMgaSBydW4gdGhpcyBzY3JpcHQgaXQgY3Jh c2hlcyB0aGUgc2VydmVyLiBXZSBoYXZlIHRyaWVkIHRoaXMgc2NyaXB0CnZhcmlvdXMgd2F5cyBh bmQgdGhlIHJlc3VsdCBpcyB0aGUgc2FtZSBidXQgSSBhbSBoYXBweSB0byB0YWtlIHN1Z2dlc3Rp b25zLgoNCg0KZm91cnRoIHJ1biB3aXRoOiBwc3FsIC1wIDU0MzQgLTFmIHNhZ2Uuc3FsIGNyYXNo ZXMgYW5kIGdhdmUgbWUgdGhlIHNhbWUKb3V0cHV0IGFzIGFib3ZlLg0KDQpBdWcgIDIgMjA6MTA6 MTIgYnZjIHBvc3RncmVzWzk5NzU5XTogWzUtMV0gMjAyMy0wOC0wMiAyMDoxMDoxMi42ODcgQ0RU Cls5OTc1OV0gRVJST1I6ICBzeW50YXggZXJyb3IgYXQgb3IgbmVhciAiZHNhZmFzZGZkcyIgYXQg Y2hhcmFjdGVyIDENCkF1ZyAgMiAyMDoxMDoxMiBidmMgcG9zdGdyZXNbOTk3NTldOiBbNS0yXSAy MDIzLTA4LTAyIDIwOjEwOjEyLjY4NyBDRFQKWzk5NzU5XSBTVEFURU1FTlQ6ICBkc2FmYXNkZmRz DQpBdWcgIDIgMjA6MTA6MTMgYnZjIHBvc3RncmVzWzIwXTogWzUtMV0gMjAyMy0wOC0wMiAyMDox MDoxMy45ODEgQ0RUIFsyMF0KRVJST1I6ICBzeW50YXggZXJyb3IgYXQgb3IgbmVhciAiZHNhZmFz ZGZkcyIgYXQgY2hhcmFjdGVyIDENCkF1ZyAgMiAyMDoxMDoxMyBidmMgcG9zdGdyZXNbMjBdOiBb NS0yXSAyMDIzLTA4LTAyIDIwOjEwOjEzLjk4MSBDRFQgWzIwXQpTVEFURU1FTlQ6ICBkc2FmYXNk ZmRzDQpBdWcgIDIgMjA6MTA6MTQgYnZjIHBvc3RncmVzWzcxMF06IFs1LTFdIDIwMjMtMDgtMDIg MjA6MTA6MTQuODIzIENEVCBbNzEwXQpFUlJPUjogIHN5bnRheCBlcnJvciBhdCBvciBuZWFyICJk c2FmYXNkZmRzIiBhdCBjaGFyYWN0ZXIgMQ0KQXVnICAyIDIwOjEwOjE0IGJ2YyBwb3N0Z3Jlc1s3 MTBdOiBbNS0yXSAyMDIzLTA4LTAyIDIwOjEwOjE0LjgyMyBDRFQgWzcxMF0KU1RBVEVNRU5UOiAg ZHNhZmFzZGZkcw0KQXVnICAyIDIwOjEwOjE1IGJ2YyBwb3N0Z3Jlc1s4ODMxNF06IFs1LTFdIDIw MjMtMDgtMDIgMjA6MTA6MTUuMDQwIENEVApbODgzMTRdIFBBTklDOiAgY291bGQgbm90IG9wZW4g ZmlsZSAicGdfd2FsLzAwMDAwMDAxMDAwMDAwMDAwMDAwMDAwOCI6IE5vCnN1Y2ggZmlsZSBvciBk aXJlY3RvcnkKCg== --===============2566401847649606345==--