Re: pgagent job failing to halt on failed step - Mailing list pgadmin-hackers

From Dave Page
Subject Re: pgagent job failing to halt on failed step
Date
Msg-id CA+OCxozDyW6WLXCcosQQcs3zdL_aEn_xJRFc9WeY3kAzZGoEhQ@mail.gmail.com
Whole thread Raw
In response to pgagent job failing to halt on failed step  (Sanket Mehta <sanket.mehta@enterprisedb.com>)
Responses Re: pgagent job failing to halt on failed step  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
List pgadmin-hackers
This is what you just committed right Ashesh?

On Tue, Dec 1, 2015 at 5:36 AM, Sanket Mehta
<sanket.mehta@enterprisedb.com> wrote:
>
> Hi,
>
> There is an issue in current pgagent code as explained below:
>
> Issue:
> In batch mode if user creates a job with multiple job steps then if first
> jobstep gets executed successfully then even if 2nd step is a failure, job
> will not halt at that point and will complete its execution. which is not
> the expected result.
>
> Analysis:
> The main reason for this issue is that in batch mode, when first step is
> executed successfully, flag succeeded will be set to true, but when the 2nd
> step gets failed, its not getting reset to false which is why job does not
> halt at the same instance and continues executing next steps.
>
> I have resolved this issue and patch is attached with this mail for review.
> Please do review the patch and let me know in case anything is missing.
> Regards,
> Sanket Mehta
> Sr Software engineer
> Enterprisedb
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgadmin-hackers by date:

Previous
From: Ashesh Vashi
Date:
Subject: pgAgent commit: Set 'succeeded' flag to true/false by checking for the
Next
From: Ashesh Vashi
Date:
Subject: Re: pgagent job failing to halt on failed step