yahoo-eng-team team mailing list archive

[Matt Riedemann <mriedem.os@xxxxxxxxx>]

** Also affects: nova/pike
   Importance: Undecided
       Status: New

** Also affects: nova/rocky
   Importance: Undecided
       Status: New

** Also affects: nova/queens
   Importance: Undecided
       Status: New

** Changed in: nova/pike
   Importance: Undecided => Medium

** Changed in: nova/queens
   Importance: Undecided => Medium

** Changed in: nova/rocky
   Importance: Undecided => Medium

-- 
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
Status in OpenStack Compute (nova) pike series:
  Confirmed
Status in OpenStack Compute (nova) queens series:
  Confirmed
Status in OpenStack Compute (nova) rocky series:
  In Progress

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