[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:

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



More information about the openstack-discuss mailing list