Re: pgAgent STDERR and Time Zone Questions

On Dec 28, 2011, at 2:08 PM, David E. Wheeler wrote:

>> OK, well I won't try to get you debugging wxWidgets code in GDB as
>> that's just painful, so please build from source having applied the
>> attached patch and then test your jobs with the log level set to DEBUG
>> and capture the output so we can compare it with what ends up in the
>> pga_jobsteplog table. Don't throw away the build env when you're done
>> - we may need to do some more debugging later.
>>
>> Note that the patch was written against GIT master.
>
> Thanks. This will probably have to wait until next week, as I’m a bit stretched between family, travel, and $work.

Finally got back to this. Naturally, the car works perfectly when it’s in the shop.

I installed the pgrpms version of pgAgent, which Devrim uploaded a few weeks ago.
 http://yum.pgrpms.org/9.1/redhat/rhel-5-i386/pgagent_91-3.0.1-1.rhel5.i386.rpm

With that, I can create a job with a single batch step. All it does is this:
   perl -e 'die "WTF"'

That results in:

postgres=# select * from pgagent.pga_jobsteplog where jslid = 8;
-[ RECORD 1 ]-----------------------------
jslid       | 8
jsljlgid    | 8
jsljstid    | 1
jslstatus   | f
jslresult   | -1
jslstart    | 2012-01-10 14:28:26.95867-08
jslduration | 00:00:00.011809
jsloutput   |

Which seems fine. Then, with the patched version from SVN, I fire it up and run the same job and get:

postgres=# select * from pgagent.pga_jobsteplog where jslid = 9;
-[ RECORD 1 ]------------------------------
jslid       | 9
jsljlgid    | 9
jsljstid    | 1
jslstatus   | f
jslresult   | 255
jslstart    | 2012-01-10 14:34:05.243314-08
jslduration | 00:00:00.008179
jsloutput   |

Which is different, but at least still a failure. (Nothing was logged; I ran it with `/usr/bin/pgagent -s
/home/dwheeler/pgagent.log-l DEBUG hostaddr=127.0.0.1 dbname=postgres user=postgres`.) 

Going back to the box that originally had this problem, which also uses Devrim’s RPM, I created a new test job with
exactlythe same step as above. There I get: 

postgres=# select * from pgagent.pga_jobsteplog where jsljlgid = 155;
-[ RECORD 1 ]------------------------------
jslid       | 177
jsljlgid    | 155
jsljstid    | 21
jslstatus   | s
jslresult   | 5
jslstart    | 2012-01-10 22:18:42.995252+00
jslduration | 00:00:00.013335

Which just seems wrong. Both boxes are running CentOS 5.5 (Linux 2.6.18-194.el5). Might there be a difference in the
versionof Wx installed or something to account for this? 

Thanks,

David