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 1qhh3z-003v26-A9 for pgsql-bugs@arkaria.postgresql.org; Sun, 17 Sep 2023 01:59:07 +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 1qhh3x-002Hiq-NJ for pgsql-bugs@arkaria.postgresql.org; Sun, 17 Sep 2023 01:59:05 +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 1qhh3x-002HiT-Dq for pgsql-bugs@lists.postgresql.org; Sun, 17 Sep 2023 01:59:05 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qhh3t-004zHs-T1 for pgsql-bugs@lists.postgresql.org; Sun, 17 Sep 2023 01:59:03 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 612A35C00B7; Sat, 16 Sep 2023 21:59:01 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Sat, 16 Sep 2023 21:59:01 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm2; t=1694915941; x=1695002341; bh=it xFTu+Ytk/aulrCt1Jt4y/Ru3+Lk7uYKNVWd/K8Ilk=; b=kaurtjqE8UyF1Hv117 M5tJld1rA8m2vxeRdrGUD88VPq8Sf5YofF73KlK9NlS/BTmZaIHnqAXXQaJKrs1W JGvGOLJwVJk1fS8EVZGDh5qc54Q91fTMDU71fgmfGuK7y8PFUDB4PRJWT5Lrzciy Fy86KXdxI9BaBYSbJXidmZbsgkj8C4VaBo+w+CB2E9uFx6XqqZgx4ncnHzLzWiGK CjA7n98oKkpU4hbS2xIpGsKIfImvsBpjVHR0mQQeL+L3GieWmg/EeJU048UPC0Ad pSAZWC9UAxF4wub6pPCcNQ6S94PLXFlfX5ZfWuWcnKWTDc4Blx4g52xq/u5T7Qrk cQWQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; t=1694915941; x=1695002341; bh=itxFTu+Ytk/au lrCt1Jt4y/Ru3+Lk7uYKNVWd/K8Ilk=; b=Dc9cP1TmH/su410h8QlZ7SxmqWSBf Q7P/9cFwadY29/gnzR/k3aeUmp4cYqfpToB3sapMDBaZFrKuTCdG0mJg+YVbPn99 pjGaCdKDRIgemM87iOMSa33RKtte+U6rJ4xtJbn2NnfgNYtnuNlyP0UfaEl3PGdg anyYTJ29MHqTHR1EwRz1/KJLFZhoww4lIM4jrUByjYmYYM2xSPHcYSQDwFgn0hKO PGDaGiePHvqwJYMVK2upe54q1tcJGtLpgfa1AORJAI4d09U3QMgvE9Aje46IZQHi Rt6wxq4wRLxiHZGmynY3napJ9xfilV9gPaMxmRkhbz6cUTnfbX6MJBkmw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudejhedgheegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdlfeehmdenucfjughrpeffhf fvvefukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghq uhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvg hrnhepteelieefudffhffhtdetleeggeegfffhkeeuveetiefgudduvedutefggeeivdej necuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitg hhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 16 Sep 2023 21:58:59 -0400 (EDT) Date: Sun, 17 Sep 2023 10:58:56 +0900 From: Michael Paquier To: David Rowley Cc: Jay , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18108: server process was terminated by signal 11: Segmentation fault Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="cta/td2TfF7j79Ni" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --cta/td2TfF7j79Ni Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Sep 15, 2023 at 10:19:41PM +1200, David Rowley wrote: > On Fri, 15 Sept 2023 at 22:11, Jay wrote: >> >> I reproduced the operation and got this stack trace: >> >> Program received signal SIGSEGV, Segmentation fault. >> >> 0x00007efe187b4598 in __memcpy_ssse3_back () from /lib64/libc.so.6 >> >> Continuing. >=20 > Please send the output of: bt full A few more things. The bug report refers to 15.2. Please note that there have been a few fixes in the area of MERGE in 15.3, while the latest minor version of 15.X released is 15.4. So could you update to 15.4 and check if your problem happens again when running this version? Another thing that would save a lot of time for all of us would be to provide a self-contained test case, with a minimal schema for the test case involved, as there could be things related to the table's schema itself that could influence the issue, say indexes, foreign keys, etc. If you send such a test case, you'd better make sure that any sensitive data is obfuscated. -- Michael --cta/td2TfF7j79Ni Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmUGXWAACgkQnvQgOdby QH0rHxAAn6CT2B8RZayrmfBW85WWCjYpaNDGnJFEvbNvbMA/OVfmKmUyGviGvnkM EdtERNnMW/8h1qhtmRKeDIkQzM8KiQtVtveXElB2gBQhPnNTiOOyQzzQxPbDhL5C mNfMF7N3nFhJwDbSMcdUAjyLGK4oGXLrNdxQZDbyl6JuWbJRzQUb6PwHYBDL/D8q K8ujfL5N1zSTHBsw/RxnSpiHmfHiS4n1Bzua2LuREJUa/sUUP5RMqJw+L8pFFrPF x0hkMjrsMgYWQGZmh1L/g5t5DjWCkJnBEUwd2AtUoQ3A+Z+NJx9kUiWeBXaXRgzv n1zGZHoZWb6U+bxyXGBtaJZS8wJvYUUA6TcEBVGyvs33Se5x8xewdrIq6MKjZT3w 0/iwIuJvdI1h4MXARBiNKCS5GVqr/LHx4ZSz0UvmVgeX/1o0GcOvDSqzMFCvyqL8 umXgu9XEQwSHmYsUtWKTxekx6VcQ+lUnuOF0H/IAlzaLl4YB2rQTMD08d+Ko0hbz Bm4Nl+oMrkXyGoVcJ99JvxrsyMFnYEcMyO6s6kAEgllwQFMEXYOCvIIcP1h7Kh2A Wal1d1m2u7xN0x+5GcgTaZL4JKUo1OfwTRVuZcYWOvP63XiRm6Ghj+1k3FPUwCHW 4SDccHOTVwMLSj/mBbOFZyWEGEjYxSvUJk/pk2wZIey+uMd0qHs= =WFq6 -----END PGP SIGNATURE----- --cta/td2TfF7j79Ni--