BUG #18333: Postgres is crashing if we have special character in the query
От | PG Bug reporting form |
---|---|
Тема | BUG #18333: Postgres is crashing if we have special character in the query |
Дата | |
Msg-id | 18333-8bd5cc3619b15618@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #18333: Postgres is crashing if we have special character in the query
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 18333 Logged by: Sujeet Swaminath Email address: sujeet.cha@gmail.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
В списке pgsql-bugs по дате отправления: