[pgadmin-support] pgAgent problem - always runs jobs at every poll

[Andy Tilley]

 

Hi there,

 

I'm having an issue with pgAgent which I'm sure is related to this bug:

 

http://archives.postgresql.org/pgadmin-support/2007-11/msg00098.php

 

I'm on Solaris x86, using pgAdmin 1.8.0 (the latest available build for this
OS)

 

When I start pgagent, I get this error though:

 

DEBUG: Database sanity check

DEBUG: Clearing zombies

18:56:08: Error: Cannot get the hostname (error 0: Error 0)

DEBUG: Checking for jobs to run

 

 

I've looked through the source, and it's probably here that it's failing.

 

int MainRestartLoop(DBconn *serviceConn)

.

wxString hostname = wxGetFullHostName();

.

 

Any idea as to why the hostname is not being returned? This is the cause of
the problem, I think.

Essentially, the SQL being issued is this:

 

            SELECT J.jobid 

              FROM pgagent.pga_job J 

             WHERE jobenabled 

               AND jobagentid IS NULL 

               AND jobnextrun <= now() 

               AND jobhostagent = '' OR jobhostagent = ''

             ORDER BY jobnextrun

 

So it ALWAYS returns the jobs, regardless of whether they're enabled or not.
Hence, they run at every single poll!

 

Many thanks

Andy Tilley