>>>> 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?
very good question, thats a few months ago. i whould guess with rpm -e before an engine upgrade (if i remember correctly there was one ovirt release where dwh was missing for el6). > > Note that partial cleanup is not supported yet [1]. checking right after that mail :) > > Can you please post all of /var/log/ovirt-engine/setup/* ? sure, sending you the dl link in a private mail. since i am not sure if i sed´ed out all "private" things > > 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 >>> [email protected] >>> http://lists.ovirt.org/mailman/listinfo/users >>> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.ovirt.org/mailman/listinfo/users >> _______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
