Just chiming in quickly,
We experienced exactly the same behavior with pg 9.4.
It was consistent across the 18 database servers that we upgraded from
9.3 to 9.4.
A job would complete successfully, and then just remain in 'running' state.
We tried purging and re-installing pg and pgadmin/agent cleanly and
still had the same results.
Eventually in frustration we just copied over the pgagent binary
(nothing else) from a server running 9.3 and amazingly stuff started
working.
All I can really contribute to this issue discussion is our "path to
the problem".
Initial OS: Ubuntu 12 LTS x64 running pg 9.1 from the pgdg repos
We were running 9.3 without any issues on those servers. All pgagent
jobs would complete and run as expected
We upgraded the OS to Ubuntu 14.04 LTS
We then upgraded pg to 9.4
Post-upgrade, pgagent (which was also upgraded in the process) started
exhibiting the behavior as described in the thread
Leonard
On Wed, Jul 22, 2015 at 12:33 PM, Josh Berkus <josh@agliodbs.com> wrote:
> On 07/21/2015 11:29 PM, Ashesh Vashi wrote:
>> On Wed, Jul 22, 2015 at 11:56 AM, Sanket Mehta
>> <sanket.mehta@enterprisedb.com <mailto:sanket.mehta@enterprisedb.com>>
>> wrote:
>>
>> Hi Dave,
>>
>> As per our discussion, I have tried to reproduce the issue, but it
>> seems jobs are running fine without any problem.
>> Hence the issue is not reproducible on my system.
>>
>> Josh,
>>
>> As we're unable to reproduce the issue at our end, can you please
>> generate the logs after setting the log level to debug2 (i.e. -l2) for
>> analyzing the issue?
>
> As I said before, the logs show nothing of interest. There are no
> errors. just polling for new jobs.
>
> Anyway, the failing system has now been shut down, so we'll need to
> chalk this particular failure up to "wierd stuff".
>
>
> --
> Josh Berkus
> PostgreSQL Experts Inc.
> http://pgexperts.com
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support