Re: Re: Re: Re: Re: Bug: ERROR: invalid cache ID: 42 CONTEXT: parallel worker

On Mon, Aug 27, 2018 at 6:07 PM jimmy <mpokky(at)126(dot)com> wrote:
> Let explain it.When I use postgresql-10.4-1-linux-x64.run to install.
> There does not use source code to compile, and make , make install. It is like a windows program. I just click next step button.
> The database was installed from the ui interface step by step.

Hi Jimmy,

Just want to double check something: are you sure you're using
oracle_fdw 2.0.0? It seems that the earlier versions suffered from a
problem with exactly the symptom you describe (except the error said
41 instead of 42, but that's expected because the enumerator values
moved):

https://www.postgresql.org/message-id/11960.1511116873%40sss.pgh.pa.us

But that was fixed here:

https://github.com/laurenz/oracle_fdw/commit/4accfebb33c316d71da73d341dac796df813638c

The problem was that it tried to access the system caches from
_PG_init(). It wouldn't matter if you were querying an oracle_fdw
table or not, it'd only matter if that library had been loaded in the
leader process, because that would cause the parallel workers to load
it, run _PG_init(), and blow up.

--
Thomas Munro
http://www.enterprisedb.com