[nova][ptg] drop the shadow table concept

Mohammed Naser mnaser at vexxhost.com
Mon Nov 11 19:05:55 UTC 2019

On Mon, Nov 11, 2019 at 12:33 AM Balázs Gibizer <balazs.gibizer at 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:


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 at vexxhost.com
W. https://vexxhost.com

More information about the openstack-discuss mailing list