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 1mgPYP-0007Vm-Pe for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Oct 2021 10:56:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mgPYO-0003xt-Pb for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Oct 2021 10:56:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mgK5h-0000AQ-Ky for pgsql-bugs@lists.postgresql.org; Fri, 29 Oct 2021 05:06:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mgK5d-00070k-Dc for pgsql-bugs@lists.postgresql.org; Fri, 29 Oct 2021 05:06: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=CPu8+9FzIcttpy7j0z5uQKxZRLJhX3FTezd86BLhwmM=; b=mAqjhynfewXuI6JVuYg3KZrZFE ZNxiK5anGdyyT+grG15vyqGE5/mW/e+ekCi/di707iXpJTGja5KCSUF2rbZ2+RiH+0NtF3KSArOQZ ZI3wfcFkU5AzbFfUKo1O9KwRjWUGxbJKJ8bJE0N5dAbafu5eQe80B5APHwVFnaObxdCI2rOJ4R57Z DJWhlbmvyB6i6MxRQ2s7AEabe9e1nIHSICuENRN6laUZEXTU/2xD7pZ58yEFk/ctWPLLAwY0Dn5qq U7/HUIG6GRcI1kuPNk/Yz+v4DBS5Cde3ywWEhq1j62j4Zte8x0TLarHmlkW84R3NvVMcyDM7D5ohq KQUYBNLQ==; 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 1mgK5b-0001DP-Co for pgsql-bugs@lists.postgresql.org; Fri, 29 Oct 2021 05:06:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mgK5a-0000Zq-2m for pgsql-bugs@lists.postgresql.org; Fri, 29 Oct 2021 05:06:02 +0000 Content-Type: multipart/mixed; boundary="===============5496542415887777682==" MIME-Version: 1.0 Subject: BUG #17254: Crash with 0xC0000409 in pg_stat_statements when pg_stat_tmp\pgss_query_texts.stat exceeded 2GB. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: egashira.yusuke@fujitsu.com Reply-To: egashira.yusuke@fujitsu.com, pgsql-bugs@lists.postgresql.org Date: Fri, 29 Oct 2021 05:05:48 +0000 Message-ID: <17254-a926c89dc03375c2@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 --===============5496542415887777682== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzI1NApMb2dnZWQgYnk6ICAgICAgICAgIHl1c3VrZSBlZ2FzaGlyYQpF bWFpbCBhZGRyZXNzOiAgICAgIGVnYXNoaXJhLnl1c3VrZUBmdWppdHN1LmNvbQpQb3N0Z3JlU1FM IHZlcnNpb246IDE0LjAKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIFNlcnZlciAyMDE5CkRl c2NyaXB0aW9uOiAgICAgICAgCgpUaGUgZGF0YWJhc2Ugc2VydmVyIHdhcyBjcmFzaGVkIHdpdGgg MHhDMDAwMDQwOSBpbiBwZ19zdGF0X3N0YXRlbWVudHMuDQoNCjIwMjEtMTAtMjggMTQ6MTU6MTQu MjQ0IEpTVCBbNDk4MF0gTE9HOiAgc2VydmVyIHByb2Nlc3MgKFBJRCAyNTU2KSB3YXMKdGVybWlu YXRlZCBieSBleGNlcHRpb24gMHhDMDAwMDQwOQ0KMjAyMS0xMC0yOCAxNDoxNToxNC4yNDQgSlNU IFs0OTgwXSBERVRBSUw6ICBGYWlsZWQgcHJvY2VzcyB3YXMgcnVubmluZzoKc2VsZWN0IGNvdW50 KDEpIGZyb20gcGdfc3RhdF9zdGF0ZW1lbnRzOw0KMjAyMS0xMC0yOCAxNDoxNToxNC4yNDQgSlNU IFs0OTgwXSBISU5UOiAgU2VlIEMgaW5jbHVkZSBmaWxlICJudHN0YXR1cy5oIgpmb3IgYSBkZXNj cmlwdGlvbiBvZiB0aGUgaGV4YWRlY2ltYWwgdmFsdWUuDQoNClRoaXMgY3Jhc2ggaGFwcGVuZWQg d2l0aCBQb3N0Z3JlU1FMIDE0LjAgZm9yIFdpbmRvd3MgZG93bmxvYWRlZCBmcm9tCmh0dHBzOi8v d3d3LmVudGVycHJpc2VkYi5jb20vZG93bmxvYWQtcG9zdGdyZXNxbC1iaW5hcmllcy4NCg0KQWNj b3JkaW5nIHRvIG91ciBpbnZlc3RpZ2F0aW9uLCB3aGVuIHRoZSBwZ19zdGF0X3N0YXRlbWVudHMg cmVhZHMgdGhlCnBnX3N0YXRfdG1wXHBnc3NfcXVlcnlfdGV4dHMuc3RhdCwgdGhlIHNlcnZlciBz ZWVtcyB0byBjcmFzaCB3aXRoIDB4QzAwMDA0MDkKaWYgdGhlIHNpemUgb2YgcGdzc19xdWVyeV90 ZXh0cy5zdGF0IGV4Y2VlZHMgYWJvdXQgMkdCLg0KT3VyIHVzZXIgd2FzIHBlcmZvcm1pbmcgdGFz a3MgdGhhdCBleGVjdXRlZCBhIGxvdCBvZiB2ZXJ5IGxvbmcgU1FMCnN0YXRlbWVudHMgKElOU0VS VCBzdGF0ZW1lbnQgd2l0aCBvdmVyIDEwMCwwMDAgcGFyYW1ldGVycyksIGFuZCB0aGUgc2VydmVy CmNyYXNoZWQgd2hlbmV2ZXIgcGdzc19xdWVyeV90ZXh0cy5zdGF0IGdyZXcgdG8gYSBzaXplIGxh cmdlciB0aGFuIDJHQi4NCg0KU3RyYW5nZWx5LCBJIGhhZCBjcmVhdGVkIHRoZSBjcmFzaGR1bXBz IGRpcmVjdG9yeSB1bmRlciBQR0hPTUUsIGJ1dCBhCm1pbmlkdW1wIGZpbGUgd2FzIG5vdCBvdXRw dXQuDQojIERvZXNuJ3QgYSBjcmFzaCB3aXRoIDB4QzAwMDA0MDkgb3V0cHV0IGEgZHVtcD8NCkkg cmV0cmlldmVkIGEgbWluaWR1bXAgZnJvbSBwb3N0Z3Jlcy5leGUgd2hpY2ggd2FzIHJlYnVpbHQg d2l0aCBlbmFibGVkCmR1bXBpbmcgYnkgV2luZG93c0Vycm9yUmVwb3J0Lg0KSXQgc2VlbXMgdGhh dCBhbiBleGNlcHRpb24gb2NjdXJyZWQgZHVlIHRvIGFuIGFyZ3VtZW50IGVycm9yIG9mIF9yZWFk KCkuDQoNCg0KKiBDSEFOR0VEOg0KZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL21haW4vbWFpbi5j IGIvc3JjL2JhY2tlbmQvbWFpbi9tYWluLmMNCmluZGV4IGU1OGUyNGE2NDYuLjMxOWM2YWI2MmUg MTAwNjQ0DQotLS0gYS9zcmMvYmFja2VuZC9tYWluL21haW4uYw0KKysrIGIvc3JjL2JhY2tlbmQv bWFpbi9tYWluLmMNCkBAIC02NCw5ICs2NCw2IEBAIG1haW4oaW50IGFyZ2MsIGNoYXIgKmFyZ3Zb XSkNCiAgICAgICAgICogSWYgc3VwcG9ydGVkIG9uIHRoZSBjdXJyZW50IHBsYXRmb3JtLCBzZXQg dXAgYSBoYW5kbGVyIHRvIGJlCmNhbGxlZCBpZg0KICAgICAgICAgKiB0aGUgYmFja2VuZC9wb3N0 bWFzdGVyIGNyYXNoZXMgd2l0aCBhIGZhdGFsIHNpZ25hbCBvcgpleGNlcHRpb24uDQogICAgICAg ICAqLw0KLSNpZiBkZWZpbmVkKFdJTjMyKSAmJiBkZWZpbmVkKEhBVkVfTUlOSURVTVBfVFlQRSkN Ci0gICAgICAgcGd3aW4zMl9pbnN0YWxsX2NyYXNoZHVtcF9oYW5kbGVyKCk7DQotI2VuZGlmDQoN CiAgICAgICAgcHJvZ25hbWUgPSBnZXRfcHJvZ25hbWUoYXJndlswXSk7DQoNCkBAIC0yNDcsOCAr MjQ0LDYgQEAgc3RhcnR1cF9oYWNrcyhjb25zdCBjaGFyICpwcm9nbmFtZSkNCiAgICAgICAgICAg ICAgICAgICAgICAgIGV4aXQoMSk7DQogICAgICAgICAgICAgICAgfQ0KDQotICAgICAgICAgICAg ICAgLyogSW4gY2FzZSBvZiBnZW5lcmFsIHByb3RlY3Rpb24gZmF1bHQsIGRvbid0IHNob3cgR1VJ IHBvcHVwCmJveCAqLw0KLSAgICAgICAgICAgICAgIFNldEVycm9yTW9kZShTRU1fRkFJTENSSVRJ Q0FMRVJST1JTIHwKU0VNX05PR1BGQVVMVEVSUk9SQk9YKTsNCg0KDQoqIFNUQUNLX1RFWFQ6DQp1 Y3J0YmFzZSFpbnZva2Vfd2F0c29uKzB4MTgNCnVjcnRiYXNlIWludmFsaWRfcGFyYW1ldGVyKzB4 ODENCnVjcnRiYXNlIWludmFsaWRfcGFyYW1ldGVyX25vaW5mbysweDkNCnVjcnRiYXNlIV9yZWFk KzB4M2FlZGMNCnBnX3N0YXRfc3RhdGVtZW50cyFxdGV4dF9sb2FkX2ZpbGUrMHgxMTINCnBnX3N0 YXRfc3RhdGVtZW50cyFwZ19zdGF0X3N0YXRlbWVudHNfaW50ZXJuYWwrMHgzYWUNCnBnX3N0YXRf c3RhdGVtZW50cyFwZ19zdGF0X3N0YXRlbWVudHNfMV85KzB4MTcNCnBvc3RncmVzIUV4ZWNNYWtl VGFibGVGdW5jdGlvblJlc3VsdCsweDIwNQ0KcG9zdGdyZXMhRnVuY3Rpb25OZXh0KzB4NjINCnBv c3RncmVzIUV4ZWNTY2FuRmV0Y2grMHgxMDENCnBvc3RncmVzIWZldGNoX2lucHV0X3R1cGxlKzB4 OTENCnBvc3RncmVzIWFnZ19yZXRyaWV2ZV9kaXJlY3QrMHgyNDUNCnBvc3RncmVzIUV4ZWNBZ2cr MHgxNTYNCnBvc3RncmVzIXN0YW5kYXJkX0V4ZWN1dG9yUnVuKzB4MTNhDQpwZ19zdGF0X3N0YXRl bWVudHMhcGdzc19FeGVjdXRvclJ1bisweGExDQpwb3N0Z3JlcyFQb3J0YWxSdW5TZWxlY3QrMHg5 Ng0KcG9zdGdyZXMhUG9ydGFsUnVuKzB4MWVmDQpwb3N0Z3JlcyFleGVjX3NpbXBsZV9xdWVyeSsw eDYyNw0KcG9zdGdyZXMhUG9zdGdyZXNNYWluKzB4NmU5DQpwb3N0Z3JlcyFCYWNrZW5kUnVuKzB4 NDQNCnBvc3RncmVzIVN1YlBvc3RtYXN0ZXJNYWluKzB4MjU0DQpwb3N0Z3JlcyFtYWluKzB4NDNi DQpwb3N0Z3JlcyFfX3NjcnRfY29tbW9uX21haW5fc2VoKzB4MTBjDQprZXJuZWwzMiFCYXNlVGhy ZWFkSW5pdFRodW5rKzB4MTQNCm50ZGxsIVJ0bFVzZXJUaHJlYWRTdGFydCsweDIxDQoNCg0KDQpU aGUgTVNETiBkb2N1bWVudGF0aW9uIHNheXMgdGhhdCB0aGUgdXBwZXIgbGltaXQgb2YgdGhlIF9y ZWFkKCkgYXJndW1lbnQgaXMKSU5UX01BWCAoYWJvdXQgMkdCKSwgYnV0IHRoZSBzaXplIGdvdHRl biBieSBmc3RhdCgpIGV4Y2VlZHMgdGhpcyBsaW1pdCwgc28gSQp0aGluayB3ZSBlbmNvdW50ZXJl ZCBzZXJ2ZXIgY3Jhc2ggYnkgYW4gZXhjZXB0aW9uIGVycm9yLg0KDQpodHRwczovL2RvY3MubWlj cm9zb2Z0LmNvbS9lbi11cy9jcHAvYy1ydW50aW1lLWxpYnJhcnkvcmVmZXJlbmNlL3JlYWQ/dmll dz1tc3ZjLTE2MA0KPiBJZiBidWZmZXIgaXMgTlVMTCwgb3IgaWYgYnVmZmVyX3NpemUgPiBJTlRf TUFYLCB0aGUgaW52YWxpZCBwYXJhbWV0ZXIKaGFuZGxlciBpcyBpbnZva2VkLg0KDQpVbnRpbCBQ b3N0Z3JlU1FMIDEzLCBmc3RhdCgpIGZhaWxlZCBhbmQgcmV0dXJuZWQgRVJST1Igd2hlbiBhIGZp bGUgd2FzCmxhcmdlciB0aGFuIDJHQiwgYnV0IGFzIGEgcmVzdWx0IG9mIGltcHJvdmVtZW50cyB0 byBmc3RhdCgpIGluIFBvc3RncmVTUUwKMTQsIGl0IGFwcGVhcnMgdGhhdCBfcmVhZCgpIGhhcyBl eGNlZWRlZCBpdHMgbGltaXQgYW5kIG5vdyBjYXVzZXMgYSBjcmFzaC4KCg== --===============5496542415887777682==--