Bug 1055162 - Job and step tables not cleaned after the failure or completion of some tasks.
Summary: Job and step tables not cleaned after the failure or completion of some tasks.
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine
Version: 3.2.0
Hardware: x86_64
OS: Linux
medium
medium
Target Milestone: ---
: 3.3.1
Assignee: Liran Zelkha
QA Contact: Tareq Alayan
URL:
Whiteboard: infra
Depends On: 1040952
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-01-19 10:01 UTC by rhev-integ
Modified: 2019-04-28 09:30 UTC (History)
16 users (show)

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.
Clone Of: 1040952
Environment:
Last Closed: 2014-03-03 13:31:25 UTC
oVirt Team: Infra
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2014:0227 0 normal SHIPPED_LIVE rhevm 3.3.1 bug fix update 2014-03-03 18:29:31 UTC
oVirt gerrit 23170 0 None None None Never
oVirt gerrit 23171 0 None None None Never
oVirt gerrit 26293 0 None None None Never

Comment 2 Tareq Alayan 2014-02-09 16:16:36 UTC 
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 13:31:25 UTC 
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 08:50:33 UTC 
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.