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 1kYaFB-000638-Px for pgsql-bugs@arkaria.postgresql.org; Fri, 30 Oct 2020 19:39:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kYaEf-000428-8t for pgsql-bugs@arkaria.postgresql.org; Fri, 30 Oct 2020 19:38:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kYaEf-00041u-3A for pgsql-bugs@lists.postgresql.org; Fri, 30 Oct 2020 19:38:53 +0000 Received: from mta97aws110.mxout.inova.com.br ([3.223.97.110] helo=mxhero01.a.inova.com.br) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kYaEZ-0003rU-ET for pgsql-bugs@lists.postgresql.org; Fri, 30 Oct 2020 19:38:52 +0000 Received: from ip-10-0-4-78.ec2.internal (localhost [127.0.0.1]) by mxhero01.a.inova.com.br (Postfix) with ESMTP id 4880C1CA2A0 for ; Fri, 30 Oct 2020 19:38:44 +0000 (UTC) Received: from corpmoutpolicyd01.a.inova.com.br (puppetmaster.a.inova.com.br [10.0.1.88]) by mxhero01.a.inova.com.br (Postfix) with ESMTP; Fri, 30 Oct 2020 19:38:44 +0000 (UTC) Received: from corpmoutpolicyd01.a.inova.com.br (localhost [127.0.0.1]) by corpmoutpolicyd01.a.inova.com.br (Postfix) with ESMTP id 34D9122096C; Fri, 30 Oct 2020 17:38:40 -0200 (BRST) Received: from corpmout01.a.inova.com.br (ip-10-0-1-125.ec2.internal [10.0.1.125]) by corpmoutpolicyd01.a.inova.com.br (Postfix) with ESMTP id 2B68FC10E5; Fri, 30 Oct 2020 17:38:40 -0200 (BRST) Received: from corpmbox02.a.inova.com.br (ip-10-0-4-158.ec2.internal [10.0.4.158]) by corpmout01.a.inova.com.br (Postfix) with ESMTP; Fri, 30 Oct 2020 16:38:40 -0300 (-03) Date: Fri, 30 Oct 2020 16:38:39 -0300 (BRT) From: luis.roberto@siscobra.com.br To: Tom Lane Cc: pgsql-bugs , "alan.formagi" Message-ID: <541187747.37582276.1604086719237.JavaMail.zimbra@siscobra.com.br> In-Reply-To: <102089.1604082122@sss.pgh.pa.us> References: <622580997.37108180.1604080457319.JavaMail.zimbra@siscobra.com.br> <102089.1604082122@sss.pgh.pa.us> Subject: Re: segfault with incremental sort MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_4e1e277b-3a37-46c1-b3bc-cd7f646bc6a4" X-Originating-IP: [10.0.1.247] X-Mailer: Zimbra 8.8.15_GA_3968 (ZimbraWebClient - GC86 (Win)/8.8.15_GA_3968) Thread-Topic: segfault with incremental sort Thread-Index: LqZKpHyzzSI2BNwbDPLymUgaFhdhfw== x-mxHero-Origin-Ip: /127.0.0.1:52588 X-mxHero-AttachmentBlock: rule=48;result=false List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=_4e1e277b-3a37-46c1-b3bc-cd7f646bc6a4 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit De: "Tom Lane" Para: "luis.roberto" Cc: "pgsql-bugs" , "alan.formagi" Enviadas: Sexta-feira, 30 de outubro de 2020 15:22:02 Assunto: Re: segfault with incremental sort luis.roberto@siscobra.com.br writes: > I'm running a query that is causing the server to segfault. Hm, can you get a stack trace from that? https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend regards, tom lane _____________________ Hi I'm not sure how to get the stack trace correctly.. following the instructions I only get the function names, but not files or line numbers... What can I do to get more helpful information? --=_4e1e277b-3a37-46c1-b3bc-cd7f646bc6a4 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
D= e: "Tom Lane" <tgl@sss.pgh.pa.us>
Para: "luis.roberto" = <luis.roberto@siscobra.com.br>
Cc: "pgsql-bugs" <pgsql-b= ugs@lists.postgresql.org>, "alan.formagi" <alan.formagi@siscobra.com.= br>
Enviadas: Sexta-feira, 30 de outubro de 2020 15:22:02
<= b>Assunto: Re: segfault with incremental sort

<= div data-marker=3D"__QUOTED_TEXT__">luis.roberto@siscobra.com.br writes:> I'm running a query that is causing the server to segfault.

H= m, can you get a stack trace from that?

https://wiki.postgresql.org/= wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend

  &n= bsp;            = ;         regards, tom lane
_____________________

Hi

=
I'm not sure how to get the stack trace co= rrectly.. following the instructions I only get  the function names, b= ut not files or line numbers...

What can I do to= get more helpful information?
--=_4e1e277b-3a37-46c1-b3bc-cd7f646bc6a4--