Re: [ovirt-users] Problem Upgrading 3.4.4 -> 3.5

From: "Eli Mesika" <emesika(a)redhat.com&gt; To: jg(a)internetx.com Cc: users(a)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(a)internetx.com&gt; > To: users(a)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?

> > > > > 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(a)ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users