Re: pgAgent STDERR and Time Zone Questions
On Dec 21, 2011, at 1:57 AM, Dave Page wrote:
Thanks. The logic used to determine the success or failure of a step
is pretty simple:
if (rc == 0)
stepstatus = wxT("s");
else
stepstatus = steps->GetString(wxT("jstonerror"));
Which is the reason why you see 0's show up as "success". The non-zero
exit codes will show the same status as the
pgagent.pga_jobstep.jstonerror column holds for the step in question.
The problem is not that 0 shows up as "Success", which I expect. The problem is that the non-0 does, too. This is in the Step Statistics view:
Note that Run 1, with an exit code of 127, is listed as "Successful". That does not seem right to me. The record for that row is:
postgres=# select * from pgagent.pga_jobsteplog where jslid = 1;
-[ RECORD 1 ]------------------------------
jslid | 1
jsljlgid | 1
jsljstid | 1
jslstatus | s
jslresult | 127
jslstart | 2011-12-15 16:49:25.038705-08
jslduration | 00:00:00.024641
jsloutput |
-[ RECORD 1 ]------------------------------
jslid | 1
jsljlgid | 1
jsljstid | 1
jslstatus | s
jslresult | 127
jslstart | 2011-12-15 16:49:25.038705-08
jslduration | 00:00:00.024641
jsloutput |
Which makes me think that either `rc`is not what gets put into jsresult, or that `steps->GetString(wxT("jstonerror"))` is returning "s", too. Or that I’m completely misunderstanding something, of course. :-)
Best,
David
Вложения
В списке pgadmin-support по дате отправления: