Description of problem: After removing and reconecting an Openstack provider, all the networks are duplicated as the screenshot attached. is there a way to fix this behavior? Version-Release number of selected component (if applicable): 5.8.1 Steps to Reproduce: 1. Connect OpenStack provider to CFME 2. See Cloud Networks and verify they are associated to a Network Provider 3. Remove the OpenStack provider 4. Reconnect the OpenStack provider 2. See Cloud Networks again Actual results: Cloud Networks are duplicated, one instance associated to a Network Provider and the other one with NO netword provider Expected results: Cloud Networks are present in single instance
Created attachment 1346006 [details] Duplicate Network Screenshot
Created attachment 1355481 [details] PL/PGSQL Script example Although not recommended this is a script example to remove some 'ems_id' orphans. Replace the 'ems_id value' then execute, from a pslq session: $ psql -U username cfme cfme=# \i cleanup.sql cfme=# select from cleanup_cfme();
Although this issue cannot be reproduced consistently the it's understood it might happen in some scenario. The provided solution, which recommend to use backup instead of altering CloudForm database, is to mitigate the effects in case it happens again. For the long term, upstream work has taken it in consideration to avoid it as much as possible. If this issue is happening again please re-open the case or create a new case if experiencing it with a different version.