[pgpool-general: 406] Re: pgpool_regclass error

[Juan Jose Perez]

     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.
>
> ------------------------------------------------------------------------
>
>
>          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
>
>
>
>
> <http://www.uci.cu/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20120503/5cecff51/attachment.htm>