Feedback-ID: i6d194797:Fastmail
Content-Type: multipart/alternative;
 boundary="------------zyM4S0Lxb0SaL2ViUyDjFu0e"
Message-ID: <94eaab7c-b764-418e-a623-c6b4911f4e32@fastmail.com.au>
Date: Sun, 24 Sep 2023 10:46:25 +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>
 <a1ca0600-4dd5-49c7-aad0-24b6b4fcd410@fastmail.com.au>
 <1418006.1695513406@sss.pgh.pa.us>
From: Matt Gibbins <matt_gibbins@fastmail.com.au>
In-Reply-To: <1418006.1695513406@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/94eaab7c-b764-418e-a623-c6b4911f4e32%40fastmail.com.au>
Precedence: bulk

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

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.


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

<!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 09:56, Tom Lane wrote:<br>
    </div>
    <blockquote type="cite" cite="mid:1418006.1695513406@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="">When I launch gdb for stack trace on the server the process hangs.
</pre>
      </blockquote>
      <pre class="moz-quote-pre" wrap="">
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
</pre>
    </blockquote>
    <p>Tom</p>
    <p>Thanks for that</p>
    <p>I launched gdb on the server with sudo gdp -p &lt;port&gt;.</p>
    <p>Launched the client on the remote connection then executed
      continue in the gdb prompt on the server.</p>
    <p>Initial response</p>
    <table width="459" height="81" cellspacing="2" cellpadding="2"
      border="1">
      <tbody>
        <tr>
          <td valign="top">Continuing.<br>
            <br>
            Program received signal SIGUSR1, User defined signal 1.<br>
          </td>
        </tr>
      </tbody>
    </table>
    <p>I executed continue and the gdb reported '[Detaching after fork
      from child process 2790431]' for several sequences and the remote
      process then crashed.</p>
    <p>No further information available other than 'Detaching after
      fork...'.</p>
    <p>Regards</p>
    <p>Matt.<br>
    </p>
    <p><br>
    </p>
    <p><br>
    </p>
  </body>
</html>

--------------zyM4S0Lxb0SaL2ViUyDjFu0e--