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

[Tatsuo Ishii]

The problem was fixed in 3.3.4. Please upgrade.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 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,
>>