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

stepya(at)ukr(dot)net wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14581
> Logged by: Stepan Yankevych
> Email address: stepya(at)ukr(dot)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