instance_faults table

You can have a try this command:

nova-manage db archive_deleted_rows [-h] [--max_rows <number>]
                                           [action_args [action_args ...]]

it will move rows which in table instance_faults to table
shadow_instance_faults.

2013/10/9 Thuy Christenson <email address hidden>

> New question #237048 on OpenStack Compute (nova):
> https://answers.launchpad.net/nova/+question/237048
>
> How do records in the instance_faults table get deleted and archived?
>
> --
> You received this question notification because you are an answer
> contact for OpenStack Compute (nova).
>

--
Best regards,
gtt

Thanks Tiantian, but that command only move the 'deleted' rows. The rows in the instance_faults table are not marked deleted.

It looks like a bug. When deleting a instance, the instance_fault relative
to the instance should be deleted at the same time.
Otherwise the records in instance_fault will grow up forever.

How about report a bug about this, and see other guys think about that?

2013/10/9 Thuy Christenson <email address hidden>

> Question #237048 on OpenStack Compute (nova) changed:
> https://answers.launchpad.net/nova/+question/237048
>
> Thuy Christenson posted a new comment:
> Thanks Tiantian, but that command only move the 'deleted' rows. The rows
> in the instance_faults table are not marked deleted.
>
> --
> You received this question notification because you are an answer
> contact for OpenStack Compute (nova).
>

--
Best regards,
gtt