[Pgpool-general] jdbc hang using pgpool II

Tatsuo Ishii ishii at sraoss.co.jp
Sun Mar 11 05:29:35 UTC 2007 

Can you show me pgpool.conf?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Hi,
> 
> Im not having much luck getting jdbc to work with pgpool II. I have 
> tried the latest source and version 1.0.2. My setup is using the pgbench 
> schema. I ran pgbench as described in the tutorial and that worked. I 
> then ran psql connecting to port 9999 and was able to do inserts and 
> queries. When I tried to use jdbc connecting to port 9999 I get a 
> successful connection from the client but the client then hangs doing a 
> query.
> 
> postgres version: postgresql-8.2.3
> jdbc driver: postgresql-8.2-504.jdbc3.jar
> 
> The jdbc command I tried was:
> 
> ResultSet results = sql.executeQuery("select * from tellers");
> 
> I tried the jdbc query connecting directly to one of the postgres 
> backends and that worked fine.
> 
> This is the debug log. Any ideas?
> 
> 
> 2007-03-08 11:03:15 DEBUG: pid 22760: I am 22760 accept fd 7
> 2007-03-08 11:03:15 DEBUG: pid 22760: Protocol Major: 3 Minor: 0 
> database: bench_parallel user: postgres
> 2007-03-08 11:03:15 DEBUG: pid 22760: new_connection: connecting 0 backend
> 2007-03-08 11:03:15 DEBUG: pid 22760: new_connection: connecting 1 backend
> 2007-03-08 11:03:15 DEBUG: pid 22760: new_connection: connecting 2 backend
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length: slot: 0 
> length: 8
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length: slot: 1 
> length: 8
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length: slot: 2 
> length: 8
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 0 length: 28
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 1 length: 28
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 2 length: 28
> 2007-03-08 11:03:15 DEBUG: pid 22760: 0 th backend: name: 
> client_encoding value: UNICODE
> 2007-03-08 11:03:15 DEBUG: pid 22760: 1 th backend: name: 
> client_encoding value: UNICODE
> 2007-03-08 11:03:15 DEBUG: pid 22760: 2 th backend: name: 
> client_encoding value: UNICODE
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 0 length: 23
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 1 length: 23
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 2 length: 23
> 2007-03-08 11:03:15 DEBUG: pid 22760: 0 th backend: name: DateStyle 
> value: ISO, MDY
> 2007-03-08 11:03:15 DEBUG: pid 22760: 1 th backend: name: DateStyle 
> value: ISO, MDY
> 2007-03-08 11:03:15 DEBUG: pid 22760: 2 th backend: name: DateStyle 
> value: ISO, MDY
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 0 length: 26
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 1 length: 26
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 2 length: 26
> 2007-03-08 11:03:15 DEBUG: pid 22760: 0 th backend: name: 
> integer_datetimes value: off
> 2007-03-08 11:03:15 DEBUG: pid 22760: 1 th backend: name: 
> integer_datetimes value: off
> 2007-03-08 11:03:15 DEBUG: pid 22760: 2 th backend: name: 
> integer_datetimes value: off
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 0 length: 20
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 1 length: 20
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 2 length: 20
> 2007-03-08 11:03:15 DEBUG: pid 22760: 0 th backend: name: is_superuser 
> value: on
> 2007-03-08 11:03:15 DEBUG: pid 22760: 1 th backend: name: is_superuser 
> value: on
> 2007-03-08 11:03:15 DEBUG: pid 22760: 2 th backend: name: is_superuser 
> value: on
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 0 length: 25
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 1 length: 25
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 2 length: 25
> 2007-03-08 11:03:15 DEBUG: pid 22760: 0 th backend: name: 
> server_encoding value: UTF8
> 2007-03-08 11:03:15 DEBUG: pid 22760: 1 th backend: name: 
> server_encoding value: UTF8
> 2007-03-08 11:03:15 DEBUG: pid 22760: 2 th backend: name: 
> server_encoding value: UTF8
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 0 length: 25
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 1 length: 25
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 2 length: 25
> 2007-03-08 11:03:15 DEBUG: pid 22760: 0 th backend: name: server_version 
> value: 8.2.3
> 2007-03-08 11:03:15 DEBUG: pid 22760: 1 th backend: name: server_version 
> value: 8.2.3
> 2007-03-08 11:03:15 DEBUG: pid 22760: 2 th backend: name: server_version 
> value: 8.2.3
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 0 length: 35
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 1 length: 35
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 2 length: 35
> 2007-03-08 11:03:15 DEBUG: pid 22760: 0 th backend: name: 
> session_authorization value: postgres
> 2007-03-08 11:03:15 DEBUG: pid 22760: 1 th backend: name: 
> session_authorization value: postgres
> 2007-03-08 11:03:15 DEBUG: pid 22760: 2 th backend: name: 
> session_authorization value: postgres
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 0 length: 36
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 1 length: 36
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 2 length: 36
> 2007-03-08 11:03:15 DEBUG: pid 22760: 0 th backend: name: 
> standard_conforming_strings value: off
> 2007-03-08 11:03:15 DEBUG: pid 22760: 1 th backend: name: 
> standard_conforming_strings value: off
> 2007-03-08 11:03:15 DEBUG: pid 22760: 2 th backend: name: 
> standard_conforming_strings value: off
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 0 length: 24
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 1 length: 24
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length2: master 
> slot: 2 length: 24
> 2007-03-08 11:03:15 DEBUG: pid 22760: 0 th backend: name: TimeZone 
> value: US/Eastern
> 2007-03-08 11:03:15 DEBUG: pid 22760: 1 th backend: name: TimeZone 
> value: US/Eastern
> 2007-03-08 11:03:15 DEBUG: pid 22760: 2 th backend: name: TimeZone 
> value: US/Eastern
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length: slot: 0 
> length: 12
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length: slot: 1 
> length: 12
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length: slot: 2 
> length: 12
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_send_auth_ok: send pid 22817 
> to frontend
> 2007-03-08 11:03:15 DEBUG: pid 22760: read_kind_from_backend: read kind 
> from 0 th backend Z NUM_BACKENDS: 3
> 2007-03-08 11:03:15 DEBUG: pid 22760: read_kind_from_backend: read kind 
> from 1 th backend Z NUM_BACKENDS: 3
> 2007-03-08 11:03:15 DEBUG: pid 22760: read_kind_from_backend: read kind 
> from 2 th backend Z NUM_BACKENDS: 3
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_process_query: kind from 
> backend: Z
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length: slot: 0 
> length: 5
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length: slot: 1 
> length: 5
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_read_message_length: slot: 2 
> length: 5
> 2007-03-08 11:03:15 DEBUG: pid 22760: ReadyForQuery: message length: 5
> 2007-03-08 11:03:15 DEBUG: pid 22760: ReadyForQuery: transaction state: I
> 2007-03-08 11:03:15 DEBUG: pid 22760: pool_process_query: num_fds: 12
> 2007-03-08 11:03:15 DEBUG: pid 22760: read kind from frontend P(50)
> 2007-03-08 11:03:15 DEBUG: pid 22760: read kind from frontend B(42)
> 2007-03-08 11:03:15 DEBUG: pid 22760: bind message: portal_name  stmt_name
> 2007-03-08 11:03:15 DEBUG: pid 22760: read kind from frontend D(44)
> 2007-03-08 11:03:15 DEBUG: pid 22760: read kind from frontend E(45)
> 2007-03-08 11:03:15 DEBUG: pid 22760: Execute: portal name <>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>

More information about the Pgpool-general mailing list