From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | "David E(dot) Wheeler" <david(at)justatheory(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgAgent STDERR and Time Zone Questions |
Date: | 2011-12-22 09:44:12 |
Message-ID: | CA+OCxozX+2ZMJocD5iTF4r7vm7MYtvJheRxean5voBv_O85PQA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Wed, Dec 21, 2011 at 10:08 PM, David E. Wheeler <david(at)justatheory(dot)com>wrote:
> 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 |
>
> 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. :-)
>
What's in pgagent.pga_jobstep where jstid in (1, 3, 7)?
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | David E. Wheeler | 2011-12-22 17:44:05 | Re: pgAgent STDERR and Time Zone Questions |
Previous Message | Pietro A Bertini | 2011-12-22 08:02:20 | Re: Compiling pgadmin3-1.14.1 on open BSD 5.0 |