From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Guy Rouillier <guyr(at)burntmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: PG 9.1 Windows 7 64-bit pgAdmin says all pgAgent jobs fail |
Date: | 2012-03-01 09:20:04 |
Message-ID: | CA+OCxozvcSYg+95aiqM40kSeYRGw=9Y3tmUO2v4bnN6WcCwtJw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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?
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-03-01 09:29:59 | Re: Set auto-vacuum options below 0 |
Previous Message | Bartosz Dmytrak | 2012-03-01 07:27:58 | Set auto-vacuum options below 0 |