Reviewed: https://review.openstack.org/591558
Committed:
https://git.openstack.org/cgit/openstack/nova/commit/?id=8a6b57cf741e17d3de54ed8c85d9fb69c43e7432
Submitter: Zuul
Branch: master
commit 8a6b57cf741e17d3de54ed8c85d9fb69c43e7432
Author: Matt Riedemann <mriedem...@gmail.com>
Date: Tue Aug 14 11:05:06 2018 +0800
Delete instance_id_mappings record in instance_destroy
The instance_create DB API creates an instance_id_mappings record
but instance_destroy was not cleaning it up when the instance is
deleted; this adds that delete code. Otherwise those records
never get moved to shadow tables so you can't archive and purge them.
Change-Id: Idfe52d3c2f987b9aac551f013a0990423d87fad3
Closes-Bug: #1786298
** Changed in: nova
Status: In Progress => Fix Released
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1786298
Title:
nova-manage db archive_deleted_rows does not cleanup table
instance_id_mappings
Status in OpenStack Compute (nova):
Fix Released
Bug description:
Description
===========
After running nova-manage delete_archive_logs all tables are cleaned up
except instance_id_mappings.
Steps to reproduce
==================
* create instance
* delete instance
* nova-manage delete_archive_logs
Expected result
===============
Clean up of instance_id_mappings table
Actual result
=============
+-----------------------------+--------+---------+------------+--------+
| Name | Engine | Version | Row_format | Rows |
+-----------------------------+--------+---------+------------+--------+
| instance_id_mappings | InnoDB | 10 | Compact | 288549 |
| shadow_instance_id_mappings | InnoDB | 10 | Compact | 0 |
+-----------------------------+--------+---------+------------+--------+
Environment
===========
openstack-nova-conductor-17.0.5-1.el7.noarch
openstack-nova-scheduler-17.0.5-1.el7.noarch
openstack-nova-api-17.0.5-1.el7.noarch
openstack-nova-placement-api-17.0.5-1.el7.noarch
openstack-nova-novncproxy-17.0.5-1.el7.noarch
openstack-nova-console-17.0.5-1.el7.noarch
openstack-nova-common-17.0.5-1.el7.noarch
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1786298/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
