[ovirt-users] Problem Upgrading 3.4.4 -> 3.5

[Yedidyah Bar David]

----- Original Message -----
> From: "Eli Mesika" <emesika at redhat.com>
> To: jg at internetx.com
> Cc: users at ovirt.org
> Sent: Tuesday, December 23, 2014 3:15:47 AM
> Subject: Re: [ovirt-users] Problem Upgrading 3.4.4 -> 3.5
> 
> 
> 
> ----- Original Message -----
> > From: "InterNetX - Juergen Gotteswinter" <jg at internetx.com>
> > To: users at ovirt.org
> > Sent: Monday, December 22, 2014 2:07:55 PM
> > Subject: Re: [ovirt-users] Problem Upgrading 3.4.4 -> 3.5
> > 
> > Hello again,
> > 
> > > It seems that somebody had deleted manually the constraint
> > > fk_event_subscriber_event_notification_methods from your database
> > > Therefor, the first line that attempts to drop this constraint in
> > > 03_05_0050_event_notification_methods.sql:  ALTER TABLE event_subscriber
> > > DROP CONSTRAINT fk_event_subscriber_event_notification_methods;
> > > fails.
> > 
> > uhm, interesting. could this be caused be deinstallation of dwh reporting?

How exactly did you do that?

Note that partial cleanup is not supported yet [1].

Can you please post all of /var/log/ovirt-engine/setup/* ?

Thanks!

[1] https://bugzilla.redhat.com/show_bug.cgi?id=1060529

> > 
> > > 
> > > Please try to run the following manually and upgrade again
> > > 
> > > psql -U engine -c "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;"
> > > engine
> > > 
> > 
> > it just drops "ERROR:  relation "event_notification_methods" does not
> > exist"
> 
> OK
> Lets check what do you have in your DB
> 
> Please attach the result of the following
> 
> psql -U engine -c "select table_name from information_schema.tables where
> table_schema = 'public' order by table_name ;" engine
> 
> Thanks
> 
> 
> > 
> > > Let me know how it is going ...
> > > 
> > > Eli
> > > 
> > 
> > Thank you already for your help!
> > 
> > Juergen
> > _______________________________________________
> > Users mailing list
> > Users at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> > 
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
-- 
Didi