[Engine-devel] Schema upgrade failure on master

[Eli Mesika]

----- Original Message -----
> From: "Liran Zelkha" <liran.zelkha at gmail.com>
> To: "Adam Litke" <alitke at redhat.com>
> Cc: "engine-devel" <engine-devel at ovirt.org>
> Sent: Tuesday, March 4, 2014 3:20:57 PM
> Subject: Re: [Engine-devel] Schema upgrade failure on master
> 
> had the same issue. Run from psql:
> truncate table event_subscriber;
> Then run the script. Note that this will delete all the rows from your
> table...


Sorry for jumping on that late, but if this occurs when  event_subscriber is not empty then this is a bug since it will fail also in customer site.
In that case I think that you should open a bug and since the notification mechanism is heavily used , I think this is a blocker

Can you please open a bug and assign on me 

Thanks
Eli

> 
> 
> On Tue, Mar 4, 2014 at 3:18 PM, Adam Litke < alitke at redhat.com > wrote:
> 
> 
> On 04/03/14 00:10 -0500, Martin Perina wrote:
> 
> 
> Hi Adam,
> 
> I didn't notice any problem with this script. Was the database you tried to
> upgrade empty?
> If not could you please send me contents of your event_subscriber table?
> 
> engine=> select * from event_subscriber ;
> subscriber_id | event_up_name | method_id | method_address | tag_name
> ------------------------------ --------+---------------------
> --------+-----------
> +--------------------------+-- --------
> fdfc627c-d875-11e0-90f0- 83df133b58cc | VM_SET_TICKET | 0 |
> alitke at brewer.alitke.net | fdfc627c-d875-11e0-90f0- 83df133b58cc |
> VM_DOWN_ERROR | 0 | alitke at brewer.alitke.net | fdfc627c-d875-11e0-90f0-
> 83df133b58cc | VDS_INITIATED_RUN_VM_FAILED | 0 | alitke at brewer.alitke.net |
> (3 rows)
> 
> 
> 
> 
> 
> Thanks
> 
> Martin Perina
> 
> ----- Original Message -----
> 
> 
> From: "Adam Litke" < alitke at redhat.com >
> To: engine-devel at ovirt.org
> Sent: Monday, March 3, 2014 11:26:28 PM
> Subject: [Engine-devel] Schema upgrade failure on master
> 
> Hi,
> 
> 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
> 
> --
> Adam Litke
> ______________________________ _________________
> Engine-devel mailing list
> Engine-devel at ovirt.org
> http://lists.ovirt.org/ mailman/listinfo/engine-devel
> 
> 
> --
> Adam Litke
> ______________________________ _________________
> Engine-devel mailing list
> Engine-devel at ovirt.org
> http://lists.ovirt.org/ mailman/listinfo/engine-devel
> 
> 
> _______________________________________________
> Engine-devel mailing list
> Engine-devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/engine-devel
>