Previously, the job and step tables would not be cleaned after the failure or completion of some tasks. This would result in numerous tasks being marked as still running in the tasks tab. With this update, periodic job deletion has now been updated so that jobs causing database errors will be correctly cleared.
verified.
1. started a task migrate VM.
2. stop engine immediately.
3. status of job says SATARTED
4. start engine
5. status of job says UNKNOWN
6. jobs table is cleaned out after amount of minutes defined in FailedJobCleanupTimeInMinutes in vdc_options table
select * from vdc_options where option_name in ('SucceededJobCleanupTimeInMinutes','FailedJobCleanupTimeInMinutes');
select job_id, correlation_id, action_type, status, start_time, last_update_time from job;
-[ RECORD 1 ]----+-------------------------------------
job_id | 85a4febd-ae26-4ae3-abf0-13f38db91b4c
correlation_id | 6429c62b
action_type | MigrateVm
status | UNKNOWN
start_time | 2014-02-09 17:51:10.373+02
last_update_time | 2014-02-09 17:52:35.266+02
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.
http://rhn.redhat.com/errata/RHBA-2014-0227.html
verified. 1. started a task migrate VM. 2. stop engine immediately. 3. status of job says SATARTED 4. start engine 5. status of job says UNKNOWN 6. jobs table is cleaned out after amount of minutes defined in FailedJobCleanupTimeInMinutes in vdc_options table select * from vdc_options where option_name in ('SucceededJobCleanupTimeInMinutes','FailedJobCleanupTimeInMinutes'); select job_id, correlation_id, action_type, status, start_time, last_update_time from job; -[ RECORD 1 ]----+------------------------------------- job_id | 85a4febd-ae26-4ae3-abf0-13f38db91b4c correlation_id | 6429c62b action_type | MigrateVm status | UNKNOWN start_time | 2014-02-09 17:51:10.373+02 last_update_time | 2014-02-09 17:52:35.266+02