Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p0rOF-0007bu-6Q for pgsql-bugs@arkaria.postgresql.org; Thu, 01 Dec 2022 21:46:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p0rOD-0006mE-9r for pgsql-bugs@arkaria.postgresql.org; Thu, 01 Dec 2022 21:46:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p0r2M-0006KJ-7s for pgsql-bugs@lists.postgresql.org; Thu, 01 Dec 2022 21:24:06 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p0r2J-0007iH-Tu for pgsql-bugs@lists.postgresql.org; Thu, 01 Dec 2022 21:24:05 +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=b6RSyHA0/Wtr/oa2EVdVccN4etti/J270dQeC8Qx5Ys=; b=iMeUqqV4+nxyCc9xnD/q+lMbnP rz8rzhThFBdIBHOvEGuO5XKS/tIyBqjxY74oUEr0bBa6mhV28mGD6cSzrPY5R7YOdnm7l2JxQls0n /VbDTc9j7auoBUPBQ2llysFjk0A57cGX+/dWHRzUvBSOoWsQhf8KpRU6dfT0Y/4jfurj7vSIC+S/h gHquegq1PXjlGw33CS3oHIP8UpWnDArOE3DBMmOpD1QgmvCGfWhecYjwF4iQT/RX5EYGMu8t20FT3 5rOWFnJn095Z3tJdsBOk8mkQLHtVWdU35AB1RjnE1YAK7i8n4X2N/dX9x9AW17XlwcsqUV61d8foS 8SrzDmYg==; 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 1p0r2J-0002UC-Du for pgsql-bugs@lists.postgresql.org; Thu, 01 Dec 2022 21:24:03 +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 1p0r2H-006V42-Um for pgsql-bugs@lists.postgresql.org; Thu, 01 Dec 2022 21:24:02 +0000 Content-Type: multipart/mixed; boundary="===============6723933131271017420==" MIME-Version: 1.0 Subject: BUG #17704: Monitoring Queries trigger 'Signal 7: Bus Error' After Creating Hash Partitioned Table To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: garrett@rave.io Reply-To: garrett@rave.io, pgsql-bugs@lists.postgresql.org Date: Thu, 01 Dec 2022 21:23:06 +0000 Message-ID: <17704-601ac10a659e8855@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 --===============6723933131271017420== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzcwNApMb2dnZWQgYnk6ICAgICAgICAgIEdhcnJldHQgRXZlcmRpbmcK RW1haWwgYWRkcmVzczogICAgICBnYXJyZXR0QHJhdmUuaW8KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx NC42Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDIyLjA0CkRlc2NyaXB0aW9uOiAgICAgICAg CgpIaSwgDQoNCkknbSBub3Qgc3VyZSBpZiB0aGlzIGlzIHRoZSByaWdodCBwbGFjZSB0byBwb3N0 IHRoaXMgYW5kIGlmIHRoaXMgX2lzbid0XyBhCmJ1ZyBhbmQgaXMgaW5zdGVhZCBhIG1pc2NvbmZp Z3VyYXRpb24gSSBjYW4gcmVwb3N0IHNvbWV3aGVyZSBlbHNlLiANCg0KVG9kYXkgSSByb2xsZWQg b3V0IGEgbmV3IGhhc2ggcGFydGl0aW9uZWQgdGFibGUgd2l0aCAxMDI0IHBhcnRpdGlvbnMgdG8g b3VyCnByb2R1Y3Rpb24gREIgKFBvc3RncmVTUUwgMTQuNiAoVWJ1bnR1IDE0LjYtMS5wZ2RnMjIu MDQrMSkgb24KYWFyY2g2NC11bmtub3duLWxpbnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChVYnVu dHUgMTEuMy4wLTF1YnVudHUxfjIyLjA0KQoxMS4zLjAsIDY0LWJpdCkuIFByZXZpb3VzbHkgd2Ug aGFkIGJlZW4gdXNpbmcgcGdhbmFseXplMiBhbmQgcGdtZXRyaWNzIHdpdGgKbm8gaXNzdWUuIFN0 YXJ0aW5nIHdpdGggdGhlIGRlcGxveW1lbnQgb2YgdGhlIG5ldyBwYXJ0aXRpb25lZCB0YWJsZSBh bnl0aW1lCnBnbWV0cmljcyBvciBwZ2FuYWx5emUyIHdvdWxkIHJ1biB3ZSB3b3VsZCBnZXQgYSBT SUdCVVMgYW5kIHBvc3RncmVzcWwgd291bGQKY3Jhc2guIA0KDQpgYGANCjIwMjItMTItMDEgMTc6 NDg6MjkgVVRDIFs5MTU0NDddOiB1c2VyPSxkYj0sYXBwPSxjbGllbnQ9IExPRzogIHNlcnZlcgpw cm9jZXNzIChQSUQgMTM0MTU4MSkgd2FzIHRlcm1pbmF0ZWQgYnkgc2lnbmFsIDc6IEJ1cyBlcnJv cg0KMjAyMi0xMi0wMSAxNzo0ODoyOSBVVEMgWzkxNTQ0N106IHVzZXI9LGRiPSxhcHA9LGNsaWVu dD0gREVUQUlMOiAgRmFpbGVkCnByb2Nlc3Mgd2FzIHJ1bm5pbmc6IFNFVCBsb2NrX3RpbWVvdXQg VE8gJzEwMG1zJztTRVQgc3RhdGVtZW50X3RpbWVvdXQgVE8KJzVzJzsNCiAgICAgICAgc2VsZWN0 DQogICAgICAgICAgKGV4dHJhY3QoZXBvY2ggZnJvbSBub3coKSkgKiAxZTkpOjppbnQ4IGFzIGVw b2NoX25zLA0KICAgICAgICAgIHF1b3RlX2lkZW50KHRhYmxlX3NjaGVtYSl8fCcuJ3x8cXVvdGVf aWRlbnQodGFibGVfbmFtZSkgYXMKdGFnX3RhYmxlLA0KICAgICAgICAgIG1kNSgoYXJyYXlfYWdn KChjLiopOjp0ZXh0IG9yZGVyIGJ5IG9yZGluYWxfcG9zaXRpb24pKTo6dGV4dCkNCiAgICAgICAg ZnJvbSAoDQogICAgICAgICBTRUxFQ1QgY3VycmVudF9kYXRhYmFzZSgpOjppbmZvcm1hdGlvbl9z Y2hlbWEuc3FsX2lkZW50aWZpZXIgQVMKdGFibGVfY2F0YWxvZywNCiAgICAgICAgICAgIG5jLm5z cG5hbWU6OmluZm9ybWF0aW9uX3NjaGVtYS5zcWxfaWRlbnRpZmllciBBUyB0YWJsZV9zY2hlbWEs DQogICAgICAgICAgICBjLnJlbG5hbWU6OmluZm9ybWF0aW9uX3NjaGVtYS5zcWxfaWRlbnRpZmll ciBBUyB0YWJsZV9uYW1lLA0KICAgICAgICAgICAgYS5hdHRuYW1lOjppbmZvcm1hdGlvbl9zY2hl bWEuc3FsX2lkZW50aWZpZXIgQVMgY29sdW1uX25hbWUsDQogICAgICAgICAgICBhLmF0dG51bTo6 aW5mb3JtYXRpb25fc2NoZW1hLmNhcmRpbmFsX251bWJlciBBUwpvcmRpbmFsX3Bvc2l0aW9uLA0K ICAgICAgICAgICAgcGdfZ2V0X2V4cHIoYWQuYWRiaW4sCmFkLmFkcmVsaWQpOjppbmZvcm1hdGlv bl9zY2hlbWEuY2hhcmFjdGVyX2RhdGEgQVMgY29sdW1uX2RlZmF1bHQsDQogICAgICAgICAgICAg ICAgQ0FTRQ0KICAgICAgICAgICAgICAgICAgICBXSEVOIGEuYXR0bm90bnVsbCBPUiB0LnR5cHR5 cGUgPSAnZCc6OiJjaGFyIiBBTkQKdC50eXBub3RudWxsIFRIRU4gJ05PJzo6dGV4dA0KICAgICAg ICAgICAgICAgICAgICBFTFNFICdZRVMnOjp0ZXh0DQogICAgICAgICAgICAgICAgRU5EOjppbmZv cm1hdGlvbl9zY2hlbWEueWVzX29yX25vIEFTIGlzX251bGxhYmxlLA0KICAgICAgICAgICAgICAg IENBU0UNCiAgICAgICAgICAgICAgICAgICAgV0hFTiB0LnR5cHR5cGUgPSAnZCc6OiJjaGFyIiBU SEVODQogICAgICAgICAgICAgICAgICAgIENBU0UNCiAgICAgICAgICAgICAgICAgICAgICAgIFdI RU4gYnQudHlwZWxlbSA8PiAwOjpvaWQgQU5EIGJ0LnR5cGxlbg0KMjAyMi0xMi0wMSAxNzo0ODoy OSBVVEMgWzkxNTQ0N106IHVzZXI9LGRiPSxhcHA9LGNsaWVudD0gTE9HOiAgdGVybWluYXRpbmcK YW55IG90aGVyIGFjdGl2ZSBzZXJ2ZXIgcHJvY2Vzc2VzDQpgYGANCjIwMjItMTItMDEgMTg6MjE6 NDMgVVRDIFs5MTU0NDddOiB1c2VyPSxkYj0sYXBwPSxjbGllbnQ9IExPRzogIHNlcnZlcgpwcm9j ZXNzIChQSUQgMTM0NzA5MSkgd2FzIHRlcm1pbmF0ZWQgYnkgc2lnbmFsIDc6IEJ1cyBlcnJvcg0K MjAyMi0xMi0wMSAxODoyMTo0MyBVVEMgWzkxNTQ0N106IHVzZXI9LGRiPSxhcHA9LGNsaWVudD0g REVUQUlMOiAgRmFpbGVkCnByb2Nlc3Mgd2FzIHJ1bm5pbmc6DQogICAgICAgIFNFTEVDVA0KICAg ICAgICAgIGN1cnJlbnRfZGF0YWJhc2UoKSBBUyBkYiwgc2NoZW1hbmFtZSwgdGFibGVuYW1lLCBy ZWx0dXBsZXM6OmJpZ2ludApBUyB0dXBzLCByZWxwYWdlczo6YmlnaW50IEFTIHBhZ2VzLCBvdHRh LA0KICAgICAgICAgIFJPVU5EKENBU0UgV0hFTiBvdHRhPTAgT1Igc21sLnJlbHBhZ2VzPTAgT1Ig c21sLnJlbHBhZ2VzPW90dGEgVEhFTgowLjAgRUxTRSBzbWwucmVscGFnZXMvb3R0YTo6bnVtZXJp YyBFTkQsMSkgQVMgdGJsb2F0LA0KICAgICAgICAgIENBU0UgV0hFTiByZWxwYWdlcyA8IG90dGEg VEhFTiAwIEVMU0UgcmVscGFnZXM6OmJpZ2ludCAtIG90dGEgRU5ECkFTIHdhc3RlZHBhZ2VzLA0K ICAgICAgICAgIENBU0UgV0hFTiByZWxwYWdlcyA8IG90dGEgVEhFTiAwIEVMU0UKYnMqKHNtbC5y ZWxwYWdlcy1vdHRhKTo6YmlnaW50IEVORCBBUyB3YXN0ZWRieXRlcywNCiAgICAgICAgICBDQVNF IFdIRU4gcmVscGFnZXMgPCBvdHRhIFRIRU4gJzAgYnl0ZXMnOjp0ZXh0IEVMU0UKKGJzKihyZWxw YWdlcy1vdHRhKSk6OmJpZ2ludDo6dGV4dCB8fCAnIGJ5dGVzJyBFTkQgQVMgd2FzdGVkc2l6ZSwN CiAgICAgICAgICBpbmFtZSwgaXR1cGxlczo6YmlnaW50IEFTIGl0dXBzLCBpcGFnZXM6OmJpZ2lu dCBBUyBpcGFnZXMsCmlvdHRhLA0KICAgICAgICAgIFJPVU5EKENBU0UgV0hFTiBpb3R0YT0wIE9S IGlwYWdlcz0wIE9SIGlwYWdlcz1pb3R0YSBUSEVOIDAuMCBFTFNFCmlwYWdlcy9pb3R0YTo6bnVt ZXJpYyBFTkQsMSkgQVMgaWJsb2F0LA0KICAgICAgICAgIENBU0UgV0hFTiBpcGFnZXMgPCBpb3R0 YSBUSEVOIDAgRUxTRSBpcGFnZXM6OmJpZ2ludCAtIGlvdHRhIEVORCBBUwp3YXN0ZWRpcGFnZXMs DQogICAgICAgICAgQ0FTRSBXSEVOIGlwYWdlcyA8IGlvdHRhIFRIRU4gMCBFTFNFIChicyooaXBh Z2VzLWlvdHRhKSk6OmJpZ2ludApFTkQgQVMgd2FzdGVkaWJ5dGVzLA0KICAgICAgICAgIENBU0Ug V0hFTiBpcGFnZXMgPCBpb3R0YSBUSEVOICcwIGJ5dGVzJyBFTFNFCihicyooaXBhZ2VzLWlvdHRh KSk6OmJpZ2ludDo6dGV4dCB8fCAnIGJ5dGVzJyBFTkQgQVMgd2FzdGVkaXNpemUsDQogICAgICAg ICAgQ0FTRSBXSEVOIHJlbHBhZ2VzIDwgb3R0DQoyMDIyLTEyLTAxIDE4OjIxOjQzIFVUQyBbOTE1 NDQ3XTogdXNlcj0sZGI9LGFwcD0sY2xpZW50PSBMT0c6ICB0ZXJtaW5hdGluZwphbnkgb3RoZXIg YWN0aXZlIHNlcnZlciBwcm9jZXNzZXMNCmBgYA0KDQpPbiBhbm90aGVyIGNvbm5lY3Rpb24gb3Bl biBjb25uZWN0aW9uIGR1cmluZyBvbmUgb2YgdGhlIGNyYXNoZXMgd2Ugc2F3IHRoaXMKZXJyb3I6 DQpgYGANCmluc2VydCBpbnRvIDx0YWJsZT4gc2VsZWN0ICogZnJvbSA8b3RoZXIgdGFibGU+Ow0K V0FSTklORzogIHRlcm1pbmF0aW5nIGNvbm5lY3Rpb24gYmVjYXVzZSBvZiBjcmFzaCBvZiBhbm90 aGVyIHNlcnZlcgpwcm9jZXNzDQpERVRBSUw6ICBUaGUgcG9zdG1hc3RlciBoYXMgY29tbWFuZGVk IHRoaXMgc2VydmVyIHByb2Nlc3MgdG8gcm9sbCBiYWNrIHRoZQpjdXJyZW50IHRyYW5zYWN0aW9u IGFuZCBleGl0LCBiZWNhdXNlIGFub3RoZXIgc2VydmVyIHByb2Nlc3MgZXhpdGVkCmFibm9ybWFs bHkgYW5kIHBvc3NpYmx5IGNvcnJ1cHRlZCBzaGFyZWQgbWVtb3J5Lg0KSElOVDogIEluIGEgbW9t ZW50IHlvdSBzaG91bGQgYmUgYWJsZSB0byByZWNvbm5lY3QgdG8gdGhlIGRhdGFiYXNlIGFuZApy ZXBlYXQgeW91ciBjb21tYW5kLg0KU1NMIFNZU0NBTEwgZXJyb3I6IEVPRiBkZXRlY3RlZA0KVGhl IGNvbm5lY3Rpb24gdG8gdGhlIHNlcnZlciB3YXMgbG9zdC4gQXR0ZW1wdGluZyByZXNldDogRmFp bGVkLg0KYGBgDQoNClRoaXMgaXMgYSB2ZXJ5IGFjdGl2ZSBkYiBzZXJ2aW5nIDMway01MGsgVFBT IHdpdGggN1RCIG9mIGRhdGEuIA0KDQpJIGhhdmVuJ3QgYmVlbiBhYmxlIHRvIHJlcHJvIHRoaXMg b24gb3VyIHN0YWdpbmcgZW52aXJvbm1lbnQuCgo= --===============6723933131271017420==--