[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