Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lZa6X-0005AH-8S for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Apr 2021 14:14:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lZa6W-0007tE-6h for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Apr 2021 14:14:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lZa6W-0007t7-11 for pgsql-bugs@lists.postgresql.org; Thu, 22 Apr 2021 14:14:52 +0000 Received: from mail-ed1-x529.google.com ([2a00:1450:4864:20::529]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lZa6T-0004Od-CX for pgsql-bugs@lists.postgresql.org; Thu, 22 Apr 2021 14:14:51 +0000 Received: by mail-ed1-x529.google.com with SMTP id g17so52972012edm.6 for ; Thu, 22 Apr 2021 07:14:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=9RGuWQnQVxc6a816siJZuoBYCyCMeyO88ppi0A8gPVU=; b=bEPaZ8Luzp+hcqhX5nCEkSemozDD1gXeD02q9ef5pIqJg3kOeegAIPGLFNSCBGEUaK KLCDEA/59tjKSwgP16fG/CDXcgaU6SzLn2Pr6L9OzUup3TG0vphZ50N/3IQOsLOOIULt u4ulFx9oeQmjzZSdNfIS/HFWQER0tlL33JoUCZ4GDjSCMF5UzIFOpy1Z4LoW4twzvNuf nNJUOrJELIZuwDf5LMU78k5NDw16YKxywB9f0E6PK3D+zcEIK293fnTj5kGjPQAitRwY EizteiV/zEARY3Lwy7MFxYyW1TE25HVaBRFh4i3NVVuWu0TgylnLTDhgzXM5b3ED8lSW J0Iw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=9RGuWQnQVxc6a816siJZuoBYCyCMeyO88ppi0A8gPVU=; b=j/UM4/MFnE5/RowvYI7DEFF6E1KLUZV7Gh7eL1KjEamkFscRtbCdTxXRQifXFypoGC Kq9NvBbkas6UlLf4Uu2O0h0ncpQizkZIsdaSdV7VUHmy3enUd8W5UhbrBlV0ACucjQCK FmgAVvlXMrMydzd1+DF4ylBahA5x8/UvhTspqvImV7PXHheVKbslEJzQiK0+rXN3xAkH j0qDmJ0emJjcDV8ka77IGhrPBzRJ7URxbeKYPhcDNFJi2sY7SY3UynrJIBo9lYgs5GC6 +0i26GXo14ntQLN8ehYByaug05mRXefIlUG0CfBAarUYre5/keco2Psrk8pU0bx3rPao 8cwA== X-Gm-Message-State: AOAM532ykfD3Gb86rl5QTtJ6/a3LRIuac1oCGpDfV+zh8PMpWO8ykU0Z x3yN32Qa1z2d9uhz9iJo/JP6FOgz9h1QLw== X-Google-Smtp-Source: ABdhPJx8RkNtPeROKUhTSnXJ06+TF8EpxeTjqQMCFO6vbfPDvG5xgr0nBCeMgAcX94DFxImEcZAUHg== X-Received: by 2002:a50:f696:: with SMTP id d22mr4165565edn.320.1619100887881; Thu, 22 Apr 2021 07:14:47 -0700 (PDT) Received: from [192.168.178.48] ([212.71.9.13]) by smtp.gmail.com with ESMTPSA id cn10sm2229276edb.28.2021.04.22.07.14.47 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 22 Apr 2021 07:14:47 -0700 (PDT) Subject: Re: BUG #16976: server crash when deleting via a trigger on a foreign table To: Tom Lane Cc: Michael Paquier , pgsql-bugs@lists.postgresql.org References: <16976-abe0cb88252bc02e@postgresql.org> <756273.1619012414@sss.pgh.pa.us> <813ebc08-8f81-4efe-a5f2-caac938b7741@gmail.com> <821fb923-aaf5-ee3f-21d2-17158035dc64@gmail.com> <953012.1619099429@sss.pgh.pa.us> From: Herwig Goemans Message-ID: <375c2333-4baf-1eea-9544-a4a9e6e408da@gmail.com> Date: Thu, 22 Apr 2021 16:14:47 +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: 7bit Content-Language: nl-BE List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Via wetrasnfer: https://we.tl/t-w3sPuA29Pu core dump file On 22/04/2021 15:50, Tom Lane wrote: > Herwig Goemans 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