Re: Segmentation fault when running queries in sequence

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matt Gibbins <matt_gibbins(at)fastmail(dot)com(dot)au>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Segmentation fault when running queries in sequence
Date: 2023-09-24 00:54:34
Message-ID: 1430983.1695516874@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Matt Gibbins <matt_gibbins(at)fastmail(dot)com(dot)au> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Matt Gibbins 2023-09-24 02:50:14 Re: Segmentation fault when running queries in sequence
Previous Message Matt Gibbins 2023-09-24 00:46:25 Re: Segmentation fault when running queries in sequence