Bug 1072527

Summary: bogus DB entry - VDS_INITIATED_RUN_VM_FAIL event_up_name
Product: Red Hat Enterprise Virtualization Manager Reporter: Jiri Belka <jbelka>
Component: ovirt-engineAssignee: Eli Mesika <emesika>
Status: CLOSED CURRENTRELEASE QA Contact: Jiri Belka <jbelka>
Severity: high Docs Contact:
Priority: unspecified    
Version: 3.4.0CC: aberezin, bazulay, emesika, gklein, iheim, lpeer, michal.skrivanek, oourfali, pstehlik, rbalakri, Rhev-m-bugs, yeylon
Target Milestone: ---   
Target Release: 3.5.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: infra
Fixed In Version: ovirt-3.5.0-alpha2 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-02-17 17:12:38 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1042829    
Bug Blocks: 1142923, 1156165    

Description Jiri Belka 2014-03-04 17:28:31 UTC
Description of problem:

BZ1042829 introduced 'Failed to restart VM on a different host' event from notification subscription. In the process there was error in event_up_name - VDS_INITIATED_RUN_VM_FAIL vs VDS_INITIATED_RUN_VM_FAILED.

But instead of removing bogus VDS_INITIATED_RUN_VM_FAIL, just new VDS_INITIATED_RUN_VM_FAILED was added.

Please clean after yourself.

engine=# select * from event_subscriber ;
            subscriber_id             |        event_up_name        |  method_address   | tag_name | notification_method 
--------------------------------------+-----------------------------+-------------------+----------+---------------------
 fdfc627c-d875-11e0-90f0-83df133b58cc | VDS_INITIATED_RUN_VM_FAILED | jbelka |          | EMAIL
(1 row)

engine=# select * from event_map where event_up_name ilike '%run_vm%';
        event_up_name        | event_down_name 
-----------------------------+-----------------
 VDS_INITIATED_RUN_VM_FAIL   | 
 VDS_INITIATED_RUN_VM_FAILED | 
(2 rows)

Version-Release number of selected component (if applicable):
av2 rhevm-3.4.0-0.3.master.el6ev.noarch

How reproducible:
100%

Steps to Reproduce:
1. check db
2.
3.

Actual results:
forgotten wrong event_up_name

Expected results:
remove useless stuff

Additional info:
it could be fun to search what else is rotting in the DB :)

Comment 1 Michal Skrivanek 2014-03-06 09:16:29 UTC
moving to infra based on the original patch

Comment 2 Jiri Belka 2014-06-12 14:49:18 UTC
ok, ovirt-3.5-pre / ovirt-engine-dbscripts-3.5.0-0.0.master.20140605145557.git3ddd2de.el6.noarch

Comment 3 Eyal Edri 2015-02-17 17:12:38 UTC
rhev 3.5.0 was released. closing.