[pgpool-general: 4839] Re: failover_command and follow_command does not exit and hangs indefinitely

[Tema Zelikin]

02.08.2016 09:44, Tatsuo Ishii пишет:
>> On 02.08.2016 4:26, Tatsuo Ishii wrote:
>>>> I'm trying to configure expandable cluster using Ubuntu 14.04 LTS,
>>>> PostgreSQL 9.5 and PgPool 3.5.3.
>>>> I'm having a problem with failover/follow commands: any command, be
>>>> that
>>>> ansible-playbook, ssh or anything else does not exit after successful
>>>> run and hangs indefinitely, reacting only to "kill -9".  Which, in
>>>> case
>>>> of failover script, makes pgpool running that command wait for it's
>>>> exit
>>>> and also to hang.
>>>> My current workaround is forking script, running a command in the new
>>>> fork, and terminate it after successful execution. Obviously, its not
>>>> a
>>>> viable production solution.
>>>> Please help me undestand, why is this happening?
>>> I guess your fail over script is waiting for stdin/stdout/stderr
>>> closed?
>> I dont exactly know, that's why i'm asking. Right now i'm having a
>> problem with ansible-playbook and ssh.
> Without seeing the fail over script, I can't tell. Can you share the
> fail over script you created?
>

Yes, i'm attaching script to this message.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgres.py
Type: text/x-python
Size: 3294 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160802/8d7b6c53/attachment.py>