retention policy for deleted resource in database
Hi, I see the record for deleted resource stay in database. What's the retention policy for those records? Is it configurable? Any manual cleanup is required? Thanks! Tony
Hi Tony, There is no default retention policy defined. To clean up such records for cinder you can run command cinder-manage db purge <days to retain> For nova it's a bit more complicated as first you would archive these records and only then purge them from shadow tables. This is done with nova-manage command. You can check docs regarding it's usage: https://docs.openstack.org/nova/latest/cli/nova-manage.html#db-archive-delet... вс, 24 апр. 2022 г., 6:04 Tony Liu <tonyliu0592@hotmail.com>:
Hi,
I see the record for deleted resource stay in database. What's the retention policy for those records? Is it configurable? Any manual cleanup is required?
Thanks! Tony
Thank you Dmitriy! I am a bit surprised. I'd expect records for deleted resource to be cleaned up by some retention policy. Will need to make sure such clean-up to be taken care of by daily operation. BTW, is it mentioned in any doc? I probably missed it. Tony ________________________________________ From: Dmitriy Rabotyagov <noonedeadpunk@gmail.com> Sent: April 23, 2022 10:17 PM Cc: openstack-dev@lists.openstack.org Subject: Re: retention policy for deleted resource in database Hi Tony, There is no default retention policy defined. To clean up such records for cinder you can run command cinder-manage db purge <days to retain> For nova it's a bit more complicated as first you would archive these records and only then purge them from shadow tables. This is done with nova-manage command. You can check docs regarding it's usage: https://docs.openstack.org/nova/latest/cli/nova-manage.html#db-archive-delet... вс, 24 апр. 2022 г., 6:04 Tony Liu <tonyliu0592@hotmail.com<mailto:tonyliu0592@hotmail.com>>: Hi, I see the record for deleted resource stay in database. What's the retention policy for those records? Is it configurable? Any manual cleanup is required? Thanks! Tony
participants (2)
-
Dmitriy Rabotyagov
-
Tony Liu