Description of problem: After running nova-manage delete_archive_logs all tables are cleaned up except instance_id_mappings. Version-Release number of selected component (if applicable): Openstack 10 How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Running nova-manage delete_archive_logs all tables are cleaned up except instance_id_mappings. Expected results: All tables are cleaned. Additional info: https://bugs.launchpad.net/nova/+bug/1786298 https://review.openstack.org/#/c/604373/
*** Bug 1726256 has been marked as a duplicate of this bug. ***
We still need a workaround to handle existing instance_id_mappings which weren't deleted with their instance. Something like: === WARNING, NOT TESTED! === update instance_id_mappings set deleted = id where uuid not in (select uuid from instances where deleted = 0); === WARNING, NOT TESTED! ===
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2019:1740