Bug 1093283

Summary: db upgrade fails if there's a subscription to VDS_HIGH_NETWORK_USE event
Product: Red Hat Enterprise Virtualization Manager Reporter: Ohad Basan <obasan>
Component: ovirt-engineAssignee: Eli Mesika <emesika>
Status: CLOSED CURRENTRELEASE QA Contact: Martin Pavlik <mpavlik>
Severity: urgent Docs Contact:
Priority: urgent    
Version: 3.4.0CC: aberezin, acathrow, eedri, emesika, gklein, iheim, knesenko, lpeer, oourfali, pstehlik, Rhev-m-bugs, yeylon
Target Milestone: ---   
Target Release: 3.4.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: infra
Fixed In Version: org.ovirt.engine-root-3.4.0-17 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 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:

Description Ohad Basan 2014-05-01 07:48:27 UTC 
Description of problem:

During the 3.3 to 3.4 db upgrade
if there is a VDS_HIGH_NETWORK_USE event in event_subscriber the db upgrade fails with fk violation

update event_map set event_up_name = 'HOST_INTERFACE_HIGH_NETWORK_USE' where event_up_name='VDS_HIGH_NETWORK_USE';
Comment 1 Ohad Basan 2014-05-01 07:57:47 UTC 
Just an addition.
the problematic sql file is
03_05_0160_add_host_interface_high_network_use_event.sql
Comment 2 Martin Pavlik 2014-06-02 08:41:44 UTC 
please provide test steps
Comment 3 Eli Mesika 2014-06-02 09:09:08 UTC 
1) Have a running 3.3 installation
2) From UI Users/Event Notifications subscribe any user to event VDS_HIGH_NETWORK_USE
3) Upgrade your system to 3.4
4) Open UI/Event Notifications for the user in 2) , you should see that this user is subscribed now to  HOST_INTERFACE_HIGH_NETWORK_USE
Comment 4 Martin Pavlik 2014-06-02 13:51:20 UTC 
verified is36.4 -> av9.4
Comment 5 Itamar Heim 2014-06-12 14:10:46 UTC 
Closing as part of 3.4.0