Re: pgagent hangs forever in "r" state

On 07/06/2015 10:26 AM, Josh Berkus wrote:
> All,
>
> On the same server with the SQL errors (sequences are cleaned up now),
> we're having pgagent start all jobs in the "r" state, log the first step
> in each job in the "r" state, and then hang forever (or, at least for
> three days). At this point, 8 different jobs are in "r" state.

... as an update, what it appears to be doing is executing the first
step of each job, successfully. Then, for some reason, it attempts to
destroy that jobthread after just the first step. I say "attempts"
because that child backend is still running, and none of pga_job,
pga_joblog, or pga_jobsteplog get updated.

I've looked in jobs.cpp and pgAgent.cpp, and I can't figure out what
would cause it to stop after the first step. All of the steps I've
looked at are regular queries, and can be successfully executed by hand.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com