[pgpool-general: 1573] Re: pgpool 3.2.3 node gets down after some hours of work.

[Tatsuo Ishii]

No idea. Full debug log of pgpool would help though.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Any updates on this issue ? I've installed V3_2_STABLE but still the same
> issues, node in pgpool shown as down - but it's working fine
> 
> Thanks,
>   Dzmitry
> 
> 
> 
> 
> 
> On 3/29/13 3:16 PM, "Tatsuo Ishii" <ishii at postgresql.org> wrote:
> 
>>Can you try with V3_2_STABLE from git repository? We recently fixed
>>some issues with connecting to PostgreSQL backend. This may or may not
>>be related to your problem.
>>
>>http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=04a655560123da7
>>99a83b1b34d09db0ae6d0bc44
>>--
>>Tatsuo Ishii
>>SRA OSS, Inc. Japan
>>English: http://www.sraoss.co.jp/index_en.php
>>Japanese: http://www.sraoss.co.jp
>>
>>> Dear all,
>>> 
>>> I am using postgres 9.2 with streaming replication. I have 1 master DB
>>>and
>>> 2 standby DBs, it's hosted on amazon EC2, each has it's own server. On
>>> separate server i have pgpool(3.2.3) that do load balancing(in pgpool
>>> config i have num_init_children=290, max_pool- 2, child_life_time -
>>> 0child_max_connections - 100, connection_life_time- 100,
>>>client_idle_limit
>>> - 0. do not cache onnections.). Sometimes pgpool show server status as
>>> "down", but actually server is up & running fine, due to this, i am
>>> getting a lot of issues.
>>> Also i have in pgpool config:
>>> health_check_timeout - 60
>>> health_check_period - 30
>>> health_check_max_retries - 3
>>> health_check_retry_delay -5
>>> Also pgpool is not writing log :(
>>> i setup it
>>> log_destination "stderr"
>>> debug_level 0
>>> logdir /var/tmp - i checked permissions it has 777, so it's not the
>>>case.
>>> when i start pgpool i start it with "-n" option to let it write log.
>>> 
>>> Any ideas why server shown as down & where is my logs ?
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> pgpool-general mailing list
>>> pgpool-general at pgpool.net
>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
> 
>