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 10:46:25 +1000
Message-ID: <94eaab7c-b764-418e-a623-c6b4911f4e32@fastmail.com.au> (raw)
In-Reply-To: <1418006.1695513406@sss.pgh.pa.us>
References: <728d1797-efdd-4298-8ab2-042a28ddaae2@fastmail.com.au>
	<1282819.1695479196@sss.pgh.pa.us>
	<a1ca0600-4dd5-49c7-aad0-24b6b4fcd410@fastmail.com.au>
	<1418006.1695513406@sss.pgh.pa.us>

On 24/9/23 09:56, Tom Lane wrote:
> Matt Gibbins<matt_gibbins@fastmail.com.au>  writes:
>> When I launch gdb for stack trace on the server the process hangs.
> If you mean you're attaching gdb to the active server process, yes
> that would stop execution.  You could just say "continue" and
> wait for the segfault to occur.
>
> 			regards, tom lane

Tom

Thanks for that

I launched gdb on the server with sudo gdp -p <port>.

Launched the client on the remote connection then executed continue in 
the gdb prompt on the server.

Initial response

Continuing.

Program received signal SIGUSR1, User defined signal 1.

I executed continue and the gdb reported '[Detaching after fork from 
child process 2790431]' for several sequences and the remote process 
then crashed.

No further information available other than 'Detaching after fork...'.

Regards

Matt.

view thread (10+ messages)  latest in thread

Message-ID: <94eaab7c-b764-418e-a623-c6b4911f4e32@fastmail.com.au>
Permalink:  ../94eaab7c-b764-418e-a623-c6b4911f4e32@fastmail.com.au/
Also on:    postgresql.org/message-id/94eaab7c-b764-418e-a623-c6b4911f4e32@fastmail.com.au

copy link · copy postgr.es

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: <94eaab7c-b764-418e-a623-c6b4911f4e32@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