pgAgent problem - always runs jobs at every poll - Mailing list pgadmin-support

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