[Pgpool-general] Cannot add node after failure

[Fernando Morgenstern]

Hello,

Do you have any additional suggestions of things that i should check?

I am a bit lost with this problem and currently i don't know what else  
i can try ( I even tried to start only node, but it is show as status  
3 ) .

Best Regards,
---

Fernando Marcelo
www.consultorpc.com
fernando at consultorpc.com

Em 13/12/2009, às 06:38, Tatsuo Ishii escreveu:

>> Hello,
>>
>> I started to use pgpool a few days ago and, while testing it, i am
>> having some issues to bring nodes back.
>>
>> I have 4 nodes running, so i decided to stop one of them. I saw on
>> logs that its status changed to 3. Ok, perfect.
>>
>> Them, i started the failed node again, but its status was still 3.
>
> This is an expected behavior. pgpool does not re-connect recovered
> node. If pgpool does this, pgpool will repeat connect/disconnect node
> forever if it's connected through a flakey network.
>
>> I decided to stop and start pgpool again, now all nodes have status  
>> 3:
>>
>> 2009-12-11 11:29:28 DEBUG: pid 1107: health_check: 0 th DB node
>> status: 3
>> 2009-12-11 11:29:28 DEBUG: pid 1107: health_check: 1 th DB node
>> status: 3
>> 2009-12-11 11:29:28 DEBUG: pid 1107: health_check: 2 th DB node
>> status: 3
>> 2009-12-11 11:29:28 DEBUG: pid 1107: health_check: 3 th DB node
>> status: 3
>
> This is not what I'm expecting. Can you double check you can connect
> to the DB nodes by:
>
> psql -U postgres -h your_db_host_name -p its_port_number template1:
>
> For example,
>
> psql -U postgres -h im-pp3 -p 4003 template1
>
> Also can you show me the all the log after restarting pgool?
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan