yahoo-eng-team team mailing list archive

[Takashi NATSUME <natsume.takashi@xxxxxxxxxxxxx>]

Public bug reported:

Description
===========

In cell v2 environment, once a host is added to a cell,
the cell cannot be deleted even though the cell does not have any hosts.

Steps to reproduce
==================

In cell v2 environment, a cell to delete has only one compute host.

1. Delete the nova-compute service

> nova service-delete db8e01f5-021d-4c87-a4eb-f3e5089e6105

The records are soft deleted in the 'services' table and the 'compute_nodes' table of the cell database. 
But the record in 'host_mappings' table of api database is not deleted.

2. Delete the cell

> nova-manage cell_v2 delete_cell --cell_uuid 0fcd92ba-b257-4fbc-94d5-9ac6a77ccf81
There are existing hosts mapped to cell with uuid 0fcd92ba-b257-4fbc-94d5-9ac6a77ccf81.

The command fails with the message above.
It is caused because the host record remains in the 'host_mappings' table of api database.

But there is no ways to delete the host record in the 'host_mappings'
table.

Expected result
===============

The cell can be deleted if the cell does not have any hosts.
Or we should have the way to delete the host from the cell.

Actual result
=============

The cell cannot be deleted even though the cell does not have any hosts.
(We don't have the way to delete the host from the cell.)

Environment
===========

OS: Ubuntu 16.04.2 LTS
nova master(commit 8ca24bf1ff80f39b14726aca22b5cf52603ea5a0)

** Affects: nova
     Importance: Undecided
     Assignee: Takashi NATSUME (natsume-takashi)
         Status: In Progress


** Tags: cells nova-manage

** Changed in: nova
       Status: New => In Progress

-- 
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/1721179

Title:
  A cell cannot be deleted once a host is added to the cell

Status in OpenStack Compute (nova):
  In Progress

Bug description:
  Description
  ===========

  In cell v2 environment, once a host is added to a cell,
  the cell cannot be deleted even though the cell does not have any hosts.

  Steps to reproduce
  ==================

  In cell v2 environment, a cell to delete has only one compute host.

  1. Delete the nova-compute service

  > nova service-delete db8e01f5-021d-4c87-a4eb-f3e5089e6105

  The records are soft deleted in the 'services' table and the 'compute_nodes' table of the cell database. 
  But the record in 'host_mappings' table of api database is not deleted.

  2. Delete the cell

  > nova-manage cell_v2 delete_cell --cell_uuid 0fcd92ba-b257-4fbc-94d5-9ac6a77ccf81
  There are existing hosts mapped to cell with uuid 0fcd92ba-b257-4fbc-94d5-9ac6a77ccf81.

  The command fails with the message above.
  It is caused because the host record remains in the 'host_mappings' table of api database.

  But there is no ways to delete the host record in the 'host_mappings'
  table.

  Expected result
  ===============

  The cell can be deleted if the cell does not have any hosts.
  Or we should have the way to delete the host from the cell.

  Actual result
  =============

  The cell cannot be deleted even though the cell does not have any hosts.
  (We don't have the way to delete the host from the cell.)

  Environment
  ===========

  OS: Ubuntu 16.04.2 LTS
  nova master(commit 8ca24bf1ff80f39b14726aca22b5cf52603ea5a0)

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1721179/+subscriptions