[Engine-devel] Schema upgrade failure on master

[Liran Zelkha]

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...


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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20140304/6eb6aecb/attachment-0001.html>