From: Michael Paquier <michael@paquier.xyz>
To: sujeet.cha@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18333: Postgres is crashing if we have special character in the query
Date: Tue, 6 Feb 2024 10:32:25 +0900
Message-ID: <ZcGMKdCN7D4UeB30@paquier.xyz> (raw)
In-Reply-To: <18333-8bd5cc3619b15618@postgresql.org>
References: <18333-8bd5cc3619b15618@postgresql.org>
On Mon, Feb 05, 2024 at 10:30:33AM +0000, PG Bug reporting form wrote:
> I have installed Postgres-14.10 and when executing the below query, the
> postgres crashes. but the same query work well with PostgreSQL-14-9.
> I have a crash dump, but not sure, how can I attach it here.
>
> 2024-02-05 06:08:53.936 GMT [1680576] LOG: server process (PID 2627861) was
> terminated by signal 11: Segmentation fault
> 2024-02-05 06:08:53.936 GMT [1680576] DETAIL: Failed process was running:
> SELECT DISTINCT badsql.id_code,badsql.id_nr FROM badsql LEFT OUTER JOIN
> newsql on badsql.id_nr = newsql.id_nr and badsql.vk_ek%2=newsql.ku_vk_ek;
It is going to be hard to say what's wrong without more details, like
a backtrace, or even better a self-contained SQL sequence that makes a
problem reproducible. 14.11 is planned for this week, so you may want
to give it a try and double-check if your problem is going away:
https://www.postgresql.org/developer/roadmap/
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
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-bugs@postgresql.org
Cc: michael@paquier.xyz, sujeet.cha@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18333: Postgres is crashing if we have special character in the query
In-Reply-To: <ZcGMKdCN7D4UeB30@paquier.xyz>
* 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