[ovirt-devel] test day upgrade failure

[Dan Kenigsberg]

On Wed, Jul 02, 2014 at 05:28:24AM -0400, Eli Mesika wrote:
> 
> 
> ----- Original Message -----
> > From: "Dan Kenigsberg" <danken at redhat.com>
> > To: devel at ovirt.org, emesika at 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