Subject: Re: BUG #16976: server crash when deleting via a trigger on a foreign
 table
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Michael Paquier <michael@paquier.xyz>, pgsql-bugs@lists.postgresql.org
References: <16976-abe0cb88252bc02e@postgresql.org>
 <756273.1619012414@sss.pgh.pa.us>
 <813ebc08-8f81-4efe-a5f2-caac938b7741@gmail.com>
 <YIFVZRBUajOLrJvc@paquier.xyz>
 <821fb923-aaf5-ee3f-21d2-17158035dc64@gmail.com>
 <953012.1619099429@sss.pgh.pa.us>
From: Herwig Goemans <herwig.goemans@gmail.com>
Message-ID: <81647b1a-c841-f7d8-fe92-8f01d72e5482@gmail.com>
Date: Thu, 22 Apr 2021 16:10:36 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.7.1
MIME-Version: 1.0
In-Reply-To: <953012.1619099429@sss.pgh.pa.us>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: nl-BE
Archived-At: 
 <https://www.postgresql.org/message-id/81647b1a-c841-f7d8-fe92-8f01d72e5482%40gmail.com>
Precedence: bulk

Ok,


  I have a core dump file, It is not generated by a test of me, but that 
does not matter, the sql statement was launched by a colleage of mine 
and it generated a core dump.

The file is 50MB (compressed) how do I get it to you ?


Herwig

On 22/04/2021 15:50, Tom Lane wrote:
> Herwig Goemans <herwig.goemans@gmail.com> writes:
>> I think I have to get a stacktrace of the postgres server process , not
>> of psql but I do not how to do that.
> Right.  The wiki page I pointed you to upthread has recipes for that.
>
> https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
>
> 			regards, tom lane