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 1u7psr-007iJT-Q5 for pgsql-general@arkaria.postgresql.org; Thu, 24 Apr 2025 06:16:30 +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 1u7pso-00DeX3-Se for pgsql-general@arkaria.postgresql.org; Thu, 24 Apr 2025 06:16:27 +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 1u7hBx-00AJCc-Q8 for pgsql-general@lists.postgresql.org; Wed, 23 Apr 2025 20:59:39 +0000 Received: from mx0a-004aa801.pphosted.com ([148.163.144.23]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u7hBt-001f7D-3D for pgsql-general@lists.postgresql.org; Wed, 23 Apr 2025 20:59:37 +0000 Received: from pps.filterd (m0204360.ppops.net [127.0.0.1]) by mx0b-004aa801.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 53NHbjTn017363; Wed, 23 Apr 2025 15:59:31 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=snapon.com; h=cc :content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to; s=s2048a; bh=uPapkzlpfWJK+eREXnURi/8sixO oAmcmp48HkwWec8I=; b=aqqxlggTaoerFJbBPGdBc/ABlwO+wZObLHVNCeN0OZ+ DDx5OG6LYXG5Lg5ZBa8t1nqFyTwUf+uHV8+1aYvgOP4CRAyZyvy7eokQ7wgIXYLe zpEkLvq4es2hdXnJ7p3XhbM+Fkfy+hu8KwOLyzjyafLXW7LlKMZ1rYa1yIkitjpg 81w3PzAU0g8LiKihCrZCy2dY1gge6aQMitY8wGM6BF3uNNzbXqmY+AM7FvaB9kv1 572W+4zTmYNbJ/rQ9i/e3AhzF9YcCdKZ4KmIZGUt1FAVgx2eFEaKZSf0SmFwiPBs ixlvn9TZRzNbapKETD9qk9mXH2IH704U3XFwAsO7MYA== Received: from cy7pr03cu001.outbound.protection.outlook.com (mail-westcentralusazlp17012034.outbound.protection.outlook.com [40.93.6.34]) by mx0b-004aa801.pphosted.com (PPS) with ESMTPS id 466jkyv1n7-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Wed, 23 Apr 2025 15:59:30 -0500 (CDT) ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=K+r1FEYLf6gcju6k9/OuY2Wrq24tbp3PWvsFJLEMlPVHJ2iX+f0ywuOFQ6bX6waQuHiWIS6qzZIwtS6pHxoaRmQ+ojq8BR7nhUAQxcmwaBUBC59uNBfDlQPv4L985ju6EbjLsOcQ2PpLa9PybJ45WpB+PfjZMJhuxfN/up14cMtGbLoGkw1XoMzRruuWkfPt8srjUR1PdG6+eNKl3Hmh9pLpVSbKdUfuyuNhCE7fAgh0oPiukt2j7wixJ6oN5jDsMpEimTolCu6EEHQ9IuqJxHuxo/w/FGHQnoQsoj8ErPsjI2MLJpktpmIfg3OxRo55euprakKLDyyCFCTFMq9RSQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=jSlhiqZJqk5eTwqOHmzSh/pAZfJiQZKVaiHPq2mXoaY=; b=e2xcbl+vQwad9Pz7mZMxkDl0C3cKsu5MLPQXFpSNqsBujyLmp7IeHZAqxG1hCcU2DBocU+BzlkzL7+INBTIgpNVrbwVAKm4MkfKFX1rGfYhNHT4J6u2jl/aAKoLqTG3cOMQA+vdjsHaRlokDIDfeAp/fLjmnTA+Blp/00H7hm2pGC3Cqba4t80O+EWda7N/guUN3YvQ7xffbVSKcS/4T6+289GSR+03mPOQNQaB4Iux0yWOA/BCLZkIMie29+CCj6SXNRlJj/MhqvjZP4zmVNpKHbfP8Ofo/HUly/lzL3MpF2HPC20uuqyKvhmqtTDOvKqfZZf9aDlVoWXcJDxb60g== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=snapon.com; dmarc=pass action=none header.from=snapon.com; dkim=pass header.d=snapon.com; arc=none Received: from PH0PR04MB8294.namprd04.prod.outlook.com (2603:10b6:510:108::16) by CH2PR04MB6631.namprd04.prod.outlook.com (2603:10b6:610:9f::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8632.35; Wed, 23 Apr 2025 20:59:29 +0000 Received: from PH0PR04MB8294.namprd04.prod.outlook.com ([fe80::f454:78f0:9d78:a91a]) by PH0PR04MB8294.namprd04.prod.outlook.com ([fe80::f454:78f0:9d78:a91a%3]) with mapi id 15.20.8678.021; Wed, 23 Apr 2025 20:59:29 +0000 From: "Zechman, Derek S" To: Tom Lane CC: "pgsql-general@lists.postgresql.org" Subject: RE: segmentation fault Thread-Topic: segmentation fault Thread-Index: Adu0RWuqx7eFf+8uRdSzyT2aKYqs1wAP8BcAAAI/baA= Date: Wed, 23 Apr 2025 20:59:28 +0000 Message-ID: References: <1436822.1745436200@sss.pgh.pa.us> In-Reply-To: <1436822.1745436200@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-dg-rorf: true x-ms-publictraffictype: Email x-ms-traffictypediagnostic: PH0PR04MB8294:EE_|CH2PR04MB6631:EE_ x-ms-office365-filtering-correlation-id: f22e9e98-9b8a-4803-e5aa-08dd82a9bd1c x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|366016|376014|8096899003|13003099007|38070700018; x-microsoft-antispam-message-info: =?utf-8?B?dXNPdXhtL0xxSmU3V1FyNlNzb0U1UzlaVUsrR3V0T3gyS1RiK1AvQ0t1NjV3?= =?utf-8?B?dXh5NzdLMjlKajhCZ3ArU0NWVkxqN1dWcVkwQmdiKzlPcWFOSWVvSDdydUd0?= =?utf-8?B?S093aXhhWjVQdjhEWTBXc0FEKzVrVGZSeDhLKytlS1hMeTcwc3JEQUJLZVhT?= =?utf-8?B?YjVEQkpzd094UEQwbDN0WVV6MmZENnNKblZkVzdHWktrR1Zwd0JRdW5oZUM3?= =?utf-8?B?dS9Ha0pqZUl1cVcwYTBqRi9paCt2L1JGZmJCTGVvUHZVaDZFSTA3cWFoMXRH?= =?utf-8?B?SE9IQWhmenRLNlNWY0s5UCtFdHZnNVRhb0VaQmdXZTZjM1BXTXFaS0Y2N1NQ?= =?utf-8?B?QWg2ZVliU3ZzS25nMWtPNjAwbmhBZjVTRTNIRmJwNW16T09zbTUwcVdMVldk?= =?utf-8?B?MDNwdXBxdGdSRSs2dC91ZXBQeng5RlZHUFk4b2FvUW1hdkxXQ1U2Tkc5VGdh?= =?utf-8?B?WWd4ajRFa3h0NnpCRDI4bVZLL3NJK1dpUlE0R2M2UmpyR3l0ekJESGRiVmg2?= =?utf-8?B?cVRqTzlKVE14Lys3S1lnVnJSaDV6aFd5MWdoOUNicVQzMTc1WjB5cWl2VDJ0?= =?utf-8?B?RHN6WlI5Z2Q1bDI2RkZpWFhGZ09ONlRya3Fma0RON0FjMk1IL3YwcEFQNS9Q?= =?utf-8?B?L3pxdkZFVGxaS1FtSFRERWN2cDZYbmF5Q0pxNDFRU1pYY0lTblR0NGpLT1dY?= =?utf-8?B?dTl2Q29RS2VkUzVJOTlrOVdNeC9nWE9CZ2FvQ0RCMFhIaWJCZzNkVDdLOFpL?= =?utf-8?B?M2pLU1M2T2ZiK2tUZDZmOUZYUXFSbmdvRVBybDNZWW1sNzFpU0NGZ1JINEZI?= =?utf-8?B?N0R5d2NLMW8vRkRKeGlGVkp3RG1YNnZHUEg4TXg1bDQ0eGxkWFdNTXRhajlt?= =?utf-8?B?V3NvY1lVKzJlRHVlZUM5cktMZmlPcEM1d2V4M05HYWlLYmxJclVBamN0WnNL?= =?utf-8?B?M2hWYnJ0NkljV3UwMkJlUFprQUNoUDVOZzFaYlIzTkU1d2NQQ0s1MzIzNGht?= =?utf-8?B?TlJBNmI3THR1RTBJNXRwRy9pWVg1OG9UMCtER2lUQkV6TkJJRkJNcVdlWklh?= =?utf-8?B?OHVVbjFwQ0t1RjR6NXpzM05tczd2MTd6UkdrSWx2WGlnaUNENFZkVm9OME1C?= =?utf-8?B?Vk1zeXhlUnhudUlabjdoaWtJQnNNS0J4UmNEdFlFTWRGSDQ3ZllLRWxaZGlO?= =?utf-8?B?SFhnekJUcjhCZUpUL01NOEliQ0gxVFhwK1VVcFoyZlJzOXNORGNzK3dmYll0?= =?utf-8?B?WC82REk5ZU5odVZmL1V0K29KTGlkRzQ2M1pMUjI0KzY4NG5obFJaQk5jTU1u?= =?utf-8?B?UmxnQWhkT2U5akNFNUtlaFRBUlE1NXNnQkMxVjBRYlE0Tm1mQVIzNGNmcy9u?= =?utf-8?B?YjM0QlNqMDdqaS8vUURFaWtsU1BXYm5LWWl1Yi9nbWZmSWRMUGRscys4b3Nz?= =?utf-8?B?ekd5TjBPVnpNYUlvVDFqQzl4Wlg3VXFmRVl3Q3hod0t3TDNiRjNFVFlPV2FU?= =?utf-8?B?bXVDL3M5UHZxWnNHN1c4ekNma3FnMEpLaG9sNHFzeElEQjg0L2NqckphQlE4?= =?utf-8?B?NEFBL0lLUHkzbC9iNW9kNU5EZytFWkN2Um13UzRPN2VhSnlNenFYTml1UVp1?= =?utf-8?B?MHN6bzZNU0Q1QjJYbE5qT0tlYWJoWHZqTnAvVmpJNlFIbzUzelJPY1c0dkpi?= =?utf-8?B?MHdUeW1vdVp5eCtJNTFEU2RKMVVWcGpiZXVEeHZSUUJuYVZ1bnhCc1hwSDJV?= =?utf-8?B?UjhqZ3BnN3NpRlNoSXNpVTRxaWI1WFVtUjFrSS9uTWJQY0I5aUdkU0dBemNK?= =?utf-8?B?NkZGWXlWSkRDcXkxYTlWSmcrZ21rK1UxUVAwMG8yUUNXUjVYV2kvTmhpQzFJ?= =?utf-8?B?OG5qOGVDNndLRTZGWHphcGJOTVhKVWFrdk1jcXgzeEMxVTB6R29QUXhNUDZ6?= =?utf-8?Q?QCgm+a98PDs=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:PH0PR04MB8294.namprd04.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(366016)(376014)(8096899003)(13003099007)(38070700018);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?MlFDcEdxTEM1QkJJUWlGVzgzbEh2S1JRZUhNYzdGYy9zNml0V21DUzFZVktE?= =?utf-8?B?Y0drN3k3SkhoR0RIUFNwcnJNb2pHcHhiZHFtOTloaEdnZVI0dU9RdEFIK0w4?= =?utf-8?B?QjVkbGVHaFNSenBLKzFVcjVnSFByc2NFSU1VOGhxQzZhUncwakRVTGdlUEJ5?= =?utf-8?B?N1JydG5uRDkzS1VLY2lSNlJxeVR3L2JOSGpJR0dOT24wSXQzWDhGaTl1L09F?= =?utf-8?B?RFE5OXJSK0xaVHE3N1g2Q1RlUUpUL3NsNm1JYnNsS01yRmdqTGMvZFhCZWNh?= =?utf-8?B?YjliZzRIa2hNNktXc2RxOXJ1L2xnS1E0NUlHRnFRcXArMlZwdlBQdThYMWhE?= =?utf-8?B?SDY0bXcwbW5VMzVweVhydlNHMGs2TXhURWNPS0MrL1o5UVFqcnBvek42dEtQ?= =?utf-8?B?WERNdThsZjR6TUVXd0pRN1g4QnhhRVJ0bWtWdFJRejFlWldxM21VY1d2R3BI?= =?utf-8?B?Z1hWZTk3Zm1sWUpmQ21XVEhaQXo4VHRJWVJIdk1RS0RyVSt2M1RYcFFGblli?= =?utf-8?B?VXJUZzR3eUZNUUpJL1NuemNLQnI5ZjNPSjVPS0M0S2MwRGNEa09XYWhHWmpV?= =?utf-8?B?YXpkMVVZUEpKTWNVeWRQbTd6Z2VSMUlDQi9EVHZqMEJ6emJqakFHNkwzQVAr?= =?utf-8?B?bzZBWTRnQnBDSW0vMSt1Y3I0ZDVRWkRPN1FEZ2l2S05nM1RNVnpYNHg3Z3d4?= =?utf-8?B?OTczYkJ2THVVNWVXeFFEWnJzNk5LTWdVTlgyUUhYbmtoNUxDc2poWnZVUmQ5?= =?utf-8?B?U1hRNDYxVGRvWlFZMWs0djRNeTdGaUR0YVVDNGpXYW56U1dYWGFaMUVyeG1V?= =?utf-8?B?d1U1TE5nYXpSeCs5WElZVURXaFNEcXZrc0NXUDYyMHR2aDZyTmFheVJCTWR4?= =?utf-8?B?QUw0d2MzbFhkdzZKS2ZDbE1GMktER0hIVDN5N2VzaEZhN1hFNWszVXZ1N0I4?= =?utf-8?B?T0E1cWhjNzJleEgvclk5UFVsV2tEYVpJS3BGWkhWaG9Od24xOU1WR3I2bVRt?= =?utf-8?B?WXRkMVNHR0dQNzZlT2wvYmRwUmdnNzBkb3hzd2p6K2JzM2poajhid08zWXVT?= =?utf-8?B?akQxRWFPYnB0NTM2VGZNb2VpeWF5VDExTW9wS0FMR09aeWZheEs3S2p3NjdX?= =?utf-8?B?ZzlEeEdnT0pDVS9qdEZKTGM3TENCbVlwQWJNVXpsOVEzWE9LMjBFdzBWSHh6?= =?utf-8?B?Y2RsTTU3THNDZzNOcSsyd3ZJZ1lzQkdhQ1JVcTBWc3dKYUpLWlRESEV1VGJF?= =?utf-8?B?V3VSLy9odlVFYWxhNUhSUnpVL3ZuaFVMaDBvQ1FtTXRlTVhYUGJhK3I4KzJM?= =?utf-8?B?alJDYjlFa0M1NXloS1dJS3dSTjBrMUM4cDVadzJabElsTUFVbUpSZWtOTEhX?= =?utf-8?B?VXM2SytGc3lwV1IzdnAvcjVZblRwWEVFS1ByazBIakF5RmZYQmpGaWNBZHlq?= =?utf-8?B?NEFBRDdRZFQwc0JOOGpVR3JxYllPc2xRbWZFaERzQmdEME1EQXRRWTQxN1hj?= =?utf-8?B?Q2ZSZEFMNzZyWHdSWnptUVZqS3Mxc2dHZkRXSEE1WUtKakRhYmF1L2lKQ080?= =?utf-8?B?ekZjeTNncGVrS0V2MnNxNzA5RmtXMDhFZTJqcS9hVTJUa0E4TUtmeGFEbFpu?= =?utf-8?B?UElYVTJlMzhqQ3VEd2pqeHF2MnhKcjhWaE9BV28xcmRnd1hHYlJ0Y1kwQllY?= =?utf-8?B?Yk9YRFZLUTBpUFJTQnQwbXZhMmVZSktIUVRnRm0ycUV6dGZmYjJEeDZPMTB3?= =?utf-8?B?VUFBdWwxT2VFSEZsYmNaQkFCZ0xBWXRsQmRWQWpMaVZHL1V5RXJGcUwya1Mz?= =?utf-8?B?eHBPdUxVQU5YZ29ZU3E5dGJSM1FWYW01S2NHTU9zMXQwM0t3L25nT0I4M2Yx?= =?utf-8?B?QWFQakhVK3FvY2JEbXd5OTlaVDA5ak9BL2dvSmpUSVhqU1lBbnhseUgvRGVq?= =?utf-8?B?TFVxNVdTRHlrSlpaMjBHU2tETDVKbm1pNEhXN2tDbWJyc015RHFDYStWbUh3?= =?utf-8?B?NVd0SjNLMURtejlrdG04WVpRelJTK2E1MHF6a2dwTFV4Sk4zR3pjUCtDa2tF?= =?utf-8?B?VHh1VUk2UUp5dG9nU3NlODl2RUJsNlJHYmZUZlN4TGFHMkRZWHNTWnh3L3RN?= =?utf-8?Q?nwNAju5AnmhXAQ53OdhMhPxAi?= Content-Type: multipart/alternative; boundary="_000_PH0PR04MB82947C34FFFDDD36422969A3C0BA2PH0PR04MB8294namp_" MIME-Version: 1.0 X-OriginatorOrg: snapon.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: PH0PR04MB8294.namprd04.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: f22e9e98-9b8a-4803-e5aa-08dd82a9bd1c X-MS-Exchange-CrossTenant-originalarrivaltime: 23 Apr 2025 20:59:28.9817 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 9cbb18c7-7b64-4d6a-953b-09ec023c8c08 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: Ig1X0GFPQfj6rZ7oJvySQU7pVh+oTe8wUKfyrvQ0+8ME3dvJRdjiLvWaFjbB420Id5sHijXuIl5B1bRkivtuesVxrIgBMFpawtGHqUmBLsY= X-MS-Exchange-Transport-CrossTenantHeadersStamped: CH2PR04MB6631 X-Proofpoint-Spam-Details-Enc: AW1haW4tMjUwNDIzMDE0MyBTYWx0ZWRfX6Ygljt3F5jKF PPhv3qkOQCcbL0v2l6v9WYX6ifubSw5GECj7heC2EhV8mqvvep9XADcEB4/l2Hw06w1V2LhKHtB DggLWWrzoECeVac61pyCLDLEFyTwzUFRujykG5gPLrTM3aP78Z4AQyjaUJc7La9Gi2tVDt4M7e7 Mt/t2u4moA+UAmTZkYHuDL+bxfiAsWFgk25MKZWSsRLkqKj3mtSYEez8eaApHEQoF1y3smXfAp5 O0ElGAusQe5Mkw6FBLL2nQ1e4dElid5a+QYcV7X5S+FyJpXWmQ9Pwr9v+WgOJ2b5cN+rmRB6iTd SVpHJJgsy6QL2h37ApnI0eiHCHdDYgdjKh0G5CJzDSJdvUudpRhzvT0oURxjQPCzQ9e/SSu9Sqt HYDJ2D5b1NQHqE7TPf8vhtsJ6OSvethsWSruFjARS0S9xvoDcrNFLRSdp8dHhoEcFO2Tt/vn X-Proofpoint-ORIG-GUID: n8t86heE4b5KrJGRZLEXhitRW37gNyZi X-Authority-Analysis: v=2.4 cv=IeyHWXqa c=1 sm=1 tr=0 ts=680954b3 cx=c_pps a=jgLrbg7RBTw9j6qPRKhXvw==:117 a=lCpzRmAYbLLaTzLvsPZ7Mbvzbb8=:19 a=wKuvFiaSGQ0qltdbU6+NXLB8nM8=:19 a=Ol13hO9ccFRV9qXi2t6ftBPywas=:19 a=xqWC_Br6kY4A:10 a=XR8D0OoHHMoA:10 a=RpNjiQI2AAAA:8 a=epTmVMiNAAAA:8 a=uherdBYGAAAA:8 a=4mqxUAhJAAAA:8 a=OVsnOI6VJZMQeMgWHuQA:9 a=QEXdDO2ut3YA:10 a=yMhMjlubAAAA:8 a=SSmOFEACAAAA:8 a=BJ0JtBB8xYXfGUXz:21 a=gKO2Hq4RSVkA:10 a=UiCQ7L4-1S4A:10 a=hTZeC7Yk6K0A:10 a=frz4AuCg-hUA:10 a=lqcHg5cX4UMA:10 a=saNgzuZlz8onp0SHZqw1:22 X-Proofpoint-GUID: n8t86heE4b5KrJGRZLEXhitRW37gNyZi X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1099,Hydra:6.0.680,FMLib:17.12.80.40 definitions=2025-04-23_11,2025-04-22_01,2025-02-21_01 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 impostorscore=0 lowpriorityscore=0 bulkscore=0 priorityscore=1501 adultscore=0 clxscore=1011 spamscore=0 suspectscore=0 mlxlogscore=999 mlxscore=0 phishscore=0 malwarescore=0 classifier=spam authscore=0 authtc=n/a authcc= route=outbound adjust=0 reason=mlx scancount=1 engine=8.19.0-2504070000 definitions=main-2504230143 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_PH0PR04MB82947C34FFFDDD36422969A3C0BA2PH0PR04MB8294namp_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable We got it from pgdg repository. Here is the output of pg_config is below. We have been struggling to get a= stack trace, however =E2=80=93 since we couldn=E2=80=99t reproduce it with= a vanilla installation and neither could you =E2=80=93 we determined it mu= st be something specific to our environment. Turns out when pg_show_plan = is in the shared_preload_libraries then we get a segmentation fault. I che= cked the github repo from cybertec and surprised there have been no reporte= d issues with it. I will be posting there shortly. BINDIR =3D /usr/pgsql-16/bin DOCDIR =3D /usr/pgsql-16/doc HTMLDIR =3D /usr/pgsql-16/doc/html INCLUDEDIR =3D /usr/pgsql-16/include PKGINCLUDEDIR =3D /usr/pgsql-16/include INCLUDEDIR-SERVER =3D /usr/pgsql-16/include/server LIBDIR =3D /usr/pgsql-16/lib PKGLIBDIR =3D /usr/pgsql-16/lib LOCALEDIR =3D /usr/pgsql-16/share/locale MANDIR =3D /usr/pgsql-16/share/man SHAREDIR =3D /usr/pgsql-16/share SYSCONFDIR =3D /etc/sysconfig/pgsql PGXS =3D /usr/pgsql-16/lib/pgxs/src/makefiles/pgxs.mk CONFIGURE =3D '--enable-rpath' '--prefix=3D/usr/pgsql-16' '--includedir=3D= /usr/pgsql-16/include' '--mandir=3D/usr/pgsql-16/share/man' '--datadir=3D/u= sr/pgsql-16/share' '--libdir=3D/usr/pgsql-16/lib' '--with-lz4' '--with-zstd= ' '--enable-tap-tests' '--with-icu' '--with-llvm' '--with-perl' '--with-pyt= hon' '--with-tcl' '--with-tclconfig=3D/usr/lib64' '--with-openssl' '--with-= pam' '--with-gssapi' '--with-includes=3D/usr/include' '--with-libraries=3D/= usr/lib64' '--enable-nls' '--enable-dtrace' '--with-uuid=3De2fs' '--with-li= bxml' '--with-libxslt' '--with-ldap' '--with-selinux' '--with-systemd' '--w= ith-system-tzdata=3D/usr/share/zoneinfo' '--sysconfdir=3D/etc/sysconfig/pgs= ql' '--docdir=3D/usr/pgsql-16/doc' '--htmldir=3D/usr/pgsql-16/doc/html' 'CF= LAGS=3D-O2 -g -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE= =3D2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -greco= rd-gcc-switches -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 -specs=3D/= usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=3Dgeneric -fasynchronous-= unwind-tables -fstack-clash-protection -fcf-protection' 'LDFLAGS=3D-Wl,--as= -needed' 'LLVM_CONFIG=3D/usr/bin/llvm-config-64' 'CLANG=3D/usr/bin/clang' '= PKG_CONFIG_PATH=3D:/usr/lib64/pkgconfig:/usr/share/pkgconfig' CC =3D gcc CPPFLAGS =3D -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include CFLAGS =3D -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-s= tatement -Werror=3Dvla -Wendif-labels -Wmissing-format-attribute -Wimplicit= -fallthrough=3D3 -Wcast-function-type -Wshadow=3Dcompatible-local -Wformat-= security -fno-strict-aliasing -fwrapv -fexcess-precision=3Dstandard -Wno-fo= rmat-truncation -Wno-stringop-truncation -O2 -g -pipe -Wall -Werror=3Dforma= t-security -Wp,-D_FORTIFY_SOURCE=3D2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions= -fstack-protector-strong -grecord-gcc-switches -specs=3D/usr/lib/rpm/redha= t/redhat-hardened-cc1 -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 = -mtune=3Dgeneric -fasynchronous-unwind-tables -fstack-clash-protection -fcf= -protection CFLAGS_SL =3D -fPIC LDFLAGS =3D -Wl,--as-needed -L/usr/lib64 -L/usr/lib -L/usr/lib64 -Wl,--as-n= eeded -Wl,-rpath,'/usr/pgsql-16/lib',--enable-new-dtags LDFLAGS_EX =3D LDFLAGS_SL =3D LIBS =3D -lpgcommon -lpgport -lselinux -lzstd -llz4 -lxslt -lxml2 -lpam -ls= sl -lcrypto -lgssapi_krb5 -lz -lreadline -lpthread -lrt -ldl -lm VERSION =3D PostgreSQL 16.8 From: Tom Lane Sent: Wednesday, April 23, 2025 3:23 PM To: Zechman, Derek S Cc: pgsql-general@lists.postgresql.org Subject: Re: segmentation fault "Zechman, Derek S" writes: > We are getting a segmentation fault which seems to be = specific to pg16 on redhat 8. Tested on pg14 and pg15 with no problems. Als= o tested with pg16 on redhat 9 - no issues. The "Zechman, Derek S" > writes: > We are getting a segmentation fault which seems to be specific to pg16 on= redhat 8. Tested on pg14 and pg15 with no problems. Also tested with pg1= 6 on redhat 9 - no issues. The developer determined that it is specific to= select into a defined variable within a function. We have a reproducible = test case that requires no data. I determined that 2857 is the maximum num= ber that doesn't crash and anything higher than that causes a segfault. Ca= n anyone help with this problem? FWIW, I cannot replicate this problem using this script. Now I'm testing v16 branch tip not 16.6, but a quick trawl through the git history didn't find any plausibly-matching bug fixes since 16.6. Where did you get your Postgres server executable from exactly, and what options was it built with? (The output of the matching version of pg_config would answer that.) Can you get a stack trace from the crash? https://urldefense.com/v3/__https://wiki.postgresql.org/wiki/Generating_a_s= tack_trace_of_a_PostgreSQL_backend__;!!Lf_9VycLqA!lHekhKzAMOJ0nurE4gyelvKXR= rULtGMRcKK1c_skYs_MZphlwF859-tyK5-8UjeYq2uE1oJb5OLpUFxi4DOF$ regards, tom lane --_000_PH0PR04MB82947C34FFFDDD36422969A3C0BA2PH0PR04MB8294namp_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

We got it from pgdg repository.

 

Here is the output of pg_config is below.  We have been s= truggling to get a stack trace, however =E2=80=93 since we couldn=E2=80=99t= reproduce it with a vanilla installation and neither could you =E2=80=93 we determined it must be something specific to our environment.&= nbsp;  Turns out when pg_show_plan is in the share= d_preload_libraries then we get a segmentation fault.  I checked the g= ithub repo from cybertec and surprised there have been no reported issues w= ith it.  I will be posting there shortly.

 

BINDIR =3D /usr/pgsql-16/bin

DOCDIR =3D /usr/pgsql-16/doc

HTMLDIR =3D /usr/pgsql-16/doc/html

INCLUDEDIR =3D /usr/pgsql-16/include<= /p>

PKGINCLUDEDIR =3D /usr/pgsql-16/include

INCLUDEDIR-SERVER =3D /usr/pgsql-16/include/server<= /span>

LIBDIR =3D /usr/pgsql-16/lib

PKGLIBDIR =3D /usr/pgsql-16/lib

LOCALEDIR =3D /usr/pgsql-16/share/locale

MANDIR =3D /usr/pgsql-16/share/man

SHAREDIR =3D /usr/pgsql-16/share

SYSCONFDIR =3D /etc/sysconfig/pgsql

PGXS =3D /usr/pgsql-16/lib/pgxs/src/makefiles/pgxs.mk

CONFIGURE =3D  '--enable-rpath' '--prefix=3D/usr/pgsql-16= ' '--includedir=3D/usr/pgsql-16/include' '--mandir=3D/usr/pgsql-16/share/ma= n' '--datadir=3D/usr/pgsql-16/share' '--libdir=3D/usr/pgsql-16/lib' '--with-lz4' '--with-zstd' '--enable-tap-tests' '--with-icu' '--with-llvm'= '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=3D/usr/lib64'= '--with-openssl' '--with-pam' '--with-gssapi' '--with-includes=3D/usr/incl= ude' '--with-libraries=3D/usr/lib64' '--enable-nls' '--enable-dtrace' '--with-uuid=3De2fs' '--with-libxml' '--with-libxslt' '-= -with-ldap' '--with-selinux' '--with-systemd' '--with-system-tzdata=3D/usr/= share/zoneinfo' '--sysconfdir=3D/etc/sysconfig/pgsql' '--docdir=3D/usr/pgsq= l-16/doc' '--htmldir=3D/usr/pgsql-16/doc/html' 'CFLAGS=3D-O2 -g -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOUR= CE=3D2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -gre= cord-gcc-switches -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 -specs= =3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=3Dgeneric -fasynchronous-unwind-tables -fstack-clash-protection -fc= f-protection' 'LDFLAGS=3D-Wl,--as-needed' 'LLVM_CONFIG=3D/usr/bin/llvm-conf= ig-64' 'CLANG=3D/usr/bin/clang' 'PKG_CONFIG_PATH=3D:/usr/lib64/pkgconfig:/u= sr/share/pkgconfig'

CC =3D gcc

CPPFLAGS =3D -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/inclu= de

CFLAGS =3D -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclar= ation-after-statement -Werror=3Dvla -Wendif-labels -Wmissing-format-attribu= te -Wimplicit-fallthrough=3D3 -Wcast-function-type -Wshadow=3Dcompatible-local -Wformat-security -fno-strict-aliasing -fwrapv= -fexcess-precision=3Dstandard -Wno-format-truncation -Wno-stringop-truncat= ion -O2 -g -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 = -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 -sp= ecs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=3Dgeneric -fasynch= ronous-unwind-tables -fstack-clash-protection -fcf-protection

CFLAGS_SL =3D -fPIC

LDFLAGS =3D -Wl,--as-needed -L/usr/lib64 -L/usr/lib -L/usr/lib= 64 -Wl,--as-needed -Wl,-rpath,'/usr/pgsql-16/lib',--enable-new-dtags

LDFLAGS_EX =3D

LDFLAGS_SL =3D

LIBS =3D -lpgcommon -lpgport -lselinux -lzstd -llz4 -lxslt -lx= ml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lpthread -lrt -ldl -= lm

VERSION =3D PostgreSQL 16.8

 

From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Wednesday, April 23, 2= 025 3:23 PM
To: Zechman, Derek S <Der= ek.S.Zechman@snapon.com>
Cc: pgsql-general@lists.post= gresql.org
Subject: Re: segmentation fa= ult

 

"Zechman, Derek S" <Derek.=E2=80=8AS.=E2=80=8AZechman@=E2=80=8Asnapon.=E2=80=8Acom&g= t; writes: > We are getting a segmentation fault which seems to be specifi= c to pg16 on redhat 8. Tested on pg14 and pg15 with no problems. Also teste= d with pg16 on redhat 9 - no issues. The

"Ze=
chman, Derek S" <Dere=
k.S.Zechman@snapon.com> writes:
> We are getting a segmentation faul=
t which seems to be specific to pg16 on redhat 8.  Tested on pg14 and =
pg15 with no problems.  Also tested with pg16 on redhat 9 - no issues.=
  The developer determined that it is specific to select into a define=
d variable within a function.  We have a reproducible test case that r=
equires no data.  I determined that 2857 is the maximum number that do=
esn't crash and anything higher than that causes a segfault.  Can anyo=
ne help with this problem?
 
FWIW, I cannot replicate this problem u=
sing this script.  Now I'm
testing v16 branch tip not 16.6, but a =
quick trawl through the git
history didn't find any plausibly-match=
ing bug fixes since 16.6.
 
Where did you get your Postgres server =
executable from exactly,
and what options was it built with?&nbs=
p; (The output of the matching
version of pg_config would answer that.=
)  Can you get a stack
trace from the crash?=

 
https://urldefense.com/v3/__https://wiki.p=
ostgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend__;!!Lf_=
9VycLqA!lHekhKzAMOJ0nurE4gyelvKXRrULtGMRcKK1c_skYs_MZphlwF859-tyK5-8UjeYq2u=
E1oJb5OLpUFxi4DOF$
 
      &nb=
sp;            =
            &nb=
sp;            =
  regards, tom lane
--_000_PH0PR04MB82947C34FFFDDD36422969A3C0BA2PH0PR04MB8294namp_--