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>
 <81647b1a-c841-f7d8-fe92-8f01d72e5482@gmail.com>
 <955623.1619100846@sss.pgh.pa.us>
From: Herwig Goemans <herwig.goemans@gmail.com>
Message-ID: <0621b422-77c6-7e15-691d-c581c6b8256c@gmail.com>
Date: Thu, 22 Apr 2021 16:22:17 +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: <955623.1619100846@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/0621b422-77c6-7e15-691d-c581c6b8256c%40gmail.com>
Precedence: bulk

Right,


Sorry I sent the file to you via wetransfer but you can ignore it.

Anyway


root@o-oltpmilieu03-UB-201906:~# gdb /usr/lib/postgresql/12/bin/postgres 
/home/local/VMM/h.goemans/_usr_lib_postgresql_12_bin_postgres.201.crash
GNU gdb (Ubuntu 8.1.1-0ubuntu1) 8.1.1
Copyright (C) 2018 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later 
<http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/>.
For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from /usr/lib/postgresql/12/bin/postgres...Reading 
symbols from 
/usr/lib/debug/.build-id/ec/40c5b4738ba1aef9fb39dfbbf928f1bbe57743.debug...done.
done.
"/home/local/VMM/h.goemans/_usr_lib_postgresql_12_bin_postgres.201.crash" 
is not a core dump: File format not recognized

It says the file is an ascii text file with very long lines...


I am lost (again)

Herwig

On 22/04/2021 16:14, Tom Lane wrote:
> Herwig Goemans <herwig.goemans@gmail.com> writes:
>>    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 ?
> We don't want the core file; it'd be useless without an exact copy of your
> postgres executables and system libraries.  What we want you to do is
> run gdb's "bt full" command on it and send us the output.
>
> 			regards, tom lane