[pgpool-general: 417] Re: pgpool_regclass error

[Lazaro Ruben Garcia Martinez]

I recommend you install this function in template1 database, to avoid this problem in the future. 

Regards. 

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

> You were right, Lazaro. It should have been installed in all
> databases, but it wasn't.
> Now it works fine.

> Many thanks.

> El 03/05/12 19:00, Lazaro Ruben Garcia Martinez escribió:
> > 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/20120507/cefe3db8/attachment-0001.html>