<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<br>
Yes, it's installed in both servers. The version is
pgpool-II-3.1.2.<br>
<br>
Regards.<br>
<br>
El 03/05/12 17:50, Lazaro Ruben Garcia Martinez escribió:
<blockquote
cite="mid:56619eb5-ea68-4814-8727-14d4559e6714@ucimail3.uci.cu"
type="cite">
<style type="text/css">p { margin: 0; }</style>
<div style="font-family: Times New Roman; font-size: 14pt; color:
#000000">The pgpool_regclass function is installed in all
servers?. What version of pgpool-II are you using?<br>
<br>
Regards.<br>
<br>
<hr id="zwchr">
<blockquote style="border-left:2px solid rgb(16, 16,
255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><br>
Hi,<br>
<br>
I have pgpool running with two postgres servers in
master/slave <br>
mode with streaming replication.<br>
But now I have started to use it and some errors have
appeared in <br>
the slave postgres log. They look related to pgpool since they
involve <br>
pgpool_regclass function.<br>
<br>
28949 2012-05-03 14:25:06 CEST ERROR: function
pgpool_regclass(unknown) <br>
does no<br>
t exist at character 69<br>
28949 2012-05-03 14:25:06 CEST HINT: No function matches the
given name <br>
and argument types. You might need to add explicit type casts.<br>
28949 2012-05-03 14:25:06 CEST STATEMENT: SELECT count(*)
FROM pg_class <br>
AS c, p<br>
g_namespace AS n WHERE c.oid = pgpool_regclass('pg_namespace')
AND <br>
c.relnamespac<br>
e = n.oid AND n.nspname = 'pg_catalog'<br>
28949 2012-05-03 14:25:06 CEST ERROR: function
pgpool_regclass(unknown) <br>
does no<br>
t exist at character 61<br>
28949 2012-05-03 14:25:06 CEST HINT: No function matches the
given name <br>
and argument types. You might need to add explicit type casts.<br>
28949 2012-05-03 14:25:06 CEST STATEMENT: SELECT count(*)
FROM <br>
pg_catalog.pg_cl<br>
ass AS c WHERE c.oid = pgpool_regclass('Diccionario') AND <br>
c.relpersistence = 'u'<br>
<br>
Diccionario is one of our tables, so I initially thought
it could <br>
be a bug of our application, but since pg_namespace is an
internal one, <br>
I turn to the function itself. It looks like it's expecting an
argument <br>
of a type, but other one is passed to.<br>
<br>
The errors happened also on the master server when the
slave was <br>
down for testing, but when it was recovered to the cluster,
errors <br>
stopped in the server and started in the slave.<br>
<br>
I don't know if it's a bug or if the error is not
important. I'd <br>
really appreciate if someone could offer an answer to any of
these <br>
questions.<br>
<br>
Many thanks.<br>
<br>
<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS
CIENCIAS INFORMATICAS...<br>
CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.uci.cu">http://www.uci.cu</a><br>
<a class="moz-txt-link-freetext" href="http://www.facebook.com/universidad.uci">http://www.facebook.com/universidad.uci</a><br>
<a class="moz-txt-link-freetext" href="http://www.flickr.com/photos/universidad_uci">http://www.flickr.com/photos/universidad_uci</a><br>
</blockquote>
<br>
</div>
<br>
<a moz-do-not-send="true" href="http://www.uci.cu/">
<img moz-do-not-send="true"
src="http://universidad.uci.cu/email.gif">
<br>
</a></blockquote>
</body>
</html>