Comment 5 for bug 1793569

I think one thing that larsks' and mnaser's audit scripts probably aren't handling are allocations held by migration records which never got cleaned up when a migration completed, likely failed for some reason and weren't cleaned up, e.g. we have several bugs related to failed migrations not cleaning up allocations properly:

https://review.opendev.org/#/c/654067/

https://review.opendev.org/#/c/663737/

https://review.opendev.org/#/q/topic:bug/1821594+(status:open+OR+status:merged)

The "nova-manage placement heal_allocations" CLI could probably be updated to deal with at least reporting allocations held by migration records that are not in progress so operators could delete those allocations or at least investigate the related instance for the migration to make sure it's allocations are OK, i.e. the operator could delete the allocations for both the migration consumer and instance consumer and then run the heal_allocations CLI again to re-add the allocations for just the instance on its current compute node resource provider.