hi ,
I had met a segment fault problem in PostgreSQL 12.1.And it happened
randomly,I could not use the query to repeat the segment fault.
PostgreSQL 12.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1
20180303 (Red Hat 7.3.1-5), 64-bit
Connection logged as below:
2019-12-26 07:26:56.133
CST,,,187480,"172.17.12.216:38272",5e03f040.2dc58,1,"",2019-12-26
07:26:56 CST,,0,LOG,00000,"connection received: host=172.17.12.216
port=38272",,,,,,,,"BackendInitialize, postmaster.c:4296",""
2019-12-26 07:26:56.134
CST,"logdev","dpos1",187480,"172.17.12.216:38272",5e03f040.2dc58,2,"authentication",2019-12-26
07:26:56 CST,4/59649,0,LOG,00000,"connection authorized: user=logdev
database=dpos1",,,,,,,,"PerformAuthentication, postinit.c:303",""
2019-12-26 07:26:56.283
CST,"logdev","dpos1",187480,"172.17.12.216:38272",5e03f040.2dc58,3,"SELECT",2019-12-26
07:26:56 CST,4/59654,0,ERROR,XX000,"cache lookup failed for type 0",,,,,,"
WITH pg_source AS (SELECT
""public"".""dpos_pmp_activityexposure_prod"".* FROM
""public"".""dpos_pmp_activityexposure_prod"" WHERE
""public"".""dpos_pmp_activityexposure_prod"".""sale_id"" LIKE
'%01d93294-bf06-412e-b09b-fa6c3ee56168%'::unknown ) SELECT null AS
total_result_set, pg_catalog.count(_postgrest_t) AS page_total,
array[]::text[] AS header, coalesce(json_agg(_postgrest_t),
'[]')::character varying AS body
FROM ( SELECT * FROM pg_source) _postgrest_t
",,"getBaseTypeAndTypmod, lsyscache.c:2328","app - 172.17.12.216:41240
The query was generated by postgrest(version 5.2.0).
WITH pg_source AS (
SELECT
public.dpos_pmp_activityexposure_prod.*
FROM
public.dpos_pmp_activityexposure_prod
WHERE
public.dpos_pmp_activityexposure_prod.sale_id LIKE
'%01d93294-bf06-412e-b09b-fa6c3ee56168%' :: unknown
)
SELECT
null AS total_result_set,
pg_catalog.count(_postgrest_t) AS page_total,
array[] :: text[] AS header,
coalesce(
json_agg(_postgrest_t),
'[]'
):: character varying AS body
FROM
(
SELECT
*
FROM
pg_source
) _postgrest_t
The backtrace in core dump file was:
gdb -q -c core.102993 /usr/local/pgsql-12/bin/postgres
Reading symbols from /usr/local/pgsql-12/bin/postgres...(no debugging
symbols found)...done.
[New LWP 102993]
Core was generated by `postgres: logdev dpos1 172.17.12.216(59568) S'.
Program terminated with signal 11, Segmentation fault.
#0 0x0000000000490688 in FreeTupleDesc ()
(gdb) bt
#0 0x0000000000490688 in FreeTupleDesc ()
#1 0x0000000000872c68 in ResourceOwnerRememberCatCacheListRef ()
#2 0x00000000009c3280 in __func__.10906 ()
#3 0x0000000002507520 in ?? ()
#4 0x00000001024e4f80 in ?? ()
#5 0x0000000002518b48 in ?? ()
#6 0x0000000000000000 in ?? ()