[pgpool-general: 2823] Re: sql after an inactive psql session causes failover
Yugo Nagata
nagata at sraoss.co.jp
Tue May 13 22:01:42 JST 2014
Hi,
On Mon, 5 May 2014 17:23:28 -0400
Gary Fu <gfu at sigmaspace.com> wrote:
> Hi,
>
> We are running pgpool 3.3.2 with replication and load balance both on,
> on a new server with postgres 9.2.8 on two separated db servers. We
> noticed that when we issue a simple sql (select * from config) on a psql
> session (connect to pgpool) without activities (idle) for more than 20
> or 30 minutes, the sql will hang for about several minutes (maybe more
> than 5 or 10 minutes) and then come back with a new connection after the
> pgpool failover. During that period, there is no problem to make new
Could you please send pgpool.conf and pgpool.log around the failover?
> psql connection. We don't see the problem with an old pgpool server (on
> different subnet), same pgpool.conf, connects to the same db servers
> with different dbs. I think it is the network/tcpip configuration
> and/or firewall issues, but I'm not export on network (the sysctl
> command shows no difference between the two pgpool servers) and no
> access to firewall setup. I don't know how to find out the real cause.
> Can anyone provide any help/hint ?
>
> Thanks,
> Gary
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
--
Yugo Nagata <nagata at sraoss.co.jp>
More information about the pgpool-general
mailing list