Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

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
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group