pgAgent reporting success for non-zero results

From: Chris Earle <chris(dot)earle(at)doubleiq(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: pgAgent reporting success for non-zero results
Date: 2012-11-22 20:33:00
Message-ID: 6c07c3741adf30f447fff48582d5ff68@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We recently recompiled pgAgent 3.3.0 for our Centos x86 64 environment
to over come the problem of steps with a non-zero result codes being
reported as successful.
What appears to be happening is if the first step has a non-zero result
then it correctly has the status of Failed but if it is a later step that
is non-zero then it always has Successful.

To test this is setup a job of two steps and ran it in two orders
Job: 'Test'
Step: 1.exit 1, Definition: exit 1; - Result 1, Status: Failed
Step: 2.exit 0, Definition: exit 0; - <not ran>

Job: 'Test'
Step: 1.exit 0, Definition: exit 0; - Result 0, Status: Successful
Step: 2.exit 1, Definition: exit 1; - Result 1, Status: Successful

Does anyone any ideas of what is causing this behaviour or how to work
around this?

Browse pgsql-general by date

  From Date Subject
Next Message zhangshzh 2012-11-23 03:07:03 Invalid argument
Previous Message Adrian Klaver 2012-11-22 18:59:15 Re: get column name passed to a function