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