The following bug has been logged online:
Bug reference: 4234
Logged by: Lawrence Cohan
Email address: lawrencec@1shoppingcart.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.