Bug 1072866

Summary: event_subscriber upgrade script fails on any user that has an event_subscriber record.
Product: [Retired] oVirt Reporter: Mooli Tayer <mtayer>
Component: ovirt-engine-notificiationsAssignee: Mooli Tayer <mtayer>
Status: CLOSED DUPLICATE QA Contact: Pavel Stehlik <pstehlik>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 3.4CC: acathrow, gklein, iheim, yeylon
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-03-05 10:38:00 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:

Description Mooli Tayer 2014-03-05 10:17:17 UTC
Description of problem:

event_subscriber upgrade script fails on
any user that has an event_subscriber record.

Version-Release number of selected component (if applicable):
on upgrade from 3.3 to 3.4

How reproducible:
100%

Steps to Reproduce:
1. on engine 3.3 subscribe to an event from the engine.
2. upgrade to 3.4 (including running engine-setup)


Actual results:
on upgrade (engine-setup) you get:

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

Expected results:
to error during upgrade

Additional info:
caused by creating a primary key on event_subscriber while newly created event_subscriber is null.

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

*** This bug has been marked as a duplicate of bug 1072549 ***