[pgpool-general: 1719] Re: Problems running jdbc testsuite

[Tatsuo Ishii]

> Hi,
> 
> some time ago I've started running some of the testsuites in the
> pgpool2 code when the Debian package is built. I've just uploaded
> 3.2.4 to Debian, but now I had to disable the "batch" and "insert"
> tests from test/jdbc, because they just seem to hang indefinitely.
> 
> Any idea if that's a real problem, or just the testsuite being broken?
> 
> The script to run the tests looks like this:
> 
> [...]
> cd test/jdbc
> 
> export PGPORT=9999
> 
> cat >> /etc/pgpool2/pgpool.conf <<EOF
> #ADT#
> port = $PGPORT
> backend_hostname0 = '$PGHOST'
> backend_port0 = 5432
> pool_passwd = ''
> EOF
> tail -n4 /etc/pgpool2/pgpool.conf
> echo
> 
> cat > pgpool.properties <<EOF
> pgpooltest.host=$PGHOST
> pgpooltest.port=$PGPORT
> pgpooltest.user=$PGUSER
> pgpooltest.password=$PGPASSWORD
> pgpooltest.dbname=postgres
> pgpooltest.options=
> #pgpooltest.tests=autocommit batch column lock select update insert
> pgpooltest.tests=autocommit column lock select update
> EOF
> echo
> 
> /etc/init.d/pgpool2 start
> psql -p $PGPORT -f prepare.sql 2>&1
> echo
> 
> CLASSPATH=/usr/share/java/postgresql.jar:. ./run.sh
> echo

I have tested with Debian but could not reproduce the problem.

pgpool-II: 3.2.4
PostgreSQL: 9.2.4
JDBC driver: postgresql-9.2-1002.jdbc4.jar
Java: 
java version "1.6.0_24"
Java(TM) SE Runtime Environment (build 1.6.0_24-b07)
Java HotSpot(TM) 64-Bit Server VM (build 19.1-b02, mixed mode)
Linux: 3.0.71-1vl6 #1 SMP Mon Apr 1 23:17:07 JST 2013 x86_64 x86_64 x86_64 GNU/Linux

One thing I noticed was in the default pgpool.conf.sample, there is a line

backend_hostname1 = 'host2'

This makes pgpool do fail over if there's no host "host2" and you have
only one valid backend. I just commented out the line and everything
seems works ok.  I'm going to comment out the line above in git
repository.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp