[pgpool-general: 404] pgpool_regclass error
Juan Jose Perez
jperez at oteara.com
Fri May 4 00:08:13 JST 2012
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.
More information about the pgpool-general
mailing list