[pgpool-general: 405] Re: pgpool_regclass error

[Lazaro Ruben Garcia Martinez]

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/decc7940/attachment.html>