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 1qkFCd-00DeNn-6j for pgsql-admin@arkaria.postgresql.org; Sun, 24 Sep 2023 02:50:35 +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 1qkFCZ-004BEd-TZ for pgsql-admin@arkaria.postgresql.org; Sun, 24 Sep 2023 02:50:31 +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 1qkFCX-004BDw-UW for pgsql-admin@lists.postgresql.org; Sun, 24 Sep 2023 02:50:31 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qkFCR-007DqU-Li for pgsql-admin@lists.postgresql.org; Sun, 24 Sep 2023 02:50:29 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 042C13200960; Sat, 23 Sep 2023 22:50:19 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Sat, 23 Sep 2023 22:50:20 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fastmail.com.au; h=cc:cc:content-transfer-encoding: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=1695523819; x=1695610219; bh=53kbz4Wbyoc/F1DvYtnXH56Zo xfw1ZEzNb/uJML0R6k=; b=ZqHGGPPkXQp8LM1TzySppIvDY5oCigagYtcBwCsug Wt7OKpVk/lFiGhA0adjsKvEXXbX1pvnwPz0gsGRBuG++BtENWe8b2nGm9y5JPWS/ KUn+aGOf1LPjvbxuPo2MeCHXniuF9DouFn73XmSEwEhUZ9DeTkNI4zhCMrxgSlko qlq6w5w+RKQt14tL1HT0GhVGWr7lijt+UKEIR5jJQdaGhdYPysUJAOuBw7a4jedm iMLq46phscUrB7o/cNAUNFgzbLBsI78iR8GWUkITNLsxD1jOJuu7aw2mwqbEDmT8 N4uCVEOcY5GKJwS7e2+02fw32ZpS5exZ2NvL2vQ82a8Lg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :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= 1695523819; x=1695610219; bh=53kbz4Wbyoc/F1DvYtnXH56Zoxfw1ZEzNb/ uJML0R6k=; b=PUjIp3lvGMgI33vwfYs/TUbbGCZGiOHtIc9YQfcccUL9bKqjXpa rfBlZNuxb6M1FNIfVzj1d3RsNyJuft2bbVRCy8jQZGnmtOsZ2igU1cR5MdE3smH1 jJxq5/B4UAnD+2E66w2dqJ5Qnfd4ZIV/uF/bt6yyOJPp592eNonsOTQy4AEZ7GZN fOyytWDiMv5junpR+in/vTU69dNNoyi2qqLEK2CNGn1C3MK6kpKJ+r/uR2A2x5im BKhR4tigA0Ot1nLop/7vjc74OaDga6V+ExoftKwrxg6ufkcQbO8FZdic3dx/9aid s37fuQh3VRCSdpYX1M8IE9SqErKtQt/QbqA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudeluddgieegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefkffggfgfuvfevfhfhjggtgfesth ejredttddvjeenucfhrhhomhepofgrthhtucfiihgssghinhhsuceomhgrthhtpghgihgs sghinhhssehfrghsthhmrghilhdrtghomhdrrghuqeenucggtffrrghtthgvrhhnpeelue ehteeutefftddujeduueelhfektddtledvueehieeujeefffejgedtudfffeenucevlhhu shhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmrghtthgpghhisg gsihhnshesfhgrshhtmhgrihhlrdgtohhmrdgruh X-ME-Proxy: Feedback-ID: i6d194797:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 23 Sep 2023 22:50:17 -0400 (EDT) Message-ID: <4fbf8190-92f7-4272-8b71-3bc2f8029e71@fastmail.com.au> Date: Sun, 24 Sep 2023 12:50:14 +1000 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Segmentation fault when running queries in sequence Content-Language: en-AU To: Tom Lane Cc: pgsql-admin@lists.postgresql.org References: <728d1797-efdd-4298-8ab2-042a28ddaae2@fastmail.com.au> <1282819.1695479196@sss.pgh.pa.us> <1418006.1695513406@sss.pgh.pa.us> <94eaab7c-b764-418e-a623-c6b4911f4e32@fastmail.com.au> <1430983.1695516874@sss.pgh.pa.us> From: Matt Gibbins In-Reply-To: <1430983.1695516874@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 24/9/23 10:54, Tom Lane wrote: > Matt Gibbins writes: >> I executed continue and the gdb reported '[Detaching after fork from >> child process 2790431]' for several sequences and the remote process >> then crashed. > I think this means that you attached to the parent postmaster > process, not to the per-session child process where the crash > will occur. > > On the whole, attaching to a live server process is kind of the > hard way to do this anyhow. I'd recommend enabling saving of > core dump files and then gdb'ing the core file. That avoids > needing to identify in advance the process that is going to crash. > > regards, tom lane Tom Thank you for your patience. I have now created a core dump of the process. It is approximately 4G in size. Rather large for an email. As I am not familiar with core dump processing I require some further guidance. Matt.