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: 200806121452.m5CEqjBp057212@wwwmaster.postgresql.org (view raw or flat)
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.

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-2014 The PostgreSQL Global Development Group