engine-setup upgrade issue: insert or update on table "cluster" violates foreign key constraint "cluster_default_network_provider_id_fkey"

Hi all, I introduced an possible upgrade issue in engine-setup. If engine-setup fails on upgrading the db with: [ ERROR ] Failed to execute stage 'Misc configuration': insert or update on table "cluster" violates foreign key constraint "cluster_default_network_provider_id_fkey" DETAIL: Key (default_network_provider_id)=(b32f7988-ca21-4d1b-b116-55d3f5794534) is not present in table "providers". please create the missing provider in sql by: select InsertProvider( v_id:='b32f7988-ca21-4d1b-b116-55d3f5794534', v_name:='ovirt-provider-ovn', v_description:='oVirt network provider for OVN', v_url:='https://localhost:9696', v_provider_type:='EXTERNAL_NETWORK', v_auth_required:=False, v_auth_username:=null, v_auth_password:=null, v_custom_properties:=null, v_auth_url:=null ); Please change the id of the new provider to the id logged in the error message. A suitable SQL prompt can by created by sudo su - postgres -c "psql -U postgres engine" I am going to post a patch which will fix this issue. This issue arises if the ovirt-provider-ovn created be engine-setup is gone, e.g. manually removed. Dominik
participants (1)
-
Dominik Holler