Re: cache lookup failed for function 1 on fmgr_info_cxt_security,fmgr.c:184

On Tue, 2019-04-23 at 09:15 +0700, Soni wrote:
> I install the contrib module from the postgres repo using yum
> install.
> creating extension run as postgres superuser.
> 
> Thanks,
> Soni
> 

1) Is there a uuid-ossp.control file sitting in the $SHAREDIR/extension
path?

2) Does its name exist in pg_available_extensions?

3) Is there a uuid-ossp.so in the lib path?

My 2 cents.

Cheers
Rob



> On 22/04/2019 21:05, Adrian Klaver wrote:
> > On 4/21/19 9:14 PM, Soni wrote:
> > > Hello All,
> > > 
> > > CentOS Linux release 7.5.1804 (Core)
> > > Postgres 10.7.
> > > 
> > > When "create extension "uuid-ossp"", I got :
> > > 2019-04-22 02:41:53.323 UTC [10305] XX000ERROR:  XX000: cache
> > > lookup 
> > > failed for function 1
> > > 2019-04-22 02:41:53.323 UTC [10305] XX000LOCATION: 
> > > fmgr_info_cxt_security, fmgr.c:184
> > > 2019-04-22 02:41:53.323 UTC [10305] XX000STATEMENT:  create
> > > extension 
> > > "uuid-ossp" ;
> > > I tried reinstall contrib module and even all postgres component,
> > > but 
> > > still no luck.
> > > Try restarting the server also but no luck.
> > > Any idea how to resolve this ?
> > 
> > How and where are you installing Postgres and -contrib from?
> > 
> > Is the user you are running CREATE EXTENSION a superuser?
> > 
> > > Thanks,
> > > Soni
> > > 
> > > 
> > > 
> 
>