← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1786298] Re: nova-manage db archive_deleted_rows does not cleanup table instance_id_mappings

 

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.os@xxxxxxxxx>
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


References