[pgpool-general: 2465] Re: wd_escalation_command exit code

Sergey Arlashin sergeyarl.maillist at gmail.com
Tue Jan 21 20:24:02 JST 2014


Great! Now it is working!

pgpool[31903]: wd_escalation: escalation command failed. exit status: 1

Thank you!

Will this patch be included in 3.3.3 ?

Also, what about failed if_up_cmd and further pgpool behaviour (my second message in the thread.) ?



On Jan 21, 2014, at 2:15 PM, Yugo Nagata <nagata at sraoss.co.jp> wrote:

> Hi,
> 
> On Tue, 21 Jan 2014 13:27:08 +0400
> Sergey Arlashin <sergeyarl.maillist at gmail.com> wrote:
> 
>> # cat /etc/pgpool2/pgpool.conf|grep -i esc
>> wd_escalation_command         = '/etc/pgpool2/scripts/escmd.sh'
>> 
>> # /etc/pgpool2/scripts/escmd.sh
>> # echo $?
>> 1
>> 
>> # /etc/init.d/pgpool2 start
>> * Starting pgpool-II pgpool  [ OK ]
>> 
>> /var/log/postgresql/pgpool.log:
>> Jan 21 09:28:52 lb-node1 pgpool[4858]: wd_escalation: escalating to master pgpool
>> Jan 21 09:28:52 lb-node1 pgpool[4858]: wd_escalation: escalation command failed. error code:
>> Jan 21 09:28:54 lb-node1 pgpool[4858]: wd_escalation: escalated to master pgpool successfully
>> Jan 21 09:28:54 lb-node1 pgpool[4858]: wd_init: start watchdog
>> 
>> 
>> Now it seems pgpool fails to show the exit code correctly. 
> 
> Thanks for your quick review. I attached the fixed patch.
> 
>> 
>> 
>> 
>> On Jan 21, 2014, at 9:43 AM, Yugo Nagata <nagata at sraoss.co.jp> wrote:
>> 
>>> Hi,
>>> 
>>> No, it's not bug.
>>> pgpool just ignore wd_escalation command's exit code.
>>> 
>>> However, if you would like the feature, could you try the patch attached?
>>> 
>>> 
>>> On Mon, 20 Jan 2014 23:29:15 +0400
>>> Sergey Arlashin <sergeyarl.maillist at gmail.com> wrote:
>>> 
>>>> Hi!
>>>> 
>>>> When wd_escalation_command fails with exit code '1' pgpool does not log any errors. It logs the following messages instead:
>>>> 
>>>> pgpool[3384]: wd_escalation: escalating to master pgpool
>>>> pgpool[3384]: wd_escalation: escalated to master pgpool successfully
>>>> 
>>>> Is it a bug? 
>>>> 
>>>> --
>>>> Best regards,
>>>> Sergey Arlashin
>>>> _______________________________________________
>>>> pgpool-general mailing list
>>>> pgpool-general at pgpool.net
>>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>> 
>>> 
>>> -- 
>>> Yugo Nagata <nagata at sraoss.co.jp>
>>> <excalation_cmd.patch>
>> 
> 
> 
> -- 
> Yugo Nagata <nagata at sraoss.co.jp>
> <escalation_command.patch>



More information about the pgpool-general mailing list