Skip site navigation (1) Skip section navigation (2)

Re: pgAgent STDERR and Time Zone Questions

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" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: pgAgent STDERR and Time Zone Questions
Date: 2011-12-23 17:19:24
Message-ID: CA+OCxoy-6rrHu9LtzgWjivx=oSeDbEHCAJ6jE_Q4DnnfSZDkEA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
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

In response to

Responses

pgadmin-support by date

Next:From: David E. WheelerDate: 2011-12-23 17:24:18
Subject: Re: pgAgent STDERR and Time Zone Questions
Previous:From: David E. WheelerDate: 2011-12-23 16:47:58
Subject: Re: pgAgent STDERR and Time Zone Questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group