Open Stack

On Thu May 05 2022 09:58:10 GMT-0700 (Pacific Daylight Time), melanie 
witt <melwittt at 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