On Fri, Jul 13, 2018 at 11:23 AM, Ajlinux <ajli...@protonmail.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
