Re: Help with pgagent

On Fri, Jul 13, 2018 at 11:23 AM, Ajlinux <ajlinux(at)protonmail(dot)com> wrote:

> Hi
>
> I was wondering if anyone can help. I am running a Postgresql 9.4 server
> on Ubuntu 14.04 and having issues with pageant jobs saying that they are
> running but the jobs are not doing anything. This is not every job and it
> appears that the issue happens at random. I am running pgaent v3.4.1.
>
> I was just wondering if anyone has any code to help diagnose pageant
> issues. The executable works fine and does not crash and there are no
> errors in the pageant log.
>

Have you tried increasing the log level to get more detailed info about the
schedulers operation?

>
> Also, does anyone one have code they can share to reset stuck jobs in the
> pageant tables as I am doing but not sure if I am doing it correctly as
> have a limited understanding of how all the pieces fit together.
>

The agent should run any job that has it's "jobnextrun" value in the
pga_job table less than or equal to the current time, with jobenabled =
true and jobagentid = NULL, each time it checks for jobs to run. If you've
got an entry in that table for a job that you think should have run but did
not, please share the data and we may be able to see why.

>
> Also does anyone have a technical overview of how it works?
>

Not really, unfortunately.

>
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company