Обсуждение: pgAgent Steps Not Executed

On Jan 16, 2012, at 7:45 AM, Dave Page wrote:

> Depends on what the first step is doing. You have On Error set to Fail, which will cause subsequent steps to be
skippedif an error is detected. What do you see in the job step log for the first step?  

Success:

postgres=#  select * from pgagent.pga_jobsteplog where jslid = 284;
-[ RECORD 1 ]------------------------------
jslid       | 284
jsljlgid    | 211
jsljstid    | 1
jslstatus   | s
jslresult   | 0
jslstart    | 2012-01-13 01:06:05.286733+00
jslduration | 06:01:33.881374
jsloutput   |

In any event, I would expect both steps to appear in the Steps tab of the properties of the job itself. And they don’t.
:-(

David

On Jan 16, 2012, at 9:05 AM, David E. Wheeler wrote:

> postgres=#  select * from pgagent.pga_jobsteplog where jslid = 284;
> -[ RECORD 1 ]------------------------------
> jslid       | 284
> jsljlgid    | 211
> jsljstid    | 1
> jslstatus   | s
> jslresult   | 0
> jslstart    | 2012-01-13 01:06:05.286733+00
> jslduration | 06:01:33.881374
> jsloutput   |

I did just discover that the schedule had an end date set. This happens to me sometimes: I open the schedule’s
propertiesin pgAdmin3, and the current date and time is put in as an end time default value. If I don’t notice and
deleteit, it will be saved. It’s possible this happened to me while the first step was running, so that the second
wouldnever be called. 

Realized this when *neither* step ran last night. That certainly feels like a bug to me: if I have the “End” field
blank(NULL), it should remain blank unless I set it. 

> In any event, I would expect both steps to appear in the Steps tab of the properties of the job itself. And they
don’t.:-( 

This is still an issue, though.

Thanks,

David

Can you get me a dump of the pgagent schema please?

On Mon, Jan 16, 2012 at 6:16 PM, David E. Wheeler <david@justatheory.com> wrote:
> On Jan 16, 2012, at 9:05 AM, David E. Wheeler wrote:
>
>> postgres=#  select * from pgagent.pga_jobsteplog where jslid = 284;
>> -[ RECORD 1 ]------------------------------
>> jslid       | 284
>> jsljlgid    | 211
>> jsljstid    | 1
>> jslstatus   | s
>> jslresult   | 0
>> jslstart    | 2012-01-13 01:06:05.286733+00
>> jslduration | 06:01:33.881374
>> jsloutput   |
>
> I did just discover that the schedule had an end date set. This happens to me sometimes: I open the schedule’s
propertiesin pgAdmin3, and the current date and time is put in as an end time default value. If I don’t notice and
deleteit, it will be saved. It’s possible this happened to me while the first step was running, so that the second
wouldnever be called. 
>
> Realized this when *neither* step ran last night. That certainly feels like a bug to me: if I have the “End” field
blank(NULL), it should remain blank unless I set it. 
>
>> In any event, I would expect both steps to appear in the Steps tab of the properties of the job itself. And they
don’t.:-( 
>
> This is still an issue, though.
>
> Thanks,
>
> David



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

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

On Jan 17, 2012, at 2:47 AM, Dave Page wrote:

> Can you get me a dump of the pgagent schema please?

It’s the standard schema, I think. Attached.

Best,

David

On Tue, Jan 17, 2012 at 5:15 PM, David E. Wheeler <david@justatheory.com> wrote:
> On Jan 17, 2012, at 2:47 AM, Dave Page wrote:
>
>> Can you get me a dump of the pgagent schema please?
>
> It’s the standard schema, I think. Attached.

I really wanted the data in it :-)

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

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

On Jan 17, 2012, at 9:17 AM, Dave Page wrote:

>> It’s the standard schema, I think. Attached.
>
> I really wanted the data in it :-)

Oh, you didn’t say that. Will send privately in a mo.

David

On Mon, Jan 16, 2012 at 6:16 PM, David E. Wheeler <david@justatheory.com> wrote:
> On Jan 16, 2012, at 9:05 AM, David E. Wheeler wrote:
>
>> postgres=#  select * from pgagent.pga_jobsteplog where jslid = 284;
>> -[ RECORD 1 ]------------------------------
>> jslid       | 284
>> jsljlgid    | 211
>> jsljstid    | 1
>> jslstatus   | s
>> jslresult   | 0
>> jslstart    | 2012-01-13 01:06:05.286733+00
>> jslduration | 06:01:33.881374
>> jsloutput   |
>
> I did just discover that the schedule had an end date set. This happens to me sometimes: I open the schedule’s
propertiesin pgAdmin3, and the current date and time is put in as an end time default value. If I don’t notice and
deleteit, it will be saved. It’s possible this happened to me while the first step was running, so that the second
wouldnever be called. 
>
> Realized this when *neither* step ran last night. That certainly feels like a bug to me: if I have the “End” field
blank(NULL), it should remain blank unless I set it. 

Agreed - I've committed a fix for this.

>> In any event, I would expect both steps to appear in the Steps tab of the properties of the job itself. And they
don’t.:-( 
>
> This is still an issue, though.

And that one (which by some fluke worked correctly on Windows, but not my Mac).

Thanks!

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

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

On Jan 18, 2012, at 6:34 AM, Dave Page wrote:

>> Realized this when *neither* step ran last night. That certainly feels like a bug to me: if I have the “End” field
blank(NULL), it should remain blank unless I set it. 
>
> Agreed - I've committed a fix for this.
>
>>> In any event, I would expect both steps to appear in the Steps tab of the properties of the job itself. And they
don’t.:-( 
>>
>> This is still an issue, though.
>
> And that one (which by some fluke worked correctly on Windows, but not my Mac).

Dave++ Thank you very much!

David