----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: jg@internetx.com Cc: users@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@internetx.com> To: users@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi