ERROR,XX000,"cache lookup failed for type 0"

From: tao jin <tonytao0505(at)outlook(dot)com>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: ERROR,XX000,"cache lookup failed for type 0"
Date: 2019-12-26 05:58:32
Message-ID: BYAPR06MB504767EEB45B5A2A71031F8FAA2B0@BYAPR06MB5047.namprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 ?? ()

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Langote 2019-12-26 08:00:34 Re: A row-level trigger on a partitioned table is not created on a sub-partition created later
Previous Message Dam 2019-12-26 02:59:19 Re:Re: BUG #16179: is it reasonable to callback pgss_post_parse_analyze or pg_hint_plan_post_parse_analyze ???