Re: pgAgent STDERR and Time Zone Questions

On Friday, December 23, 2011, David E. Wheeler <david(at)justatheory(dot)com>
wrote:
> On Dec 23, 2011, at 2:25 AM, Dave Page wrote:
>
>> Hmm, that looks like it should work. I've just run some tests here,
>> and can't find anything wrong. Successes are reported as such, and
>> non-zero return values are reported as whatever the "on error" setting
>> says they should be. Subsequent steps in a job are either processed or
>> skipped correctly based on the return value and on error setting of
>> the previous step(s).
>>
>> postgres=# postgres=# select * from pgagent.pga_jobsteplog;
>> jslid | jsljlgid | jsljstid | jslstatus | jslresult |
>> jslstart | jslduration | jsloutput
>>
-------+----------+----------+-----------+-----------+-------------------------------+-----------------+------------------------
>> 1 | 1 | 1 | s | 127 | 2011-12-23
>> 10:14:37.108296+00 | 00:00:00.182375 |
>> 2 | 2 | 1 | s | 127 | 2011-12-23
>> 10:15:02.155214+00 | 00:00:00.052011 |
>
> Should those 127s be "s"?

No, I had it set to ignore failures then.

>> 3 | 3 | 1 | f | 127 | 2011-12-23
>> 10:16:02.334791+00 | 00:00:00.0732 |
>> 4 | 4 | 1 | f | 127 | 2011-12-23
>> 10:17:02.514272+00 | 00:00:00.113905 |
>> 5 | 5 | 1 | f | 127 | 2011-12-23
>> 10:18:02.645482+00 | 00:00:00.087998 | This will be an error.
>> 6 | 6 | 1 | f | 127 | 2011-12-23
>> 10:19:02.780288+00 | 00:00:00.08348 | This will be an error.
>> 7 | 7 | 1 | i | 127 | 2011-12-23
>> 10:20:02.903824+00 | 00:00:00.201093 | This will be an error.
>> 8 | 7 | 3 | s | 0 | 2011-12-23
>> 10:20:03.106797+00 | 00:00:00.004515 | This will be a success
>> 9 | 8 | 1 | i | 127 | 2011-12-23
>> 10:21:03.088051+00 | 00:00:00.006627 | This will be an error.
>> 10 | 8 | 3 | s | 0 | 2011-12-23
>> 10:21:03.096869+00 | 00:00:00.006623 | This will be a success
>> (10 rows)
>>
>> Is it possible you've got the config right now, but the logs you
>> posted were from a different config?
>
> Haven’t changed anything. I believe it’s the default configuration, as
installed by Devrim’s new RPMs. Is there something else I should show you?

Everything looks fine. Care to try some debugging?

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company