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

Yugo Nagata nagata at sraoss.co.jp
Wed Jan 22 10:50:03 JST 2014


On Tue, 21 Jan 2014 15:24:02 +0400
Sergey Arlashin <sergeyarl.maillist at gmail.com> wrote:

> Great! Now it is working!

I'm glad to hear that.

> 
> pgpool[31903]: wd_escalation: escalation command failed. exit status: 1
> 
> Thank you!
> 
> Will this patch be included in 3.3.3 ?

Yes, this well be.

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

I'm working on it. I'm considering whether to output error message simply
or to set the pgpool to down status and remove from cluster.

> 
> 
> 
> 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>
> 


-- 
Yugo Nagata <nagata at sraoss.co.jp>


More information about the pgpool-general mailing list