[pgpool-general: 347] pgpool-3.1.2 and jdbc driver

Евгений Селявка evg.selyavka at gmail.com
Thu Apr 5 17:01:20 JST 2012

Dear users, I have installed postgresql-9.1.3 in streaming replication mode
and pgpool-3.1.2 only in load balancing mode. In log i see message like this

2012-04-04 15:47:39 LOG:   pid 16968: pool_send_and_wait: Error or notice
message from backend: : DB node id: 0 backend pid: 4664 statement: SELECT 1
message: portal "" does not exist

I have jdbc: 9.0-801.jdbc4
And pooling connection with java dbcp

<bean id="Ds" class="org.apache.commons.dbcp.BasicDataSource"
        <property name="driverClassName" value="org.postgresql.Driver" />
        <property name="url"
value="jdbc:postgresql://${db.server}:${db.port}/${db.name}" />
        <property name="username" value="${db.user}" />
        <property name="password" value="${db.pass}" />
        <property name="maxActive" value="${db.connections.max_active}" />
        <property name="maxIdle" value="${db.connections.max_idle}" />
        <property name="maxWait" value="30000" />
        <property name="validationQuery" value="SELECT 1" />
        <property name="removeAbandoned" value="true" />
        <property name="removeAbandonedTimeout" value="60" />

While googling i see that this bug was fixed in version pgpool-3.0.3?

С уважением Селявка Евгений
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120405/62945b02/attachment.html>

More information about the pgpool-general mailing list