Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1055162 - Job and step tables not cleaned after the failure or completion of some tasks.
Job and step tables not cleaned after the failure or completion of some tasks.
Status: CLOSED ERRATA
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine (Show other bugs)
3.2.0
x86_64 Linux
medium Severity medium
: ---
: 3.3.1
Assigned To: Liran Zelkha
Tareq Alayan
infra
: ZStream
Depends On: 1040952
Blocks:
  Show dependency treegraph
 
Reported: 2014-01-19 05:01 EST by rhev-integ
Modified: 2016-02-10 14:44 EST (History)
17 users (show)

See Also:
Fixed In Version: is34
Doc Type: Bug Fix
Doc Text:
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.
Story Points: ---
Clone Of: 1040952
Environment:
Last Closed: 2014-03-03 08:31:25 EST
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: Infra
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)


External Trackers
Tracker ID Priority Status Summary Last Updated
oVirt gerrit 23170 None None None Never
oVirt gerrit 23171 None None None Never
oVirt gerrit 26293 None None None Never
Red Hat Product Errata RHBA-2014:0227 normal SHIPPED_LIVE rhevm 3.3.1 bug fix update 2014-03-03 13:29:31 EST

  None (edit)
Comment 2 Tareq Alayan 2014-02-09 11:16:36 EST
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
Comment 4 errata-xmlrpc 2014-03-03 08:31:25 EST
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
Comment 5 Michal Skrivanek 2014-04-04 04:50:33 EDT
note the fix has been reverted in 3.3.z. See parent bug for details

Note You need to log in before you can comment on or make changes to this bug.