yahoo-eng-team team mailing list archive

[Pierre Riteau <1891346@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

I am trying to delete a nova-compute service for a retired hypervisor:

$ openstack compute service delete 124                                                                                       
Failed to delete compute service with ID '124': Service id 124 refers to multiple services. (HTTP 400) (Request-ID: req-05e01880-237c-4efd-8c54-2899ccbf7316)
1 of 1 compute services failed to delete.

This is caused by a conflicting service with the same ID in nova_cell0:

MariaDB [nova_cell0]> SELECT * FROM services WHERE id = 124;
+---------------------+------------+------------+-----+---------------+---------------+-------+--------------+----------+---------+-----------------+--------------+-------------+---------+--------------------------------------+
| created_at          | updated_at | deleted_at | id  | host          | binary        | topic | report_count | disabled | deleted | disabled_reason | last_seen_up | forced_down | version | uuid                                 |
+---------------------+------------+------------+-----+---------------+---------------+-------+--------------+----------+---------+-----------------+--------------+-------------+---------+--------------------------------------+
| 2020-05-27 18:43:34 | NULL       | NULL       | 124 | 172.16.52.246 | nova-metadata | NULL  |            0 |        0 |       0 | NULL            | NULL         |           0 |      40 | cb03be2c-cd62-4d48-a2eb-424df70862c5 |
+---------------------+------------+------------+-----+---------------+---------------+-------+--------------+----------+---------+-----------------+--------------+-------------+---------+--------------------------------------+

This service in cell0 appears to have been created at the time of an
upgrade from Stein to Train.

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

python2-novaclient-15.1.0-1.el7.noarch
python2-nova-20.2.0-1.el7.noarch
openstack-nova-api-20.2.0-1.el7.noarch
openstack-nova-common-20.2.0-1.el7.noarch

** Affects: nova
     Importance: Undecided
         Status: New

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

Title:
  Cannot delete nova-compute service due to service ID conflict

Status in OpenStack Compute (nova):
  New

Bug description:
  I am trying to delete a nova-compute service for a retired hypervisor:

  $ openstack compute service delete 124                                                                                       
  Failed to delete compute service with ID '124': Service id 124 refers to multiple services. (HTTP 400) (Request-ID: req-05e01880-237c-4efd-8c54-2899ccbf7316)
  1 of 1 compute services failed to delete.

  This is caused by a conflicting service with the same ID in
  nova_cell0:

  MariaDB [nova_cell0]> SELECT * FROM services WHERE id = 124;
  +---------------------+------------+------------+-----+---------------+---------------+-------+--------------+----------+---------+-----------------+--------------+-------------+---------+--------------------------------------+
  | created_at          | updated_at | deleted_at | id  | host          | binary        | topic | report_count | disabled | deleted | disabled_reason | last_seen_up | forced_down | version | uuid                                 |
  +---------------------+------------+------------+-----+---------------+---------------+-------+--------------+----------+---------+-----------------+--------------+-------------+---------+--------------------------------------+
  | 2020-05-27 18:43:34 | NULL       | NULL       | 124 | 172.16.52.246 | nova-metadata | NULL  |            0 |        0 |       0 | NULL            | NULL         |           0 |      40 | cb03be2c-cd62-4d48-a2eb-424df70862c5 |
  +---------------------+------------+------------+-----+---------------+---------------+-------+--------------+----------+---------+-----------------+--------------+-------------+---------+--------------------------------------+

  This service in cell0 appears to have been created at the time of an
  upgrade from Stein to Train.

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

  python2-novaclient-15.1.0-1.el7.noarch
  python2-nova-20.2.0-1.el7.noarch
  openstack-nova-api-20.2.0-1.el7.noarch
  openstack-nova-common-20.2.0-1.el7.noarch

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