Re: [Engine-devel] Schema upgrade failure on master

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&gt; >> 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