[ovirt-users] Problem Upgrading 3.4.4 -> 3.5

[InterNetX - Juergen Gotteswinter]

>>>> 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
>>> 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
>>