Re: BUG #14581: invalid cache ID: 41 CONTEXT: parallel worker

stepya@ukr.net wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      14581
> Logged by:          Stepan Yankevych
> Email address:      stepya@ukr.net
> PostgreSQL version: 9.6.2
> Operating system:   RedHat
> Description:        
> 
> Time to time i have invalid cache ID: 41 while running simple query with
> parallelism.
> for example 
> select count(1) from client_order where date_id =  20170301;
> Crashes with (see error log)  
> 
> < 2017-03-07 08:57:45.312 EST >ERROR: invalid cache ID: 41 
> < 2017-03-07 08:57:45.312 EST >ERROR: invalid cache ID: 41 
> < 2017-03-07 08:57:45.312 EST >ERROR: invalid cache ID: 41 
> < 2017-03-07 08:57:45.312 EST >ERROR: invalid cache ID: 41 
> < 2017-03-07 08:57:45.312 EST >ERROR: invalid cache ID: 41 
> < 2017-03-07 08:57:45.312 EST [unknown] SELECT>ERROR: invalid cache ID: 41
> 
> < 2017-03-07 08:57:45.312 EST [unknown] SELECT>CONTEXT: parallel worker 
> < 2017-03-07 08:57:45.312 EST [unknown] SELECT>STATEMENT: select count(1) 

Could it be that the oracle_fdw extension was loaded?

There was a bug reported yesterday that would explain this error:
https://github.com/laurenz/oracle_fdw/issues/215

If oracle_fdw is involved, the latest commit should fix the problem.

Yours,
Laurenz Albe