Open Stack

On 11/17/15 at 07:43pm, Jay Pipes wrote:
>On 11/17/2015 05:43 PM, Matt Riedemann wrote:
>>I found some time to work on a reverse sort of nova's tables for the db
>>archive command, that looks like [1].  It works fine in the unit tests,
>>but fails because the deleted instances are referenced by
>>instance_actions that aren't deleted.  I see any DB APIs for deleting
>>instance actions.
>>
>>Were we just planning on instance_actions living forever in the database?
>
>Not as far as I understand.

They were never intended to live forever.  However there is a use case 
for holding on to the deleted action so that someone could query when or 
by whom their instance was deleted.  But the current API does not 
provide a good way to query for that so this may be something better 
left to the growing list of things that Tasks could address.

>
>>Should we soft delete instance_actions when we delete the referenced
>>instance?
>
>No.
>
>>Or should we (hard) delete instance_actions when we archive (move to
>>shadow tables) soft deleted instances?
>
>Yes.
>
>Best,
>-jay
>
>>This is going to be a blocker to getting nova-manage db
>>archive_deleted_rows working.
>>
>>[1] https://review.openstack.org/#/c/246635/
>>
>
>__________________________________________________________________________
>OpenStack Development Mailing List (not for usage questions)
>Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
>http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev