[pgpool-general: 3082] Re: pgpool -m fast problem
straszewski.tomasz at gmail.com
Wed Jul 30 14:45:47 JST 2014
Thanks for response!.
I will be waiting for next stable release ;-)
W dniu 2014-07-30 00:45, Yugo Nagata pisze:
> On Mon, 28 Jul 2014 14:01:08 +0200
> Tomasz Straszewski <straszewski.tomasz at gmail.com> wrote:
>> Today I had some problem when i was testing watchdog mechanizm.
>> os: Centos 6.5 x64
>> pgpool: pgpool-II-pg93-3.3.3-3.pgdg.x86_64.rpm
>> 1. Run pgpool on server1
>> 2. Run pgpool on server2
>> 3. Type "pgpool -m fast" on server1 to stop pgpool
>> After that pgpool on server2 is escalating to master correctly and VIP
>> is bringing up. On server2 VIP is down but stop command is still working
>> and couldn't stop.
>> Additionaly i can see after typing "netstat -tlnp" that pgpool process
>> is still running.
>> Stopping process on server1 is running until i invoke "pgpool -m fast"
>> command on server2.
>> Maybe some connection between server1 and server2 is not closing during
>> stop command execution?
> There is a bug about VIP control in watchdog of pgpool-II 3.3.3.
> pgpool-II checks an exit code of ping when bringing up VIP, but
> due to the bug, new active pgpool (on server2 in your case) goes
> into an infinite loop. In addition, previous active (server1) also
> hangs since this is waiting for response from the new active, which
> is in hang and disable to respond.
> This is fixed in this commit;
> Could you please get patch or latest tar ball from here, and try to build
> pgpool from source files? Or, please wait for next stable version 3.3.4,
> which will be released at the beginning of next month.
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
More information about the pgpool-general