Re: [ovirt-users] Problem Upgrading 3.4.4 -> 3.5
>>> 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(a)ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>