BUG #4234: VACUUM dies in without error in a PGAgent job

From: "Lawrence Cohan" <lawrencec(at)1shoppingcart(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4234: VACUUM dies in without error in a PGAgent job
Date: 2008-06-12 14:52:45
Message-ID: 200806121452.m5CEqjBp057212@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4234
Logged by: Lawrence Cohan
Email address: lawrencec(at)1shoppingcart(dot)com
PostgreSQL version: 8.2.5
Operating system: Linux 4.1.1
Description: VACUUM dies in without error in a PGAgent job
Details:

We are using PGAgent to do the maintenance and I noticed from the server
status that there's no VACCUM running against the database however the job
still says "Running" and the value is still "r" on the job step from
pgagent.pga_jobsteplog.jslstatus
The job has three steps as described below:

1_Analyze_db that does analyze verbose;
2_Vaccum_db that does vacuum verbose:
3_Analyze_db that does analyze verbose;

the second step is set to "Ignore" if Fail so the analyze will kick off
anyway.

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Enke 2008-06-12 15:07:23 BUG #4056: docu wrong for sqlerrmc[70]
Previous Message Arkady Sherman 2008-06-12 14:09:39 BUG #4233: Unable to install postgresql-8.3.3 into WindowsXP, an installer error