Re: pgAgent STDERR and Time Zone Questions

On Jan 11, 2012, at 8:54 AM, David E. Wheeler wrote:

> Maybe I can install the Git build on the production box that’s having the problems and squeeze in a few tests between hourly runs of production code…I’ll try to do that today.

Done. Here's what I got with the RPM build running:

postgres=# select * from pgagent.pga_jobsteplog where jsljlgid = 180;
-[ RECORD 1 ]------------------------------
jslid | 225
jsljlgid | 180
jsljstid | 25
jslstatus | s
jslresult | 5
jslstart | 2012-01-11 20:09:23.525634+00
jslduration | 00:00:00.010944
jsloutput |

Not right. Then with the patched Git build:

postgres=# select * from pgagent.pga_jobsteplog where jsljlgid = 181;
-[ RECORD 1 ]------------------------------
jslid | 226
jsljlgid | 181
jsljstid | 25
jslstatus | f
jslresult | 255
jslstart | 2012-01-11 20:17:50.985678+00
jslduration | 00:00:00.007648
jsloutput |

Which looks just fine. The log file was empty again and the error sent to the terminal (STDERR, I'm sure).

So either the changes in 2aec3bc473e583f8fa07e133bc8def60ff1c09fe or some other commit fixed the underlying problem, or something is wonky with the RPM. I can’t imagine what, though, because I build from Git exactly the same way as Devrim has things specified in the pgagent.spec.

http://svn.pgrpms.org/browser/rpm/redhat/9.1/pgagent/EL-5/pgagent.spec

I can leave the RPM build in place for the moment, but once I get some monitoring stuff written, I will either install a new RPM (assuming Devrim has created one) or I will build from Git and install it.

Thanks,

David