<div dir="ltr">had the same issue. Run from psql:<div>truncate table <span style="font-family:arial,sans-serif;font-size:13px">event_subscriber;</span></div><div><span style="font-family:arial,sans-serif;font-size:13px">Then run the script. Note that this will delete all the rows from your table...</span></div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Mar 4, 2014 at 3:18 PM, Adam Litke <span dir="ltr"><<a href="mailto:alitke@redhat.com" target="_blank">alitke@redhat.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 04/03/14 00:10 -0500, Martin Perina wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Adam,<br>
<br>
I didn't notice any problem with this script. Was the database you tried to upgrade empty?<br>
If not could you please send me contents of your event_subscriber table?<br>
</blockquote>
<br>
engine=> select * from event_subscriber ;<br>
subscriber_id | event_up_name | method_id | method_address | tag_name ------------------------------<u></u>--------+---------------------<u></u>--------+-----------<br>
+--------------------------+--<u></u>--------<br>
fdfc627c-d875-11e0-90f0-<u></u>83df133b58cc | VM_SET_TICKET | 0 | <a href="mailto:alitke@brewer.alitke.net" target="_blank">alitke@brewer.alitke.net</a> | fdfc627c-d875-11e0-90f0-<u></u>83df133b58cc | VM_DOWN_ERROR | 0 | <a href="mailto:alitke@brewer.alitke.net" target="_blank">alitke@brewer.alitke.net</a> | fdfc627c-d875-11e0-90f0-<u></u>83df133b58cc | VDS_INITIATED_RUN_VM_FAILED | 0 | <a href="mailto:alitke@brewer.alitke.net" target="_blank">alitke@brewer.alitke.net</a> | (3 rows)<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Thanks<br>
<br>
Martin Perina<br>
<br>
----- Original Message -----<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
From: "Adam Litke" <<a href="mailto:alitke@redhat.com" target="_blank">alitke@redhat.com</a>><br>
To: <a href="mailto:engine-devel@ovirt.org" target="_blank">engine-devel@ovirt.org</a><br>
Sent: Monday, March 3, 2014 11:26:28 PM<br>
Subject: [Engine-devel] Schema upgrade failure on master<br>
<br>
Hi,<br>
<br>
I've recently rebased to master and it looks like the<br>
03_05_0050_event_notification_<u></u>methods.sql script is failing on schema<br>
upgrade. Is this a bug or am I doing something wrong? To upgrade I<br>
did the normal proceedure with my development installation:<br>
<br>
make install-dev ...<br>
~/ovirt/bin/engine-setup<br>
<br>
Got this result in the log file:<br>
<br>
psql:/home/alitke/ovirt-**<u></u>FILTERED**/share/ovirt-**<u></u>FILTERED**/dbscripts/upgrade/<u></u>03_05_0050_event_notification_<u></u>methods.sql:10:<br>
ERROR: column "notification_method" contains null values<br>
FATAL: Cannot execute sql command:<br>
--file=/home/alitke/ovirt-**<u></u>FILTERED**/share/ovirt-**<u></u>FILTERED**/dbscripts/upgrade/<u></u>03_05_0050_event_notification_<u></u>methods.sql<br>
<br>
2014-03-03 17:20:34 DEBUG otopi.context context._executeMethod:152 method<br>
exception<br>
Traceback (most recent call last):<br>
File "/usr/lib/python2.7/site-<u></u>packages/otopi/context.py", line 142, in<br>
_executeMethod<br>
method['method']()<br>
File<br>
"/home/alitke/ovirt-**<u></u>FILTERED**/share/ovirt-**<u></u>FILTERED**/setup/bin/../<u></u>plugins/ovirt-**FILTERED**-<u></u>setup/ovirt-**FILTERED**/db/<u></u>schema.py",<br>
line 280, in _misc<br>
osetupcons.DBEnv.PGPASS_FILE<br>
File "/usr/lib/python2.7/site-<u></u>packages/otopi/plugin.py", line 451, in<br>
execute<br>
command=args[0],<br>
RuntimeError: Command<br>
'/home/alitke/ovirt-**<u></u>FILTERED**/share/ovirt-**<u></u>FILTERED**/dbscripts/schema.<u></u>sh'<br>
failed to execute<span class="HOEnZb"><font color="#888888"><br>
<br>
--<br>
Adam Litke<br>
______________________________<u></u>_________________<br>
Engine-devel mailing list<br>
<a href="mailto:Engine-devel@ovirt.org" target="_blank">Engine-devel@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/engine-devel" target="_blank">http://lists.ovirt.org/<u></u>mailman/listinfo/engine-devel</a><br>
<br>
</font></span></blockquote></blockquote><span class="HOEnZb"><font color="#888888">
<br>
-- <br>
Adam Litke<br>
______________________________<u></u>_________________<br>
Engine-devel mailing list<br>
<a href="mailto:Engine-devel@ovirt.org" target="_blank">Engine-devel@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/engine-devel" target="_blank">http://lists.ovirt.org/<u></u>mailman/listinfo/engine-devel</a><br>
</font></span></blockquote></div><br></div>