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 1ti6tt-00BSiW-UU for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Feb 2025 07:11:14 +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 1ti6tr-005lke-P1 for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Feb 2025 07:11:12 +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 1ti6l5-005e5Q-TY for pgsql-bugs@lists.postgresql.org; Wed, 12 Feb 2025 07:02:08 +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.96) (envelope-from ) id 1ti6l4-000MdR-2x for pgsql-bugs@lists.postgresql.org; Wed, 12 Feb 2025 07:02:07 +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=u36O5+Q/WvHyKDIoKzBiIIn4iKvuxZ6zJGpVn7knPGE=; b=1Cu4Qz3Zbuex4qHFkFCHK2YDqt AfKoAr38BgOkmMHRNnmY+ui/Yv5TizkTxy8pirwejYGclPXPhEN71AwJ0kEME8EvXhr4idL/64HUg U0f9cRmkI2qRNuLooBHJTupbIzFD47nOZ2QLMdyNvt5FUsZl6JMvizzCqAe62SunvVxJ/mbqpIGzn B6KINivslOlHohIAXMH0DjNbTGZlkI5ubLGZq396EMt1zReoaqrYIF9Au065EnHhqO3WOqOZMGSD7 WgGxjgTstVDKQeICIBb1XACCZCoFU5oGVVczr5PFLHf30EK/CKioLSud2SI2Msi8sF+8OZYCP4yqq nnB4djdQ==; 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 1ti6l2-002Ebo-3O for pgsql-bugs@lists.postgresql.org; Wed, 12 Feb 2025 07:02:06 +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 1ti6l0-000XV6-7A for pgsql-bugs@lists.postgresql.org; Wed, 12 Feb 2025 07:02:02 +0000 Content-Type: multipart/mixed; boundary="===============0545942796492888368==" MIME-Version: 1.0 Subject: BUG #18806: When enable_rartitionwise_join is set to ON, the database shuts down abnormally To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: m_lingbin@126.com Reply-To: m_lingbin@126.com, pgsql-bugs@lists.postgresql.org Date: Wed, 12 Feb 2025 07:01:42 +0000 Message-ID: <18806-d70b0c9fdf63dcbf@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 --===============0545942796492888368== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODgwNgpMb2dnZWQgYnk6ICAgICAgICAgIGxpbmdiaW4gbWVuZwpFbWFp bCBhZGRyZXNzOiAgICAgIG1fbGluZ2JpbkAxMjYuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTcu MgpPcGVyYXRpbmcgc3lzdGVtOiAgIENlbnRPUyBMaW51eCByZWxlYXNlIDcuOS4yMDA5IChDb3Jl KQpEZXNjcmlwdGlvbjogICAgICAgIAoKQWZ0ZXIgdXBncmFkaW5nIFBHMTcuMiwgdGVzdGluZyBm b3VuZCB0aGF0IHdoZW4gZW5hYmxlX3JhcnRpdGlvbndpc2Vfam9pbiBpcwpzZXQgdG8gT04sIHdo ZW4gZXhlY3V0aW5nIGEgcXVlcnksIGlmIHRoZSBtYWluIHF1ZXJ5IGFuZCBzdWJxdWVyeSBoYXZl IHRoZQpzYW1lIHRhYmxlLCB0aGUgcXVlcnkgd2lsbCByZXBvcnQgYW4gZXJyb3IuDQoNClRoZSBk YXRhYmFzZSBsb2cgc2hvd3MgdGhlIGZvbGxvd2luZyBlcnJvcjoNCkxPRzogIHNlcnZlciBwcm9j ZXNzIChQSUQgMjQ3OTYpIHdhcyB0ZXJtaW5hdGVkIGJ5IHNpZ25hbCA2OiBBYm9ydGVkDQpERVRB SUw6ICBGYWlsZWQgcHJvY2VzcyB3YXMgcnVubmluZzogc2VsZWN0ICogZnJvbSB0ZXN0IHQgam9p biBvcmRlcnMgbyBvbgp0Lm9yZGVyX2lkID1vLm9yZGVyX2lkIHdoZXJlIHQub3JkZXJfaWQgaW4g KHNlbGVjdCBvcmRlcl9pZCBmcm9tIG9yZGVycyk7DQpMT0c6ICB0ZXJtaW5hdGluZyBhbnkgb3Ro ZXIgYWN0aXZlIHNlcnZlciBwcm9jZXNzZXMNCg0KVGhlIHRhYmxlIHN0cnVjdHVyZSBpcyBhcyBm b2xsb3dzLCBhbGwgb2Ygd2hpY2ggYXJlIGVtcHR5IHRhYmxlczoNCmRlbW89IyBcZCsgdGVzdA0K VGFibGUgImJvb2tpbmdzLnRlc3QiDQpDb2x1bW4gIHwgICAgICAgVHlwZSAgICAgICAgfCBDb2xs YXRpb24gfCBOdWxsYWJsZSB8IERlZmF1bHQgfCBTdG9yYWdlICB8CkNvbXByZXNzaW9uIHwgU3Rh dHMgdGFyZ2V0IHwgRGVzY3JpcHRpb24NCi0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLSst LS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0r LS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQ0Kb3JkZXJfaWQgfCBpbnRlZ2VyICAgICAgICAg ICB8ICAgICAgICAgICB8ICAgICAgICAgIHwgICAgICAgICB8IHBsYWluICAgIHwgIAogICAgICAg ICAgfCAgICAgICAgICAgICAgfA0KbmFtZSAgICAgfCBjaGFyYWN0ZXIgdmFyeWluZyB8ICAgICAg ICAgICB8ICAgICAgICAgIHwgICAgICAgICB8IGV4dGVuZGVkIHwgIAogICAgICAgICAgfCAgICAg ICAgICAgICAgfA0KQWNjZXNzIG1ldGhvZDogaGVhcA0KZGVtbz0jIFxkKyBvcmRlcnMNClBhcnRp dGlvbmVkIHRhYmxlICJib29raW5ncy5vcmRlcnMiDQpDb2x1bW4gIHwgICAgICAgICBUeXBlICAg ICAgICAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZhdWx0IHwgU3RvcmFnZSAKfCBDb21w cmVzc2lvbiB8IFN0YXRzIHRhcmdldCB8IERlc2NyaXB0aW9uDQotLS0tLS0tLS0tKy0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0t LS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tDQpvcmRlcl9pZCB8 IGludGVnZXIgICAgICAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwgICAgICAgICB8 IHBsYWluICAgCnwgICAgICAgICAgICAgfCAgICAgICAgICAgICAgfA0KbmFtZSAgICAgfCBjaGFy YWN0ZXIgdmFyeWluZygxMCkgfCAgICAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAgfCBleHRl bmRlZAp8ICAgICAgICAgICAgIHwgICAgICAgICAgICAgIHwNClBhcnRpdGlvbiBrZXk6IEhBU0gg KG9yZGVyX2lkKQ0KUGFydGl0aW9uczogb3JkZXJzX3AxIEZPUiBWQUxVRVMgV0lUSCAobW9kdWx1 cyAzMiwgcmVtYWluZGVyIDApLA0Kb3JkZXJzX3AxMCBGT1IgVkFMVUVTIFdJVEggKG1vZHVsdXMg MzIsIHJlbWFpbmRlciA5KSwNCm9yZGVyc19wMTEgRk9SIFZBTFVFUyBXSVRIIChtb2R1bHVzIDMy LCByZW1haW5kZXIgMTApLA0Kb3JkZXJzX3AxMiBGT1IgVkFMVUVTIFdJVEggKG1vZHVsdXMgMzIs IHJlbWFpbmRlciAxMSksDQpvcmRlcnNfcDEzIEZPUiBWQUxVRVMgV0lUSCAobW9kdWx1cyAzMiwg cmVtYWluZGVyIDEyKSwNCm9yZGVyc19wMTQgRk9SIFZBTFVFUyBXSVRIIChtb2R1bHVzIDMyLCBy ZW1haW5kZXIgMTMpLA0Kb3JkZXJzX3AxNSBGT1IgVkFMVUVTIFdJVEggKG1vZHVsdXMgMzIsIHJl bWFpbmRlciAxNCksDQpvcmRlcnNfcDE2IEZPUiBWQUxVRVMgV0lUSCAobW9kdWx1cyAzMiwgcmVt YWluZGVyIDE1KSwNCm9yZGVyc19wMTcgRk9SIFZBTFVFUyBXSVRIIChtb2R1bHVzIDMyLCByZW1h aW5kZXIgMTYpLA0Kb3JkZXJzX3AxOCBGT1IgVkFMVUVTIFdJVEggKG1vZHVsdXMgMzIsIHJlbWFp bmRlciAxNyksDQpvcmRlcnNfcDE5IEZPUiBWQUxVRVMgV0lUSCAobW9kdWx1cyAzMiwgcmVtYWlu ZGVyIDE4KSwNCm9yZGVyc19wMiBGT1IgVkFMVUVTIFdJVEggKG1vZHVsdXMgMzIsIHJlbWFpbmRl ciAxKSwNCm9yZGVyc19wMjAgRk9SIFZBTFVFUyBXSVRIIChtb2R1bHVzIDMyLCByZW1haW5kZXIg MTkpLA0Kb3JkZXJzX3AyMSBGT1IgVkFMVUVTIFdJVEggKG1vZHVsdXMgMzIsIHJlbWFpbmRlciAy MCksDQpvcmRlcnNfcDIyIEZPUiBWQUxVRVMgV0lUSCAobW9kdWx1cyAzMiwgcmVtYWluZGVyIDIx KSwNCm9yZGVyc19wMjMgRk9SIFZBTFVFUyBXSVRIIChtb2R1bHVzIDMyLCByZW1haW5kZXIgMjIp LA0Kb3JkZXJzX3AyNCBGT1IgVkFMVUVTIFdJVEggKG1vZHVsdXMgMzIsIHJlbWFpbmRlciAyMyks DQpvcmRlcnNfcDI1IEZPUiBWQUxVRVMgV0lUSCAobW9kdWx1cyAzMiwgcmVtYWluZGVyIDI0KSwN Cm9yZGVyc19wMjYgRk9SIFZBTFVFUyBXSVRIIChtb2R1bHVzIDMyLCByZW1haW5kZXIgMjUpLA0K b3JkZXJzX3AyOCBGT1IgVkFMVUVTIFdJVEggKG1vZHVsdXMgMzIsIHJlbWFpbmRlciAyNyksDQpv cmRlcnNfcDI5IEZPUiBWQUxVRVMgV0lUSCAobW9kdWx1cyAzMiwgcmVtYWluZGVyIDI4KSwNCm9y ZGVyc19wMyBGT1IgVkFMVUVTIFdJVEggKG1vZHVsdXMgMzIsIHJlbWFpbmRlciAyKSwNCm9yZGVy c19wMzAgRk9SIFZBTFVFUyBXSVRIIChtb2R1bHVzIDMyLCByZW1haW5kZXIgMjkpLA0Kb3JkZXJz X3AzMSBGT1IgVkFMVUVTIFdJVEggKG1vZHVsdXMgMzIsIHJlbWFpbmRlciAzMCksDQpvcmRlcnNf cDMyIEZPUiBWQUxVRVMgV0lUSCAobW9kdWx1cyAzMiwgcmVtYWluZGVyIDMxKSwNCm9yZGVyc19w NCBGT1IgVkFMVUVTIFdJVEggKG1vZHVsdXMgMzIsIHJlbWFpbmRlciAzKSwNCm9yZGVyc19wNSBG T1IgVkFMVUVTIFdJVEggKG1vZHVsdXMgMzIsIHJlbWFpbmRlciA0KSwNCm9yZGVyc19wNiBGT1Ig VkFMVUVTIFdJVEggKG1vZHVsdXMgMzIsIHJlbWFpbmRlciA1KSwNCm9yZGVyc19wNyBGT1IgVkFM VUVTIFdJVEggKG1vZHVsdXMgMzIsIHJlbWFpbmRlciA2KSwNCm9yZGVyc19wOCBGT1IgVkFMVUVT IFdJVEggKG1vZHVsdXMgMzIsIHJlbWFpbmRlciA3KSwNCm9yZGVyc19wOSBGT1IgVkFMVUVTIFdJ VEggKG1vZHVsdXMgMzIsIHJlbWFpbmRlciA4KQ0KZGVtbz0jCgo= --===============0545942796492888368==--