[pgpool-general: 1719] Re: Problems running jdbc testsuite
Tatsuo Ishii
ishii at postgresql.org
Mon May 13 09:08:27 JST 2013
> 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
More information about the pgpool-general
mailing list