Re: pgAgent STDERR and Time Zone Questions

<br /><br />On Friday, December 23, 2011, David E. Wheeler <<a
href="mailto:david@justatheory.com">david@justatheory.com</a>>wrote:<br />> On Dec 23, 2011, at 2:25 AM, Dave
Pagewrote:<br />><br />>> Hmm, that looks like it should work. I've just run some tests here,<br /> >>
andcan't find anything wrong. Successes are reported as such, and<br />>> non-zero return values are reported as
whateverthe "on error" setting<br />>> says they should be. Subsequent steps in a job are either processed or<br
/>>> skipped correctly based on the return value and on error setting of<br />>> the previous step(s).<br
/>>><br/>>> postgres=# postgres=# select * from pgagent.pga_jobsteplog;<br />>> jslid | jsljlgid |
jsljstid| jslstatus | jslresult |<br /> >> jslstart            |   jslduration   |       jsloutput<br />>>
-------+----------+----------+-----------+-----------+-------------------------------+-----------------+------------------------<br
/>>>    1 |        1 |        1 | s         |       127 | 2011-12-23<br /> >> 10:14:37.108296+00 |
00:00:00.182375|<br />>>     2 |        2 |        1 | s         |       127 | 2011-12-23<br />>>
10:15:02.155214+00| 00:00:00.052011 |<br />><br />> Should those 127s be "s"?<br /><br />No, I had it set to
ignorefailures then.<br /><br />>>     3 |        3 |        1 | f         |       127 | 2011-12-23<br />>>
10:16:02.334791+00| 00:00:00.0732   |<br />>>     4 |        4 |        1 | f         |       127 | 2011-12-23<br
/>>> 10:17:02.514272+00 | 00:00:00.113905 |<br />>>     5 |        5 |        1 | f         |       127 |
2011-12-23<br/>>> 10:18:02.645482+00 | 00:00:00.087998 | This will be an error.<br />>>     6 |        6 |
      1 | f         |       127 | 2011-12-23<br /> >> 10:19:02.780288+00 | 00:00:00.08348  | This will be an
error.<br/>>>     7 |        7 |        1 | i         |       127 | 2011-12-23<br />>> 10:20:02.903824+00 |
00:00:00.201093| This will be an error.<br /> >>     8 |        7 |        3 | s         |         0 |
2011-12-23<br/>>> 10:20:03.106797+00 | 00:00:00.004515 | This will be a success<br />>>     9 |        8 |
      1 | i         |       127 | 2011-12-23<br /> >> 10:21:03.088051+00 | 00:00:00.006627 | This will be an
error.<br/>>>    10 |        8 |        3 | s         |         0 | 2011-12-23<br />>> 10:21:03.096869+00 |
00:00:00.006623| This will be a success<br /> >> (10 rows)<br />>><br />>> Is it possible you've got
theconfig right now, but the logs you<br />>> posted were from a different config?<br />><br />> Haven’t
changedanything. I believe it’s the default configuration, as installed by Devrim’s new RPMs. Is there something else I
shouldshow you?<br /><br />Everything looks fine. Care to try some debugging?<br /><br />-- <br />Dave Page<br />Blog:
<ahref="http://pgsnake.blogspot.com" target="_blank">http://pgsnake.blogspot.com</a><br />Twitter: @pgsnake<br /><br
/>EnterpriseDBUK: <a href="http://www.enterprisedb.com" target="_blank">http://www.enterprisedb.com</a><br /> The
EnterprisePostgreSQL Company<br /><br />