[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