<div dir="ltr"><div><div><div><div><div><div><div>Dear sir,<br><br></div>Sorry for the missing information.<br><br></div>Actually my statement includes "nextval" keyword.<br><br></div>My statement looks like:<br>
pstmt = conn.prepareStatement("insert into table_name (id) values (nextval('seq'))");<br><br></div>By using this kind of statement, I can re-produce the hang-on situation.<br><br></div>Many thanks for your help<br>
<br></div><br><br><br>best regards.<br><br></div><div><div><div><div><div><div><div><div><br></div></div></div></div></div></div></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/5/2 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">> Hello All,<br>
><br>
> I forget to install regclass in postgresql server.<br>
><br>
> When I send a query which needs a function belonging to regclass (e.g.<br>
> nextval), pgpool can receive a message from backend.<br>
> The message looks like: cannot access file libdir/pgpool-regclass: no such<br>
> file or directory.<br>
><br>
> When this happens, the connection from the client cannot be release.<br>
> If I keep requesting the same query iteratively, the number of connections<br>
> reaches the maximum value, and then all connections are occupied and no<br>
> connection can be accepted.<br>
><br>
> I know that I should install regclass in postgresql server, but my question<br>
> is: Is that correct for pgpool that the connection cannot be released after<br>
> some error happen at backend?<br>
<br>
</div></div>Did not reproduce here. I renamed pgpool-regclass.so and ran simple<br>
SELECT. Here are logs I observed but no lock up happens.<br>
<br>
2013-05-02 14:08:24 LOG: pid 4311: do_query: error message from backend: could not access file "$libdir/pgpool-regclass": No such file or directory<br>
2013-05-02 14:08:24 LOG: pid 4311: DB node id: 0 backend pid: 4335 statement: SELECT count(*) FROM pg_catalog.pg_class AS c, pg_attribute AS a WHERE c.relname = 'pg_class' AND a.attrelid = c.oid AND a.attname = 'relistemp'<br>
2013-05-02 14:08:24 LOG: pid 4311: DB node id: 0 backend pid: 4335 statement: SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname = 'pg_class' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'<br>
2013-05-02 14:08:24 LOG: pid 4311: DB node id: 0 backend pid: 4335 statement: SELECT count(*) FROM pg_catalog.pg_class AS c, pg_catalog.pg_attribute AS a WHERE c.relname = 'pg_class' AND a.attrelid = c.oid AND a.attname = 'relpersistence'<br>
2013-05-02 14:08:24 LOG: pid 4311: DB node id: 0 backend pid: 4335 statement: SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass('pg_class') AND c.relpersistence = 'u'<br>
2013-05-02 14:08:24 LOG: pid 4311: DB node id: 0 backend pid: 4335 statement: select * from pg_class limit 1;<br>
2013-05-02 14:11:23 LOG: pid 4311: DB node id: 0 backend pid: 4335 statement: DISCARD ALL<br>
2013-05-02 14:11:23 LOG: pid 4311: DB node id: 1 backend pid: 4336 statement: DISCARD ALL<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Wireless Communication and Mobile Computing Research Group Laboratory<br>TEL:(886)-2-23625336-448<br>Dept. of Computer Science and Information Engineering<br>National Taiwan University, Taipei, Taiwan
</div>