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

[Dzmitry]

May be this will help:

2013-04-07 11:48:52 LOG:   pid 9785: do_child: exits with status 1 due to
error
2013-04-07 11:48:52 LOG:   pid 9760: pool_read_kind: error message from 2
th backend:canceling statement due to conflict with recovery
2013-04-07 11:48:53 LOG:   pid 9767: detect_stop_postmaster_error:
detect_error error
2013-04-07 11:48:53 LOG:   pid 9767: detect_postmaster_down_error returns
error on backend 2. Going to close this session.
2013-04-07 11:59:28 LOG:   pid 9651: do_child: exits with status 1 due to
error


? 


Thanks,
  Dzmitry





On 4/5/13 4:00 AM, "Tatsuo Ishii" <ishii at postgresql.org> wrote:

>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=04a655560123d
>>>a7
>>>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
>> 
>>