On Thu May 05 2022 09:58:10 GMT-0700 (Pacific Daylight Time), melanie witt <melwittt@gmail.com> wrote:
You may still have orphaned consumers table records in the placement database but they don't hurt anything. If you want/need to clean them up, it has to be done manually, something like (disclaimer I did not test this):
delete from placement.consumers where placement.consumers.uuid not in (select nova_api.instance_mappings.instance_uuid from nova_api.instance_mappings where nova_api.instance_mappings.queued_for_delete = true);
Sorry I got the where condition backwards, it should be: delete from placement.consumers where placement.consumers.uuid not in (select nova_api.instance_mappings.instance_uuid from nova_api.instance_mappings where nova_api.instance_mappings.queued_for_delete != true); And you might have s/placement/nova_api/ if you did not break out the separate placement database. -melanie