pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Matt Gibbins <matt_gibbins@fastmail.com.au>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Segmentation fault when running queries in sequence
Date: Sun, 24 Sep 2023 09:39:59 +1000
Message-ID: <a1ca0600-4dd5-49c7-aad0-24b6b4fcd410@fastmail.com.au> (raw)
In-Reply-To: <1282819.1695479196@sss.pgh.pa.us>
References: <728d1797-efdd-4298-8ab2-042a28ddaae2@fastmail.com.au>
	<1282819.1695479196@sss.pgh.pa.us>

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.

view thread (10+ messages)  latest in thread

Message-ID: <a1ca0600-4dd5-49c7-aad0-24b6b4fcd410@fastmail.com.au>
Permalink:  ../a1ca0600-4dd5-49c7-aad0-24b6b4fcd410@fastmail.com.au/
Also on:    postgresql.org/message-id/a1ca0600-4dd5-49c7-aad0-24b6b4fcd410@fastmail.com.au

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: matt_gibbins@fastmail.com.au, tgl@sss.pgh.pa.us, pgsql-admin@lists.postgresql.org
  Subject: Re: Segmentation fault when running queries in sequence
  In-Reply-To: <a1ca0600-4dd5-49c7-aad0-24b6b4fcd410@fastmail.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox