BUG #17227: segmentation fault with jsonb_to_recordset
От | PG Bug reporting form |
---|---|
Тема | BUG #17227: segmentation fault with jsonb_to_recordset |
Дата | |
Msg-id | 17227-5a28ed1512189fa4@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #17227: segmentation fault with jsonb_to_recordset
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 17227 Logged by: Bernd Dorn Email address: bernddorn@gmail.com PostgreSQL version: 14.0 Operating system: docker postgres:14 on osx Description: to reproduce : ``` docker run --name pg -p 5432:5432 --rm -e POSTGRES_PASSWORD=pw postgres:14 docker exec -ti pg psql --user postgres ``` run this query: ``` select * from ( select jsonb_path_query_array(module -> 'lectures', '$[*]') as lecture from unnest( array[$${ "lectures": [ { "id": "1" } ] }$$::jsonb]) as unnested_modules(module) ) as l, jsonb_to_recordset(l.lecture) as (id text) limit 1; ``` output in logs: ``` 2021-10-13 09:07:58.073 UTC [1] LOG: server process (PID 83) was terminated by signal 11: Segmentation fault 2021-10-13 09:07:58.073 UTC [1] DETAIL: Failed process was running: select * from ( select jsonb_path_query_array(module -> 'lectures', '$[*]') as lecture from unnest( array[$${ "lectures": [ { "id": "1" } ] }$$::jsonb]) as unnested_modules(module) ) as l, jsonb_to_recordset(l.lecture) as (id text) limit 1; 2021-10-13 09:07:58.073 UTC [1] LOG: terminating any other active server processes 2021-10-13 09:07:58.074 UTC [84] FATAL: the database system is in recovery mode 2021-10-13 09:07:58.076 UTC [1] LOG: all server processes terminated; reinitializing 2021-10-13 09:07:58.089 UTC [85] LOG: database system was interrupted; last known up at 2021-10-13 09:07:34 UTC 2021-10-13 09:07:58.180 UTC [85] LOG: database system was not properly shut down; automatic recovery in progress 2021-10-13 09:07:58.182 UTC [85] LOG: redo starts at 0/16FAB48 2021-10-13 09:07:58.182 UTC [85] LOG: invalid record length at 0/16FAB80: wanted 24, got 0 2021-10-13 09:07:58.182 UTC [85] LOG: redo done at 0/16FAB48 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2021-10-13 09:07:58.192 UTC [1] LOG: database system is ready to accept connections ```
В списке pgsql-bugs по дате отправления: