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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qkCEU-00DVNE-BB
	for pgsql-admin@arkaria.postgresql.org; Sat, 23 Sep 2023 23:40:18 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qkCES-00394a-Kd
	for pgsql-admin@arkaria.postgresql.org; Sat, 23 Sep 2023 23:40:16 +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 <matt_gibbins@fastmail.com.au>)
	id 1qkCER-00393M-Cm
	for pgsql-admin@lists.postgresql.org; Sat, 23 Sep 2023 23:40:16 +0000
Received: from out3-smtp.messagingengine.com ([66.111.4.27])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <matt_gibbins@fastmail.com.au>)
	id 1qkCEJ-006H9p-6F
	for pgsql-admin@lists.postgresql.org; Sat, 23 Sep 2023 23:40:13 +0000
Received: from compute3.internal (compute3.nyi.internal [10.202.2.43])
	by mailout.nyi.internal (Postfix) with ESMTP id 3DE7C5C01BA;
	Sat, 23 Sep 2023 19:40:05 -0400 (EDT)
Received: from mailfrontend2 ([10.202.2.163])
  by compute3.internal (MEProxy); Sat, 23 Sep 2023 19:40:05 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fastmail.com.au;
	 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=1695512405; x=
	1695598805; bh=lqW1dyZwhz5hfL5TYa8w4JlJB5s03OZoHoEq9e0ZMfM=; b=F
	a33eFZM5lExHiX+XVgGzTNeIVpmuXMgVdQXlwumEPRXWLIfBxnM9GpNeZ5Hds0v/
	frGfiQ4GjxbBw/QhpEQhRyToTyI6EwsgQv6myw2o8K8SbcM+Rvdn9j/oSc3p2pH6
	pvogVKrzDXYe2iZu2PCxWRjXCtp5Qra2uunLfcEYLDM0AjSUkeRkDmA1+xOw9Ma8
	vxS3iig8HDVo9Qjj5SHokdEHSTPCJ5bd65vuZdi9UZM0xioGrHYdhHMbrRVGDcbI
	udmUAZkf89u1ubWi2mb9ZD4mJt+OwYo0IMTc9a8WnJDdLxn5+Ni90Rh9w+VTXgua
	u5ZZEIRobGkebf2fUimew==
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=1695512405; x=1695598805; bh=lqW1dyZwhz5hf
	L5TYa8w4JlJB5s03OZoHoEq9e0ZMfM=; b=X860Wtothx1PnfKfboFV+l3terYJN
	T4C3EJpDhusI2PQHHRUUSx4alCYFQ6UpsVufyMshUTpnyJyyHN1hXqbfv+lYJX0S
	+M2Tf5z7Lqqzav83yJxsKYqZPxWA5RBNRiHdz6FEer8npOFh7WSei5djck38kJMl
	6WdVsI168rd2nxFLYQUTBiYpMl8ElulpNnRO4mEyzd2T7cAe5gPUKLUigTIrJwdy
	XWPNf4D7DcoJg9iajMaqMghsOHNs89Rq2rRBjeqiuh4ATVkmMlsmIIPLC+Tyh+B3
	Gvb9TogzFPgABlEiDLrHWiduklXXseSo49FnHFubwyfic4Bfy6r2O6uZg==
X-ME-Sender: <xms:VHcPZeErsmid-GK_a-qTWe_aVXOZ9jRWqg9BjfR1aPGZJpNj0akmzg>
    <xme:VHcPZfXwqoCfrBhDFz9s506qDJJKE27VkDrCV5Xf5JAEQVjzYEkO3ALQ3jIVagWZX
    iQtKLRu4e49hidGoxs>
X-ME-Received: 
 <xmr:VHcPZYIOgeyd9l_ezbVxPP4X6jddDkgYlU5KF0tXrNXiq2TcVmNarAB0W5RIp-oZcuh9VG7h6NGZ0X3iAm9dxVmBDrI-d4w248Y>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgedviedrudeluddgvdehucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucgoufhushhpvggtthffohhmrghinhculdegledmne
    cujfgurheptgfkffggfgfuvfevfhfhjgesrgdtreertddvjeenucfhrhhomhepofgrthht
    ucfiihgssghinhhsuceomhgrthhtpghgihgssghinhhssehfrghsthhmrghilhdrtghomh
    drrghuqeenucggtffrrghtthgvrhhnpeeghfeigfeutdefgeeuvdeuvdelleelhfelgeei
    tdfhheeikedvhedtleffjeffgeenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorh
    hgpdguughnshdrnhgvthenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgr
    ihhlfhhrohhmpehmrghtthgpghhisggsihhnshesfhgrshhtmhgrihhlrdgtohhmrdgruh
X-ME-Proxy: <xmx:VHcPZYFltwap47AfAonAFE7PyYl_qZ-CJm9G0NsvKHAIKY_xFXSBsQ>
    <xmx:VHcPZUXid04wqqTFmjuOz9M1B10ZH3PDnn8wHR7G7j3u0zar3icDBw>
    <xmx:VHcPZbPx1wzUOVMOTxkCUnrzcUO5tFscDNFUqITguUqPL-l_-hYlXg>
    <xmx:VXcPZde5vKMgfqRxyk22DRF0ni76c19jNAxqEO1CZ_o0eHJW8Yxy8Q>
Feedback-ID: i6d194797:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat,
 23 Sep 2023 19:40:03 -0400 (EDT)
Content-Type: multipart/alternative;
 boundary="------------xw0weMbuAA0u6Ry0REZGjRCP"
Message-ID: <a1ca0600-4dd5-49c7-aad0-24b6b4fcd410@fastmail.com.au>
Date: Sun, 24 Sep 2023 09:39:59 +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 <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@lists.postgresql.org
References: <728d1797-efdd-4298-8ab2-042a28ddaae2@fastmail.com.au>
 <1282819.1695479196@sss.pgh.pa.us>
From: Matt Gibbins <matt_gibbins@fastmail.com.au>
In-Reply-To: <1282819.1695479196@sss.pgh.pa.us>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/a1ca0600-4dd5-49c7-aad0-24b6b4fcd410%40fastmail.com.au>
Precedence: bulk

This is a multi-part message in MIME format.
--------------xw0weMbuAA0u6Ry0REZGjRCP
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

On 24/9/23 00:26, Tom Lane wrote:
> Matt Gibbins<matt_gibbins@fastmail.com.au>  writes:
>> Attached is the STDOUT messages showing the progress of the the process
>> to segmentation fault.
> Not a lot of information there.  Can you get a stack trace from
> the crash?
>
> https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
>
> Also, if you're not on the latest minor version of PG 15, first
> update and see if that resolves the problem.
>
> 			regards, tom lane

Tom

Thank you.

This is the extent of information I am able to obtain at the moment.

FYI the system is Linux canberramjg.ddns.net 6.1.0-12-amd64 #1 SMP 
PREEMPT_DYNAMIC Debian 6.1.52-1 (2023-09-07) x86_64 GNU/Linux

The Debian version Debian GNU/Linux 12 (bookworm)

The postgresql version installed is  15.4-2.pgdg120+1 which is the 
latest from the distro.

Have enabled stack trace for postgresql. Noticed an interesting problem 
with running the stack trace.

Of note my process is driven by remote execution of SQL queries via SSH 
tunnel.

When I launch gdb for stack trace on the server the process hangs.

Regards

Matt.

--------------xw0weMbuAA0u6Ry0REZGjRCP
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 24/9/23 00:26, Tom Lane wrote:<br>
    </div>
    <blockquote type="cite" cite="mid:1282819.1695479196@sss.pgh.pa.us">
      <pre class="moz-quote-pre" wrap="">Matt Gibbins <a class="moz-txt-link-rfc2396E" href="mailto:matt_gibbins@fastmail.com.au">&lt;matt_gibbins@fastmail.com.au&gt;</a> writes:
</pre>
      <blockquote type="cite">
        <pre class="moz-quote-pre" wrap="">Attached is the STDOUT messages showing the progress of the the process 
to segmentation fault.
</pre>
      </blockquote>
      <pre class="moz-quote-pre" wrap="">
Not a lot of information there.  Can you get a stack trace from
the crash?

<a class="moz-txt-link-freetext" href="https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend">https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend</a>

Also, if you're not on the latest minor version of PG 15, first
update and see if that resolves the problem.

			regards, tom lane
</pre>
    </blockquote>
    <p>Tom</p>
    <p>Thank you. <br>
    </p>
    <p>This is the extent of information I am able to obtain at the
      moment. <br>
    </p>
    FYI the system is Linux canberramjg.ddns.net 6.1.0-12-amd64 #1 SMP
    PREEMPT_DYNAMIC Debian 6.1.52-1 (2023-09-07) x86_64 GNU/Linux
    <p>The Debian version Debian GNU/Linux 12 (bookworm)<br>
    </p>
    <p>The postgresql version installed is  15.4-2.pgdg120+1 which is
      the latest from the distro.<br>
    </p>
    <p>Have enabled stack trace for postgresql. Noticed an interesting
      problem with running the stack trace. <br>
    </p>
    <p>Of note my process is driven by remote execution of SQL queries
      via SSH tunnel. <br>
    </p>
    <p>When I launch gdb for stack trace on the server the process
      hangs.</p>
    <p>Regards <br>
    </p>
    <p>Matt.<br>
    </p>
    <p>
      <style type="text/css">p { line-height: 115%; margin-bottom: 0.25cm; background: transparent }</style></p>
    <p>
      <style type="text/css">body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Liberation Sans"; font-size:x-small }a.comment-indicator:hover + comment { background:#ffd; position:absolute; display:block; border:1px solid black; padding:0.5em;  }a.comment-indicator { background:red; display:inline-block; border:1px solid black; width:0.5em; height:0.5em;  }comment { display:none;  }</style></p>
  </body>
</html>

--------------xw0weMbuAA0u6Ry0REZGjRCP--