On Wed, Jul 02, 2014 at 05:28:24AM -0400, Eli Mesika wrote: > > > ----- Original Message ----- > > From: "Dan Kenigsberg" <dan...@redhat.com> > > To: devel@ovirt.org, emes...@redhat.com > > Sent: Wednesday, July 2, 2014 11:27:19 AM > > Subject: test day upgrade failure > > > > For the test day I've tried to upgrade my ovirt-engine-3.4.2-1.el6.noarch to > > 3.5 beta. > > I've encountered > > > > psql:/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0050_event_notification_methods.sql:2: > > ERROR: constraint "fk_event_subscriber_event_notification_methods" of > > relation "event_subscriber" does not exist > > FATAL: Cannot execute sql command: > > --file=/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0050_event_notification_methods.sql > > > > 2014-07-02 09:16:13 DEBUG otopi.context context._executeMethod:152 method > > exception > > Traceback (most recent call last): > > File "/usr/lib/python2.6/site-packages/otopi/context.py", line 142, in > > _executeMethod > > method['method']() > > File > > > > "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py", > > line 291, in _misc > > oenginecons.EngineDBEnv.PGPASS_FILE > > File "/usr/lib/python2.6/site-packages/otopi/plugin.py", line 871, in > > execute > > command=args[0], > > RuntimeError: Command '/usr/share/ovirt-engine/dbscripts/schema.sh' failed > > to > > execute > > 2014-07-02 09:16:13 ERROR otopi.context context._executeMethod:161 Failed to > > execute stage 'Misc configuration': Command > > '/usr/share/ovirt-engine/dbscripts/schema.sh' failed to execute > > > > Is this failure known? What is the remedy? > > Hi Dan > > I had created a 3.4.2 DB and upgraded it to 3.5 with no issues > fk_event_subscriber_event_notification_methods FK is created when creating > the initial base tales and nothing drops it except the failing upgrade script. > > I assume that a manual operation had dropped this FK on your DB, please try > to run the following before teh upgrade on your 3.4.2 DB and after that try > to upgrade again > > ALTER TABLE ONLY event_subscriber > ADD CONSTRAINT fk_event_subscriber_event_notification_methods FOREIGN KEY > (method_id) REFERENCES event_notification_methods(method_id) ON DELETE > CASCADE;
How can I tell that I'm on the right DB? The refered table event_notification_methods seems to be missing. # su - postgres -bash-4.1$ psql engine psql (8.4.20) Type "help" for help. engine=# ALTER TABLE ONLY event_subscriber engine-# ADD CONSTRAINT fk_event_subscriber_event_notification_methods FOREIGN KEY (method_id) REFERENCES event_notification_methods(method_id) ON DELETE CASCADE; ERROR: relation "event_notification_methods" does not exist _______________________________________________ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel