Re: PG 9.1 Windows 7 64-bit pgAdmin says all pgAgent jobs fail

On 2/29/2012 4:13 AM, Dave Page wrote:
> On Wed, Feb 29, 2012 at 7:39 AM, Guy Rouillier<guyr(at)burntmail(dot)com> wrote:
>> So, now the only remaining issue is that in PgAdmin, the Statistics tab
>> shows all runs with a status of "Failed". But the datetest table is getting
>> updated properly. I see no events in the Application event log. Finally, I
>> ran pgAgent from the command line in DEBUG mode:
>>
>> DEBUG: Checking for jobs to run
>> DEBUG: Creating job thread for job 2
>> DEBUG: Creating DB connection: user=postgres port=5432 hostaddr=1270.0.1
>> password=xxxx dbname=postgres
>> DEBUG: Allocating new connection to database postgres
>> DEBUG: Starting job: 2
>> DEBUG: Sleeping...
>> DEBUG: Creating DB connection: user=postgres port=5432 hostaddr=1270.0.1
>> password=xxxx dbname=postgres dbname=postgres
>> DEBUG: Allocating new connection to database postgres
>> DEBUG: Executing SQL step 3 (part of job 2)
>> DEBUG: Returning connection to database postgres
>> DEBUG: Returning connection to database postgres
>> DEBUG: Completed job: 2
>> DEBUG: Destroying job thread for job 2
>> DEBUG: Checking for jobs to run
>> DEBUG: Sleeping...
>>
>> The run also shows a status of "Failed". Any idea why? Thanks.
>
> The step or the job shows as failed? What's the output from the step?

Both the step and the job are shown as failed. Thanks.

--
Guy Rouillier