[ovirt-users] Problem Upgrading 3.4.4 -> 3.5

InterNetX - Juergen Gotteswinter jg at internetx.com
Mon Dec 22 12:07:55 UTC 2014


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"

> Let me know how it is going ...
> 
> Eli
> 

Thank you already for your help!

Juergen



More information about the Users mailing list