Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a3h9Q-0006HS-Er for pgadmin-hackers@arkaria.postgresql.org; Tue, 01 Dec 2015 09:23:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a3h9P-0005ip-Rl for pgadmin-hackers@arkaria.postgresql.org; Tue, 01 Dec 2015 09:23:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a3h9C-0005TX-67 for pgadmin-hackers@postgresql.org; Tue, 01 Dec 2015 09:22:54 +0000 Received: from mail-io0-x22c.google.com ([2607:f8b0:4001:c06::22c]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1a3h97-0001Vz-Ts for pgadmin-hackers@postgresql.org; Tue, 01 Dec 2015 09:22:53 +0000 Received: by iofh3 with SMTP id h3so2825609iof.3 for ; Tue, 01 Dec 2015 01:22:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin-org.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=fduqDE/prMPn5wMuWx2h2rWiw3yVYjDFxTKHgnu9pMM=; b=TG9wwa+vXCRiSut9TRcSoTRTvJMwSculCuE2jF7nyUfIh4G7JMv3Z3EaEVPEE7jgrE v/o364df3QyGA71f8m/HBivjzDkWxPaX62IIq31+P5Au2jp0i9zYjB98p6SnsejIcKzr 4W0EmC+ECdJBEY2GbmdozZQrxP/ObelF/c+T2fXg4Y9WJ//EE/DksSnAsKuTHqryFE7h MEMnsg3v+Xaaq6I3qlNpIgB6BBI5mKJyQWrbgvQwv4CYLLSfziwyuY0EueNC63xJ9Uim fEjyySqEga722nWaxqh8xnmkoaTm3H7AE66U+R1e6VZvsVmJvQIJ3B/TP4HOP4P2ZKtn OCPA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=fduqDE/prMPn5wMuWx2h2rWiw3yVYjDFxTKHgnu9pMM=; b=mOXjllxcqmM0HXgCyNrD220Iacs0gadLB1H3wft6KFa0bY0vkx/AWp7ZF9W5uwGPkN PPwHN9D7lfyV9eh1sxI9sC9vgkZIaYb8ehqcguyITH963Rfz0A3h3u1gObA1I2tF698Z qkrg0YU+DEiwSQUyOQlo7btq6hInqQOIcM2oCOK1AwKiuupGvZf77gSGUVT2iMBG3z6a 7jXQYfey2wj5x35/vwrNHwwNLlqeJML6dKFLWGs155xhlGvduV28xKmYP2XnpCmyCewI ZsqU0XlwpkgHLZDmTfhlNoEp5TfBr5zYUgjO4elnuyN1fvOr+Mj9cgIbzxY3hk9GTe0A d7VQ== X-Gm-Message-State: ALoCoQkK09APU53tcjdIwAGpQ7n9AabY+Ov36oejWrD0nTRJ9C5n7HsIEf+atnkz1VzInkjE+4wz MIME-Version: 1.0 X-Received: by 10.107.158.10 with SMTP id h10mr63118260ioe.63.1448961767496; Tue, 01 Dec 2015 01:22:47 -0800 (PST) Received: by 10.64.5.234 with HTTP; Tue, 1 Dec 2015 01:22:47 -0800 (PST) In-Reply-To: References: Date: Tue, 1 Dec 2015 09:22:47 +0000 Message-ID: Subject: Re: pgagent job failing to halt on failed step From: Dave Page To: Sanket Mehta Cc: pgadmin-hackers , Ashesh Vashi Content-Type: text/plain; charset=UTF-8 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org This is what you just committed right Ashesh? On Tue, Dec 1, 2015 at 5:36 AM, Sanket Mehta 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 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers