This is the result of the previous code being wrong for so long, and creating so many duplicate records that when we try to delete them all it takes a lot of time and memory. I created a utility to delete these so that the refresh worker can run normally, https://github.com/ManageIQ/manageiq/pull/19219 ./tools/cleanup_duplicate_host_guest_devices.rb [--ems-name=EMS_NAME or --ems-id=EMS_ID] will query and print how many duplicates were found but not delete them. Passing --no-dry-run will actually remove them.
It seems to me I will need the customer DB for verifying this.
Also need: https://github.com/ManageIQ/manageiq/pull/19235
*** Bug 1767866 has been marked as a duplicate of this bug. ***
Hi, Customer have question about this bug: "And I would also like to know what was the background for this bug. Why was so many devices duplicated?" Please, can you provide some valuable answer for customer? Thank you, mheppler
https://bugzilla.redhat.com/show_bug.cgi?id=1731237
*** Bug 1832715 has been marked as a duplicate of this bug. ***