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

[Dzmitry]

I am able to connect to my master from server where pgpool works. I do it
as psql -d <prod DB name> -p 5432 -h <hostname> -U postgres

Thanks,
  Dzmitry





On 3/29/13 3:54 AM, "Lonni J Friedman" <netllama at gmail.com> wrote:

>How and from where are you logging in manually?
>
>On Thu, Mar 28, 2013 at 5:28 PM, Dzmitry <dzmitry.nikitsin at gmail.com>
>wrote:
>> I found in log, but how it can show s_do_auth failed if I can login
>> manually ?
>>
>> 2013-03-29 00:17:16 ERROR: pid 4777: pool_read_kind: kind does not match
>> between master(45) slot[1] (52)
>> 2013-03-29 00:17:18 ERROR: pid 4735: s_do_auth: expecting R got E
>> 2013-03-29 00:17:18 ERROR: pid 4735: make_persistent_db_connection:
>> s_do_auth failed
>> 2013-03-29 00:17:18 ERROR: pid 4735: health check failed. 0 th host
>> <myhost> at port 5432 is down
>> 2013-03-29 00:20:28 ERROR: pid 4735: Child process 7808 was terminated
>>by
>> segmentation fault
>> 2013-03-29 00:20:28 ERROR: pid 4735: Child process 7970 was terminated
>>by
>> segmentation fault
>> 2013-03-29 00:20:33 ERROR: pid 4735: Child process 7986 was terminated
>>by
>> segmentation fault
>> 2013-03-29 00:20:46 ERROR: pid 4735: Child process 7711 was terminated
>>by
>> segmentation fault
>> 2013-03-29 00:22:00 ERROR: pid 4735: Child process 7765 was terminated
>>by
>> segmentation fault
>>
>>
>>
>> Thanks,
>>   Dzmitry
>>
>>
>>
>>
>>
>> On 3/29/13 2:24 AM, "Lonni J Friedman" <netllama at gmail.com> wrote:
>>
>>>On Thu, Mar 28, 2013 at 4:10 PM, Dzmitry <dzmitry.nikitsin at gmail.com>
>>>wrote:
>>>> 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 ?
>>>>
>>>
>>>Your logs would indicate why the nodes are down.  As for where they
>>>are, you'd have to tell us.  How did you install & configure pgpool?
>>
>>