Bug 1072549

Summary:	Schema upgrade failure on 03_05_0050_event_notification_methods.sql
Product:	[Retired] oVirt	Reporter:	Adam Litke <alitke>
Component:	ovirt-engine-core	Assignee:	Eli Mesika <emesika>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Pavel Stehlik <pstehlik>
Severity:	urgent	Docs Contact:
Priority:	urgent
Version:	unspecified	CC:	acathrow, gklein, iheim, mtayer, yeylon
Target Milestone:	---
Target Release:	3.4.0
Hardware:	All
OS:	Linux
Whiteboard:	infra
Fixed In Version:	ovirt-3.4.0-ga	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:
Clones:	1072867 (view as bug list)		Environment:
Last Closed:	2014-03-31 12:31:10 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1072867

Description Adam Litke 2014-03-04 18:26:54 UTC

I've recently rebased to master and it looks like the
03_05_0050_event_notification_methods.sql script is failing on schema
upgrade.  Is this a bug or am I doing something wrong?  To upgrade I
did the normal proceedure with my development installation:

make install-dev ...
~/ovirt/bin/engine-setup

Got this result in the log file:

psql:/home/alitke/ovirt-**FILTERED**/share/ovirt-**FILTERED**/dbscripts/upgrade/03_05_0050_event_notification_methods.sql:10: ERROR:  column "notification_method" contains null values
FATAL: Cannot execute sql command: --file=/home/alitke/ovirt-**FILTERED**/share/ovirt-**FILTERED**/dbscripts/upgrade/03_05_0050_event_notification_methods.sql

2014-03-03 17:20:34 DEBUG otopi.context context._executeMethod:152 method exception
Traceback (most recent call last):
 File "/usr/lib/python2.7/site-packages/otopi/context.py", line 142, in _executeMethod
   method['method']()
 File "/home/alitke/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/bin/../plugins/ovirt-**FILTERED**-setup/ovirt-**FILTERED**/db/schema.py", line 280, in _misc
   osetupcons.DBEnv.PGPASS_FILE
 File "/usr/lib/python2.7/site-packages/otopi/plugin.py", line 451, in execute
   command=args[0],
RuntimeError: Command '/home/alitke/ovirt-**FILTERED**/share/ovirt-**FILTERED**/dbscripts/schema.sh' failed to execute

Version-Release number of selected component (if applicable):
faafbcf89fb1b236e228aa64c6143032d850a4fa

Comment 1 Eli Mesika 2014-03-05 10:17:26 UTC

moving that to 3.4 urgent  since any installation that have non-empty event_subscriber table (users that had subscribed to any event) will cause the upgrade to fail

Comment 2 Mooli Tayer 2014-03-05 10:38:00 UTC

*** Bug 1072866 has been marked as a duplicate of this bug. ***

Comment 3 Adam Litke 2014-03-05 13:34:46 UTC

Just curious, but since the script is 03_05_0050, it wont be released as part of 3.4.0, right?  Why is it important to target this to 3.4.0?

Comment 4 Eli Mesika 2014-03-05 13:40:20 UTC

(In reply to Adam Litke from comment #3)
> Just curious, but since the script is 03_05_0050, it wont be released as
> part of 3.4.0, right?  Why is it important to target this to 3.4.0?

Adam when we start 3.5 we change the prefix upstream to be 03_05 , however , some of those scripts are still 3.4 downstream related and if you look in the stable 3.4 you will see a 03_04_0600.... script that has this functionality

Comment 5 Sandro Bonazzola 2014-03-31 12:31:10 UTC

this is an automated message: moving to Closed CURRENT RELEASE since oVirt 3.4.0 has been released