Description of problem: After upgrading CF4.0 to 4.1 and launching UI. Opening networks + networks throws error in UI. /cloud_network/show_list The single-table inheritance mechanism failed to locate the subclass: 'ManageIQ::Providers::Openstack::CloudManager::CloudNetwork'. This error is raised because the column 'type' is reserved for storing the class in case of inheritance. Please rename this column if you didn't intend it to be used for storing the inheritance class or overwrite CloudNetwork.inheritance_column to use another column for that information. [cloud_network/show_list] Version-Release number of selected component (if applicable): 5.6.0 How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
The environment most possibly contains Networks that are not associated to any EMS. It can be fixed running these commands in rails c: CloudNetwork.where(:type => "ManageIQ::Providers::Openstack::CloudManager::CloudNetwork", :external_facing => false).update_all(:type => "ManageIQ::Providers::Openstack::NetworkManager::CloudNetwork::Private") CloudNetwork.where(:type => "ManageIQ::Providers::Openstack::CloudManager::CloudNetwork", :external_facing => true).update_all(:type => "ManageIQ::Providers::Openstack::NetworkManager::CloudNetwork::Public") or non associated CloudNetworks can be deleted with: CloudNetwork.where(:type => "ManageIQ::Providers::Openstack::CloudManager::CloudNetwork", :ems_id => nil).delete_all
these 3 commands should work for orphaned network with subnets: --------------------------------------------------------------- CloudNetwork.where(:type => "ManageIQ::Providers::Openstack::CloudManager::CloudNetwork", :external_facing => false).update_all(:type => "ManageIQ::Providers::Openstack::NetworkManager::CloudNetwork::Private") CloudNetwork.where(:type => "ManageIQ::Providers::Openstack::CloudManager::CloudNetwork", :external_facing => true).update_all(:type => "ManageIQ::Providers::Openstack::NetworkManager::CloudNetwork::Public") CloudSubnet.where(:type => "ManageIQ::Providers::Openstack::CloudManager::CloudSubnet").update_all(:type => "ManageIQ::Providers::Openstack::NetworkManager::CloudSubnet") or delete the orphaned OpenStack networks and subnets: ------------------------------------------------------ CloudNetwork.where(:type => "ManageIQ::Providers::Openstack::CloudManager::CloudNetwork", :ems_id => nil).delete_all CloudSubnet.where(:type => "ManageIQ::Providers::Openstack::CloudManager::CloudSubnet", :ems_id => nil).delete_all or delete all orphaned networks and subnets: -------------------------------------------- CloudNetwork.where(:ems_id => nil).delete_all CloudSubnet.where(:ems_id => nil).delete_all
Ladislav, can you please add PR link?
Satoe, there is no PR, we just agreed with jkrocil to include steps from comment #6 to upgrade docs.
Thanks, Ladislav. In that case, I'm changing this to Documentation and re-opening..
Assigning to Dayle for review. Dayle - looks like a request to update the older upgrade content to include the steps in comment #6.
Hi Suyog, Can you please review the update I made, and let me know if you think it makes sense? I've added a small section to the end of the procedure on migrating database appliances to describe what is in Comment #6, above. It's called "Additional Steps to Refresh Network Providers" in https://access.redhat.com/articles/2297391. It's published but I'm happy to fix anything you come across. Thank you, Dayle
Hi Dayle, Thanks for the updates. I've reviewed the new section -- looks good to me. Thanks, Suyog
Thanks for reviewing, Suyog. The changes are live here, so closing this bug: https://access.redhat.com/articles/2297391