Getting "invalid cache ID: 42" in pg10.5 - Mailing list pgsql-bugs

From
Subject Getting "invalid cache ID: 42" in pg10.5
Date
Msg-id 20180920073502.8084D4140099@webmail.sinamail.sina.com.cn
Whole thread Raw
Responses Re: Getting "invalid cache ID: 42" in pg10.5  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-bugs
PostgreSQL version: 10.5 
Operating system:   CentOS release 6.9 (Final)


Hi 

We're using 10.5 ,i get the error:
 report=> select count(1) from monitor_trade_detail where mernum_maps is not null;
ERROR:  invalid cache ID: 42
CONTEXT:  parallel worker

the table data count 606333

report=> \dx
                                             List of installed extensions
    Name    | Version |   Schema   |                                    Descri
ption                                    
------------+---------+------------+------------------------------------------
-----------------------------------------
 jsquery    | 1.1     | report     | data type for jsonb inspection
 oracle_fdw | 1.1     | report     | foreign data wrapper for Oracle access
 plpgsql    | 1.0     | pg_catalog | PL/pgSQL procedural language
 tds_fdw    | 1.0.8   | report     | Foreign data wrapper for querying a TDS d
atabase (Sybase or Microsoft SQL Server)
(4 rows)


It's only happening occasionally (on a not very busy system).

Many thanks 

pgsql-bugs by date:

Previous
From: Thomas Munro
Date:
Subject: Re: BUG #15350: Getting invalid cache ID: 11 Errors
Next
From: PG Bug reporting form
Date:
Subject: BUG #15392: 500 Internal Server Error