<div class="Section1"><p class="MsoNormal"> <p class="MsoNormal">Hi there,<p class="MsoNormal"> <p
class="MsoNormal">I’mhaving an issue with pgAgent which I’m sure is related to this bug:<p class="MsoNormal"> <p
class="MsoNormal"><spanstyle="color:#1F497D"><a
href="http://archives.postgresql.org/pgadmin-support/2007-11/msg00098.php">http://archives.postgresql.org/pgadmin-support/2007-11/msg00098.php</a></span><p
class="MsoNormal"> <pclass="MsoNormal">I’m on Solaris x86, using pgAdmin 1.8.0 (the latest available build for this
OS)<pclass="MsoNormal"> <p class="MsoNormal">When I start pgagent, I get this error though:<p class="MsoNormal"> <p
class="MsoNormal">DEBUG:Database sanity check<p class="MsoNormal">DEBUG: Clearing zombies<p
class="MsoNormal"><b>18:56:08:Error: Cannot get the hostname (error 0: Error 0)</b><p class="MsoNormal">DEBUG: Checking
forjobs to run<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal">I’ve looked through the source, and it’s
probablyhere that it’s failing.<p class="MsoNormal"> <p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;
font-family:"Courier New"">int MainRestartLoop(DBconn *serviceConn)</span><p class="MsoNormal">…<p class="MsoNormal"
style="text-autospace:none"><spanstyle="font-size:10.0pt;
font-family:"Courier New"">wxString hostname = wxGetFullHostName();</span><p class="MsoNormal">…<p
class="MsoNormal"> <pclass="MsoNormal">Any idea as to why the hostname is not being returned? This is the cause of the
problem,I think.<p class="MsoNormal">Essentially, the SQL being issued is this:<p class="MsoNormal"> <p
class="MsoNormal"> SELECT J.jobid <p class="MsoNormal"> FROM pgagent.pga_job J <p
class="MsoNormal"> WHERE jobenabled <p class="MsoNormal"> AND jobagentid IS NULL <p
class="MsoNormal"> AND jobnextrun <= now() <p class="MsoNormal"><b> AND jobhostagent = ''
ORjobhostagent = ''</b><p class="MsoNormal"> ORDER BY jobnextrun<p class="MsoNormal"> <p
class="MsoNormal">Soit ALWAYS returns the jobs, regardless of whether they’re enabled or not. Hence, they run at every
singlepoll!<p class="MsoNormal"> <p class="MsoNormal">Many thanks<p class="MsoNormal">Andy Tilley<p
class="MsoNormal"> <pclass="MsoNormal"> </div>