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 1r8nKG-00BiSd-Ex for pgsql-general@arkaria.postgresql.org; Thu, 30 Nov 2023 20:07:56 +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 1r8nKE-002XtK-UZ for pgsql-general@arkaria.postgresql.org; Thu, 30 Nov 2023 20:07:54 +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 1r8nKE-002XtB-Ji for pgsql-general@lists.postgresql.org; Thu, 30 Nov 2023 20:07:54 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8nKC-0089ko-4j for pgsql-general@postgresql.org; Thu, 30 Nov 2023 20:07:53 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 3AUK7nPQ508801; Thu, 30 Nov 2023 15:07:49 -0500 From: Tom Lane To: John DeSoi cc: Joe Conway , Postgres General Subject: Re: libpq crashing on macOS during connection startup In-reply-to: <0100018c20c97a5e-2aa47402-cd8c-4548-bbd3-b17d10020b39-000000@email.amazonses.com> References: <0100018c20b152e0-ec85ac20-b379-46d7-a962-c59e00f3201c-000000@email.amazonses.com> <96e41ee8-a1b6-4bf9-82b5-1c0fd2d5502a@joeconway.com> <0100018c20c97a5e-2aa47402-cd8c-4548-bbd3-b17d10020b39-000000@email.amazonses.com> Comments: In-reply-to John DeSoi message dated "Thu, 30 Nov 2023 15:12:04 +0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <508799.1701374869.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 30 Nov 2023 15:07:49 -0500 Message-ID: <508800.1701374869@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk John DeSoi writes: >> On Nov 30, 2023, at 8:59 AM, Joe Conway wrote: >> Did you recently get an OpenSSL upgrade to v3.2.0? This is a shot in th= e dark, but perhaps related to the discussion here? >> https://www.postgresql.org/message-id/flat/CAN55FZ1eDDYsYaL7mv%2BoSLUij= 2h_u6hvD4Qmv-7PK7jkji0uyQ%40mail.gmail.com > No, this server is on openssl 3.1.4. But thanks for sending that, I'm ab= out to setup a new server and I'm sure it will end up with the latest vers= ions. The crash appears to be happening within GSSAPI authentication, which presumably indicates that we're not using OpenSSL, so that isn't where to look. What troubles me about that stack trace is the references to Heimdal. We gave up supporting Heimdal (and v16 explicitly rejects building with it) because its support for Kerberos credentials was too incomplete and flaky. So I'm inclined to guess that you are running into some Heimdal bug. Try to rebuild libpq using MIT Kerberos and see if things get better. regards, tom lane