[pgpool-general: 407] Re: pgpool_regclass error

[Lazaro Ruben Garcia Martinez]

It seems to me that pgpool_regclass function is not installed in the database where pgpool connects. Is the function installed in all databases? 

Regards. 

----- Mensaje original -----

> Yes, it's installed in both servers. The version is pgpool-II-3.1.2.

> Regards.

> El 03/05/12 17:50, Lazaro Ruben Garcia Martinez escribió:
> > The pgpool_regclass function is installed in all servers?. What
> > version of pgpool-II are you using?
> 

> > Regards.
> 

> > ----- Mensaje original -----
> 

> > > Hi,
> > 
> 

> > > I have pgpool running with two postgres servers in master/slave
> > 
> 
> > > mode with streaming replication.
> > 
> 
> > > But now I have started to use it and some errors have appeared in
> > 
> 
> > > the slave postgres log. They look related to pgpool since they
> > > involve
> > 
> 
> > > pgpool_regclass function.
> > 
> 

> > > 28949 2012-05-03 14:25:06 CEST ERROR: function
> > > pgpool_regclass(unknown)
> > 
> 
> > > does no
> > 
> 
> > > t exist at character 69
> > 
> 
> > > 28949 2012-05-03 14:25:06 CEST HINT: No function matches the
> > > given
> > > name
> > 
> 
> > > and argument types. You might need to add explicit type casts.
> > 
> 
> > > 28949 2012-05-03 14:25:06 CEST STATEMENT: SELECT count(*) FROM
> > > pg_class
> > 
> 
> > > AS c, p
> > 
> 
> > > g_namespace AS n WHERE c.oid = pgpool_regclass('pg_namespace')
> > > AND
> > 
> 
> > > c.relnamespac
> > 
> 
> > > e = n.oid AND n.nspname = 'pg_catalog'
> > 
> 
> > > 28949 2012-05-03 14:25:06 CEST ERROR: function
> > > pgpool_regclass(unknown)
> > 
> 
> > > does no
> > 
> 
> > > t exist at character 61
> > 
> 
> > > 28949 2012-05-03 14:25:06 CEST HINT: No function matches the
> > > given
> > > name
> > 
> 
> > > and argument types. You might need to add explicit type casts.
> > 
> 
> > > 28949 2012-05-03 14:25:06 CEST STATEMENT: SELECT count(*) FROM
> > 
> 
> > > pg_catalog.pg_cl
> > 
> 
> > > ass AS c WHERE c.oid = pgpool_regclass('Diccionario') AND
> > 
> 
> > > c.relpersistence = 'u'
> > 
> 

> > > Diccionario is one of our tables, so I initially thought it could
> > 
> 
> > > be a bug of our application, but since pg_namespace is an
> > > internal
> > > one,
> > 
> 
> > > I turn to the function itself. It looks like it's expecting an
> > > argument
> > 
> 
> > > of a type, but other one is passed to.
> > 
> 

> > > The errors happened also on the master server when the slave was
> > 
> 
> > > down for testing, but when it was recovered to the cluster,
> > > errors
> > 
> 
> > > stopped in the server and started in the slave.
> > 
> 

> > > I don't know if it's a bug or if the error is not important. I'd
> > 
> 
> > > really appreciate if someone could offer an answer to any of
> > > these
> > 
> 
> > > questions.
> > 
> 

> > > Many thanks.
> > 
> 

> > > _______________________________________________
> > 
> 
> > > pgpool-general mailing list
> > 
> 
> > > pgpool-general at pgpool.net
> > 
> 
> > > http://www.pgpool.net/mailman/listinfo/pgpool-general
> > 
> 

> > > 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS
> > > CIENCIAS
> > > INFORMATICAS...
> > 
> 
> > > CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION
> > 
> 

> > > http://www.uci.cu
> > 
> 
> > > http://www.facebook.com/universidad.uci
> > 
> 
> > > http://www.flickr.com/photos/universidad_uci
> > 
> 


10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...
CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION

http://www.uci.cu
http://www.facebook.com/universidad.uci
http://www.flickr.com/photos/universidad_uci

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120503/52204b7c/attachment-0001.html>