BUG #18333: Postgres is crashing if we have special character in the query

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: sujeet(dot)cha(at)gmail(dot)com
Subject: BUG #18333: Postgres is crashing if we have special character in the query
Date: 2024-02-05 10:30:33
Message-ID: 18333-8bd5cc3619b15618@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18333
Logged by: Sujeet Swaminath
Email address: sujeet(dot)cha(at)gmail(dot)com
PostgreSQL version: 14.10
Operating system: RHEL9.3
Description:

Hi,

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;
2024-02-05 06:08:53.936 GMT [1680576] LOG: terminating any other active
server processes
2024-02-05 06:08:53.937 GMT [2627876] FATAL: the database system is in
recovery mode
2024-02-05 06:08:53.951 GMT [1680576] LOG: all server processes terminated;
reinitializing
2024-02-05 06:08:54.475 GMT [2627879] LOG: database system was interrupted;
last known up at 2024-02-04 23:05:12 GMT
2024-02-05 06:08:54.506 GMT [2627879] LOG: database system was not properly
shut down; automatic recovery in progress
2024-02-05 06:08:54.506 GMT [2627879] LOG: redo starts at 17/B72551A0
2024-02-05 06:08:54.506 GMT [2627879] LOG: invalid record length at
17/B7255288: wanted 24, got 0
2024-02-05 06:08:54.506 GMT [2627879] LOG: redo done at 17/B7255250 system
usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-02-05 06:08:54.577 GMT [1680576] LOG: database system is ready to
accept connections
2024-02-05 06:14:55.063 GMT [1680576] LOG: received fast shutdown request
2024-02-05 06:14:55.064 GMT [1680576] LOG: aborting any active
transactions
2024-02-05 06:14:55.065 GMT [1680576] LOG: background worker "logical
replication launcher" (PID 2627885) exited with exit code 1
2024-02-05 06:14:55.079 GMT [2627880] LOG: shutting down
2024-02-05 06:14:55.208 GMT [1680576] LOG: database system is shut down

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2024-02-05 10:58:37 BUG #18334: Segfault when running a query with parallel workers
Previous Message PG Bug reporting form 2024-02-05 09:54:01 BUG #18332: The conditional lock cannot be granted even if the process holds a stronger lock