[pgpool-general: 3391] Re: Discard All never complete on primary and secondary

[Bruce Skelton]

This is very easy to reproduce. I am running. I have about 10 other
clusters where this is not a problem.

pgpool-II version 3.3.2 (tokakiboshi)

Thanks,
Bruce




On Mon, Dec 22, 2014 at 3:34 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> Does not reproduce here. Does it always happen?
> What is the pgpool versin?
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
> > The Discard All statements never complete leading to no new connections
> > possible. What would prevent them from completing. PostgreSQL 9.2.8,
> > streaming.
> >
> > num_init_children = 80
> > max_pool = 4
> > child_life_time = 300
> > child_max_connections = 0
> > connection_life_time = 0
> > client_idle_limit = 0
> > connection_cache = on
> > reset_query_list = 'ABORT; DISCARD ALL'
> > white_function_list = 'ping'
> > black_function_list = ''
> >
> > postgresql.conf
> >
> > max_connections = 340
> >
> > Thanks in advance,
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141230/cff53459/attachment.html>