Getting "invalid cache ID: 42" in pg10.5

From: <pcsuccess(at)sina(dot)com>
To: "pgsql-bugs" <pgsql-bugs(at)postgresql(dot)org>
Subject: Getting "invalid cache ID: 42" in pg10.5
Date: 2018-09-20 07:35:02
Message-ID: 20180920073502.8084D4140099@webmail.sinamail.sina.com.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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: 42CONTEXT: parallel worker
the table data count 606333
report=> \dx List of installed extensions Name | Version | Schema | Description ------------+---------+------------+----------------------------------------------------------------------------------- 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 database (Sybase or Microsoft SQL Server)(4 rows)
It's only happening occasionally (on a not very busy system).
Many thanks

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-09-20 07:37:50 BUG #15392: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <title>500 Internal Server Error</title> <h1
Previous Message Thomas Munro 2018-09-20 02:25:36 Re: BUG #15350: Getting invalid cache ID: 11 Errors