Bug 1093283 - db upgrade fails if there's a subscription to VDS_HIGH_NETWORK_USE event
Summary: db upgrade fails if there's a subscription to VDS_HIGH_NETWORK_USE event
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine
Version: 3.4.0
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ---
: 3.4.0
Assignee: Eli Mesika
QA Contact: Martin Pavlik
URL:
Whiteboard: infra
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-05-01 07:48 UTC by Ohad Basan
Modified: 2016-02-10 19:28 UTC (History)
12 users (show)

Fixed In Version: org.ovirt.engine-root-3.4.0-17
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed:
oVirt Team: Infra
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 27287 0 master MERGED core: db fix event renaming upgrade script. 2020-09-07 03:09:10 UTC
oVirt gerrit 27289 0 None ABANDONED core: db fix event renaming upgrade script. 2020-09-07 03:09:10 UTC
oVirt gerrit 27290 0 None ABANDONED core: db fix event renaming upgrade script. 2020-09-07 03:09:09 UTC
oVirt gerrit 27292 0 ovirt-engine-3.4 MERGED core: db fix event renaming upgrade script. 2020-09-07 03:09:09 UTC
oVirt gerrit 27293 0 ovirt-engine-3.4.1 MERGED core: db fix event renaming upgrade script. 2020-09-07 03:09:09 UTC

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
Note You need to log in before you can comment on or make changes to this bug.