6:04 p.m.
----- Original Message -----
From: "Liran Zelkha" <liran.zelkha(a)gmail.com>
To: "Adam Litke" <alitke(a)redhat.com>
Cc: "engine-devel" <engine-devel(a)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(a)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(a)brewer.alitke.net | fdfc627c-d875-11e0-90f0- 83df133b58cc |
VM_DOWN_ERROR | 0 | alitke(a)brewer.alitke.net | fdfc627c-d875-11e0-90f0-
83df133b58cc | VDS_INITIATED_RUN_VM_FAILED | 0 | alitke(a)brewer.alitke.net |
(3 rows)
Thanks
Martin Perina
----- Original Message -----
From: "Adam Litke" < alitke(a)redhat.com >
To: engine-devel(a)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(a)ovirt.org
http://lists.ovirt.org/ mailman/listinfo/engine-devel
--
Adam Litke
______________________________ _________________
Engine-devel mailing list
Engine-devel(a)ovirt.org
http://lists.ovirt.org/ mailman/listinfo/engine-devel
_______________________________________________
Engine-devel mailing list
Engine-devel(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-devel