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 1utUnS-008Qzd-15 for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Sep 2025 17:27:55 +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 1utUnQ-004ses-Bu for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Sep 2025 17:27: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 1utTPc-004Oa5-0w for pgsql-bugs@lists.postgresql.org; Tue, 02 Sep 2025 15:59:12 +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 1utTPW-000CNB-1p for pgsql-bugs@lists.postgresql.org; Tue, 02 Sep 2025 15:59:12 +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=EoM9ff2OJfroM1ZsPkD3ckE3Tc0yyIxiRMHMPAcuIPQ=; b=X86kjdP5ir2fNvrR/a6Y6y92w2 AvjORlx/BGEQ0cXjOyeBmCQToXcMKVdNFD3a6VBKMuO+1Iue5pFOct196qt6cetZji7/pHS333z6Q 6J6pAsJUo175F34R8HF2hOwM1FKo0fIV7G9yJ9SosVx6pZANqVsupDNrgg1JGW6KVYJgpvrCXAvuW /yWS9vWTkf1SjDDHgcEKhSOzBdIh2g7c5AMhDHpP/DAove578O0sk+ckyvvSv1rqEqIAxe3HNwD0L ZkgBje1aZsdIGo/HKw5w9uWqfjx3qE5wIntAbujnCSDQgW3Nim28kKB1HupzrQB5sINx5WoKOIGjs ZwFa1Qeg==; 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 1utTPT-000W5H-Ty for pgsql-bugs@lists.postgresql.org; Tue, 02 Sep 2025 15:59:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1utTPS-000y3R-37 for pgsql-bugs@lists.postgresql.org; Tue, 02 Sep 2025 15:59:02 +0000 Content-Type: multipart/mixed; boundary="===============1135228805175616532==" MIME-Version: 1.0 Subject: BUG #19040: Memory leak in hashed subplan node due to missing hashtempcxt reset To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mohen.lhy@alibaba-inc.com Reply-To: mohen.lhy@alibaba-inc.com, pgsql-bugs@lists.postgresql.org Date: Tue, 02 Sep 2025 15:58:49 +0000 Message-ID: <19040-c9b6073ef814f48c@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 --===============1135228805175616532== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA0MApMb2dnZWQgYnk6ICAgICAgICAgIGhhaXlhbmcgbGkKRW1haWwg YWRkcmVzczogICAgICBtb2hlbi5saHlAYWxpYmFiYS1pbmMuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMThiZXRhMwpPcGVyYXRpbmcgc3lzdGVtOiAgIGNlbnRvczcgNS4xMC44NCB4ODZfNjQKRGVz Y3JpcHRpb246ICAgICAgICAKCkhlbGxvLCBhbGwhCgpJIGZvdW5kIGEgcXVlcnkgd2hpY2ggY29u c3VtZXMgYSBsb3Qgb2YgbWVtb3J5IGFuZCB0cmlnZ2VycyBPT00ga2lsbGVyLgpNZW1vcnkgbGVh ayBvY2N1cnMgaW4gaGFzaGVkIHN1YnBsYW4gbm9kZS4KCkkgd2FzIGFibGUgdG8gY3JlYXRlIHJl cHJvZHVjaWJsZSB0ZXN0IGNhc2Ugb24gbWFjaGluZSB3aXRoIGRlZmF1bHQgY29uZmlnCmFuZCBw b3N0Z3Jlc3FsIDE4YmV0YTM6CgpDUkVBVEUgVEFCTEUgdGVzdDEoCiAgICBhIG51bWVyaWMsCiAg ICBiIGludCk7CklOU0VSVCBJTlRPCiAgICB0ZXN0MQpTRUxFQ1QKICAgIGksCiAgICBpCkZST00K ICAgIGdlbmVyYXRlX3NlcmllcygxLCAzMDAwMDAwMCkgaTsgLS0gTWFrZSB0aGUgcnVubmluZyB0 aW1lIGxvbmdlcgpFWFBMQUlOIEFOQUxZWkUgU0VMRUNUCiAgICAqCkZST00KICAgIHRlc3QxCldI RVJFCiAgICBhIE5PVCBJTigKICAgICAgICBTRUxFQ1QKICAgICAgICAgICAgaQogICAgICAgIEZS T00KICAgICAgICAgICAgZ2VuZXJhdGVfc2VyaWVzKDEsIDEwMDAwKSBpCik7CgpwbGFuOgogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg UVVFUlkgUExBTgotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KIFNlcSBTY2FuIG9uIHRlc3QxICAoY29zdD0x MjUuMDAuLjYxMjQzMi4yNCByb3dzPTE1MDAwMTA4IHdpZHRoPTEwKSAoYWN0dWFsCnRpbWU9MTM1 LjE5MS4uMjU4MzIuODA4IHJvd3M9Mjk5OTAwMDAgbG9vcHM9MSkKICAgRmlsdGVyOiAoTk9UICho YXNoZWQgU3ViUGxhbiAxKSkKICAgUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjogMTAwMDAKICAgU3Vi UGxhbiAxCiAgICAgLT4gIEZ1bmN0aW9uIFNjYW4gb24gZ2VuZXJhdGVfc2VyaWVzIGkgIChjb3N0 PTAuMDAuLjEwMC4wMCByb3dzPTEwMDAwCndpZHRoPTQpIChhY3R1YWwgdGltZT0zNi45OTkuLjM4 LjI5NiByb3dzPTEwMDAwIGxvb3BzPTEpCiBQbGFubmluZyBUaW1lOiAwLjI4MCBtcwogSklUOgog ICBGdW5jdGlvbnM6IDE1CiAgIE9wdGlvbnM6IElubGluaW5nIHRydWUsIE9wdGltaXphdGlvbiB0 cnVlLCBFeHByZXNzaW9ucyB0cnVlLCBEZWZvcm1pbmcKdHJ1ZQogICBUaW1pbmc6IEdlbmVyYXRp b24gMS4xNTUgbXMsIElubGluaW5nIDI1LjkyOSBtcywgT3B0aW1pemF0aW9uIDYwLjcwMCBtcywK RW1pc3Npb24gMjMuMDE4IG1zLCBUb3RhbCAxMTAuODAyIG1zCiBFeGVjdXRpb24gVGltZTogMjgy MTcuMDI2IG1zCigxMSByb3dzKQoKCkkgb2JzZXJ2ZWQgdGhhdCB0aGUgcHJvY2VzcydzIFJFUyAo cmVzaWRlbnQgbWVtb3J5KSB3YXMgaW5jcmVhc2luZyByYXBpZGx5CmR1cmluZyBTUUwgZXhlY3V0 aW9uIGJ5IHVzaW5nICd0b3AgLXAgPHBpZD4nIGNvbW1hbmQuCgpGdXJ0aGVybW9yZSwgZHVyaW5n IFNRTCBleGVjdXRpb24sIEkgcmFuICdzZWxlY3QKcGdfbG9nX2JhY2tlbmRfbWVtb3J5X2NvbnRl eHRzKDxwaWQ+KScKdG8gcHJpbnQgbWVtb3J5IGNvbnRleHQgc3RhdGlzdGljcy4gVGhlIGNvbnRl eHQgd2l0aCBhYm5vcm1hbGx5IGhpZ2ggbWVtb3J5CnVzYWdlIHdhcwoiU3VicGxhbiBIYXNoVGFi bGUgVGVtcCBDb250ZXh0LiIgVGhlIGtleSBwYXJ0IG9mIHRoZSBsb2cgaXMgYXMgZm9sbG93czoK Ci4uLgpMT0c6ICBsZXZlbDogNTsgU3VicGxhbiBIYXNoVGFibGUgVGVtcCBDb250ZXh0OiA1MTQ4 MzQ0MzIgdG90YWwgaW4gNjI4NDkKYmxvY2tzOyA5NzM3MTIgZnJlZSAoNjA2OTUgY2h1bmtzKTsg NTEzODYwNzIwIHVzZWQKTE9HOiAgbGV2ZWw6IDU7IFN1YnBsYW4gSGFzaFRhYmxlIENvbnRleHQ6 IDUyNDI4OCB0b3RhbCBpbiA3IGJsb2NrczsgMTIzODA4CmZyZWUgKDUgY2h1bmtzKTsgNDAwNDgw IHVzZWQKLi4uCkdyYW5kIHRvdGFsOiA1MTgyNzUzNDQgYnl0ZXMgaW4gNjMxMTYgYmxvY2tzOyAy MDI1NTYwIGZyZWUgKDYwOTc2IGNodW5rcyk7CjUxNjI0OTc4NCB1c2VkCi4uLgoKSWYgSSBjaGFu Z2UgdGhlIFNRTCBmcm9tICJhIE5PVCBJTiIgdG8gImIgTk9UIElOIiBhbmQgZG8gdGhlIHNhbWUg YWN0aW9uLCBJCmNhbiBub3QKb2JzZXJ2ZSBhYm5vcm1hbGx5IGhpZ2ggbWVtb3J5IHVzYWdlLiBM aWtld2lzZSwgdGhlIGtleSBwYXJ0IG9mIHRoZSBsb2cgaXMKYXMgZm9sbG93czoKLi4uCkxPRzog IGxldmVsOiA1OyBTdWJwbGFuIEhhc2hUYWJsZSBUZW1wIENvbnRleHQ6IDEwMjQgdG90YWwgaW4g MSBibG9ja3M7IDc4NApmcmVlICgwIGNodW5rcyk7IDI0MCB1c2VkCkxPRzogIGxldmVsOiA1OyBT dWJwbGFuIEhhc2hUYWJsZSBDb250ZXh0OiA1MjQyODggdG90YWwgaW4gNyBibG9ja3M7IDEyMzgw OApmcmVlICg1IGNodW5rcyk7IDQwMDQ4MCB1c2VkCi4uLgpHcmFuZCB0b3RhbDogMzQ0MTkzNiBi eXRlcyBpbiAyNjggYmxvY2tzOyAxMDUwNTIwIGZyZWUgKDI4MSBjaHVua3MpOyAyMzkxNDE2CnVz ZWQKLi4uCgpXaGlsZSBhbmFseXppbmcgdGhlIHNvdXJjZSBjb2RlLCBJIGZvdW5kIHRoYXQgdGhl IGhhc2hlZCBzdWJwbGFuIG5vZGUgZmFpbHMKdG8gcmVzZXQKdGhlICdoYXNodGVtcGN4dCcgY29u dGV4dCBhZnRlciBwcm9iaW5nIHRoZSBoYXNoIHRhYmxlIGZvciBlYWNoIHNsb3QuCgpXaGVuIHZh cmlhYmxlLWxlbmd0aCBkYXRhdHlwZXMgKGUuZy4sIG51bWVyaWMpIGFyZSBwcm9jZXNzZWQsIHRo aXMgY2FuCnRyaWdnZXIgY2FsbHMKdG8gJ2RldG9hc3RfYXR0cicsIHdoaWNoIGFsbG9jYXRlIG1l bW9yeSBpbiBoYXNodGVtcGN4dC4gV2l0aG91dCBhIHJlc2V0LAp0aGlzIG1lbW9yeQppcyBub3Qg cmVjbGFpbWVkIHVudGlsIHRoZSBjb250ZXh0IGl0c2VsZiBpcyBkZXN0cm95ZWQsIHJlc3VsdGlu ZyBpbiBhCm1lbW9yeSBsZWFrCndoZW4gcHJvY2Vzc2luZyBsYXJnZSBudW1iZXJzIG9mIHNsb3Rz LgoKQSBwYXRjaCBpbXBsZW1lbnRpbmcgdGhpcyBmaXggd2lsbCBiZSBpbmNsdWRlZCBpbiB0aGUg Zm9sbG93LXVwIGVtYWlsLgoKLS0KVGhhbmtzLApIYWl5YW5nIExpCgo= --===============1135228805175616532==--