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

On Fri, Mar 2, 2012 at 4:02 AM, Guy Rouillier <guyr(at)burntmail(dot)com> wrote:
> On 3/1/2012 4:20 AM, Dave Page wrote:
>>
>> On Thu, Mar 1, 2012 at 4:22 AM, Guy Rouillier<guyr(at)burntmail(dot)com>  wrote:
>>>
>>> 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.
>>
>>
>> And the step output?
>
>
> I think you are referring to the "Output" column in the Statistics tab.
>  That column is completely blank for all tests.

Can you confirm from the server log (on the server on which the step
runs), that the step does actually run or not?

Assuming it does, try running pgAgent with the log level increased to
WARNING to see if anything shows up there.

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

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