From: Heinemann, Manfred (IMS) <HeinemannM@imsweb.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: RE: Segmentation fault with parallelism PG 10.4
Date: Tue, 12 Jun 2018 20:15:38 +0000
Message-ID: <8493b91fb47d432297fbd4d96b7cb553@THALASSA.omni.imsweb.com> (raw)
In-Reply-To: <1476.1528825515@sss.pgh.pa.us>
References: <8577044f0d2f4fe3919c53c2f7a642e5@THALASSA.omni.imsweb.com>
<1476.1528825515@sss.pgh.pa.us>
This is what I see in a stack trace
Program received signal SIGSEGV, Segmentation fault.
0x000000000084dcf3 in pglz_decompress ()
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, June 12, 2018 1:45 PM
To: Heinemann, Manfred (IMS) <HeinemannM@imsweb.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Segmentation fault with parallelism PG 10.4
"Heinemann, Manfred (IMS)" <HeinemannM@imsweb.com> writes:
> We allow some user querying against the database and a user wrote sql that would repeatedly cause a segmentation fault. We can't share the data but I will show what I can.
The info you've provided is not of much help, but if you could show a stack trace from the point of the segfault, that might narrow things down.
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 employee or agent of the addressee(s), please note that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender of the error.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: HeinemannM@imsweb.com, tgl@sss.pgh.pa.us, pgsql-admin@lists.postgresql.org
Subject: RE: Segmentation fault with parallelism PG 10.4
In-Reply-To: <8493b91fb47d432297fbd4d96b7cb553@THALASSA.omni.imsweb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox