Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fa3YI-0002KS-Ul for pgsql-admin@arkaria.postgresql.org; Mon, 02 Jul 2018 18:27:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fa3YH-0002I9-58 for pgsql-admin@arkaria.postgresql.org; Mon, 02 Jul 2018 18:27:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fa3YG-0002I0-U5 for pgsql-admin@lists.postgresql.org; Mon, 02 Jul 2018 18:27:52 +0000 Received: from util-st-02.imsweb.com ([204.132.58.65]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fa3YB-00032Q-75 for pgsql-admin@lists.postgresql.org; Mon, 02 Jul 2018 18:27:52 +0000 Received: from PAN.omni.imsweb.com (haproxy-st-02 [204.132.58.76]) by util-st-02.imsweb.com (Postfix) with ESMTP id A85F0E1744; Mon, 2 Jul 2018 14:27:44 -0400 (EDT) Received: from THALASSA.omni.imsweb.com (172.22.64.102) by PAN.omni.imsweb.com (172.22.64.64) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Mon, 2 Jul 2018 14:27:44 -0400 Received: from THALASSA.omni.imsweb.com ([172.22.64.102]) by THALASSA.omni.imsweb.com ([172.22.64.102]) with mapi id 15.00.1367.000; Mon, 2 Jul 2018 14:27:44 -0400 From: "Heinemann, Manfred (IMS)" To: Tom Lane CC: "pgsql-admin@lists.postgresql.org" Subject: RE: Segmentation fault with parallelism PG 10.4 Thread-Topic: Segmentation fault with parallelism PG 10.4 Thread-Index: AdQCcNQA4J0c19/+TWKIIympNZy4gwAJdHCAAAMk7pABTkewkAAJVhKAAowW+oA= Date: Mon, 2 Jul 2018 18:27:43 +0000 Message-ID: <0825ba4b6ed848cb9154b4e8794e6ada@THALASSA.omni.imsweb.com> References: <8577044f0d2f4fe3919c53c2f7a642e5@THALASSA.omni.imsweb.com> <1476.1528825515@sss.pgh.pa.us> <8493b91fb47d432297fbd4d96b7cb553@THALASSA.omni.imsweb.com> <44f8d9c203124535b497f2a79ceac59d@THALASSA.omni.imsweb.com> <21009.1529421245@sss.pgh.pa.us> In-Reply-To: <21009.1529421245@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [204.132.58.76] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Here is what I get for the stack trace, is it more helpful? Program received signal SIGSEGV, Segmentation fault. 0x000000000084dcb0 in pglz_decompress () #0 0x000000000084dcb0 in pglz_decompress () #1 0x00000000004b8d2f in toast_decompress_datum () #2 0x0000000000793ce0 in numeric_eq () #3 0x00000000005e68eb in ExecInterpExpr () #4 0x00000000005ef589 in ExecScan () #5 0x0000000000608784 in ExecNestLoop () #6 0x00000000005fc6b5 in ExecGather () #7 0x00000000005feb35 in ExecHashJoin () #8 0x00000000006086d4 in ExecNestLoop () #9 0x00000000005e9b02 in standard_ExecutorRun () #10 0x000000000071305b in PortalRunSelect () #11 0x00000000007142d1 in PortalRun () #12 0x000000000071038b in exec_simple_query () #13 0x0000000000711589 in PostgresMain () #14 0x0000000000476399 in ServerLoop () #15 0x00000000006a9acc in PostmasterMain () #16 0x000000000062b58c in main () Thanks, Manfred >"Heinemann, Manfred (IMS)" writes: >> Is this stack trace helpful at all? > >No, because it isn't actually a stack trace, just the top frame. See > >https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_= backend > >regards, tom lane ________________________________ Information in this e-mail may be confidential. It is intended only for the= addressee(s) identified above. If you are not the addressee(s), or an empl= oyee or agent of the addressee(s), please note that any dissemination, dist= ribution, or copying of this communication is strictly prohibited. If you h= ave received this e-mail in error, please notify the sender of the error.