On Mon, Nov 11, 2019 at 12:33 AM Balázs Gibizer <balazs.gibizer@est.tech> wrote:
CERN reported two issues with archive_deleted_rows CLI: * When one record gets inserted into the shadow_instance_extra but didn't get deleted from instance_extra (I know this is in a single transaction but sometimes it happens), needs manual cleanup on the database * Also there could be two cells running this command at the same time fighting for the API db lock,
TODOs: * tssurya to report bugs / improvements on archive_deleted_rows CLI based on CERN's experience with long table locking * mnaser to report a wishlist bug / specless bp about one step db purge CLI which would skip the shadow tables
I did my homework: https://bugs.launchpad.net/nova/+bug/1852121 I don't think I have time currently to iterate and work on it right now, but at least it's documented.
Cheers, gibi
-- Mohammed Naser — vexxhost ----------------------------------------------------- D. 514-316-8872 D. 800-910-1726 ext. 200 E. mnaser@vexxhost.com W. https://vexxhost.com