[Pgpool-general] jdbc hang using pgpool II
Joe
jrdaly94 at gmail.com
Thu Mar 8 16:05:54 UTC 2007
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 <>
More information about the Pgpool-general
mailing list