[Pgpool-general] pgpool disconnecting client
MA
mauricio_pgpool at latpro.com
Tue Jun 24 14:22:40 UTC 2008
Hello list,
we're new to pgpool, we have a java application running fine while
connected directly (no thru pgpool) to our postgres servers. The
application is based on compass-project http://www.compass-project.org/
Now when we try to use pgpool it executes some of the statements but at
some point it got disconnected, server logs show a "LOG: unexpected EOF
on client connection". pgpool log seems not to work although we have
enabled its options as follows
- log_connections = true
- log_hostname = true
- log_statement = true
Below is a detailed log of one of our database servers included into the
pgpool, we're using latest jdbc driver. And as I described this same
application works fine with postgres server when it's connected directly
to it, not through pgpool
-Is there any chance that this is related with pgpool configuration?
probably a timeout?
-Is this a bug?
-Can anyone pinpoint into the right direction to have also pgpool log
all the statements?
Thanks in advance, any ideas are deeply appreciated
MA
LOG: 00000: connection received: host=xxx.xxx.xxx.xxx port=55086
LOCATION: BackendInitialize, postmaster.c:3027
LOG: 00000: connection authorized: user=user database=datab
LOCATION: BackendInitialize, postmaster.c:3097
LOG: 00000: duration: 0.239 ms parse <unnamed>: SET SESSION
CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
LOCATION: exec_parse_message, postgres.c:1334
LOG: 00000: duration: 0.014 ms bind <unnamed>: SET SESSION
CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
LOCATION: exec_bind_message, postgres.c:1728
LOG: 00000: execute <unnamed>: SET SESSION CHARACTERISTICS AS
TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
LOCATION: exec_execute_message, postgres.c:1862
LOG: 00000: duration: 0.036 ms
LOCATION: exec_execute_message, postgres.c:1932
LOG: 00000: statement: RESET ALL
LOCATION: exec_simple_query, postgres.c:845
LOG: 00000: duration: 0.067 ms
LOCATION: exec_simple_query, postgres.c:1056
LOG: 00000: statement: SET SESSION AUTHORIZATION DEFAULT
LOCATION: exec_simple_query, postgres.c:845
LOG: 00000: duration: 0.048 ms
LOCATION: exec_simple_query, postgres.c:1056
LOG: 00000: duration: 0.063 ms parse <unnamed>: SET SESSION
CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
LOCATION: exec_parse_message, postgres.c:1334
LOG: 00000: duration: 0.010 ms bind <unnamed>: SET SESSION
CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
LOCATION: exec_bind_message, postgres.c:1728
LOG: 00000: execute <unnamed>: SET SESSION CHARACTERISTICS AS
TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
LOCATION: exec_execute_message, postgres.c:1862
LOG: 00000: duration: 0.030 ms
LOCATION: exec_execute_message, postgres.c:1932
LOG: 00000: duration: 0.048 ms parse S_1: BEGIN
LOCATION: exec_parse_message, postgres.c:1334
LOG: 00000: duration: 0.005 ms bind S_1: BEGIN
LOCATION: exec_bind_message, postgres.c:1728
LOG: 00000: execute S_1: BEGIN
LOCATION: exec_execute_message, postgres.c:1862
LOG: 00000: duration: 0.016 ms
LOCATION: exec_execute_message, postgres.c:1932
LOG: 00000: duration: 3.346 ms parse S_2: select tablename from
pg_tables where schemaname = 'public' and lower(tablename)
= $1
LOCATION: exec_parse_message, postgres.c:1334
LOG: 00000: duration: 0.114 ms bind S_2/C_3: select tablename from
pg_tables where schemaname = 'public' and
lower(tablename ) = $1
DETAIL: parameters: $1 = 'index_book'
LOCATION: exec_bind_message, postgres.c:1728
LOG: 00000: execute S_2/C_3: select tablename from pg_tables where
schemaname = 'public' and lower(tablename) = $1
DETAIL: parameters: $1 = 'index_book'
LOCATION: exec_execute_message, postgres.c:1862
LOG: 00000: duration: 0.214 ms
LOCATION: exec_execute_message, postgres.c:1932
LOG: 08P01: unexpected EOF on client connection
LOCATION: SocketBackend, postgres.c:323
LOG: 00000: disconnection: session time: 0:00:00.852 user=user
database=datab host=xxx.xxx.xxx.xxx port=55086
LOCATION: log_disconnections, postgres.c:3982
More information about the Pgpool-general
mailing list