yahoo-eng-team team mailing list archive

[Andrey Volkov <avolkov@xxxxxxxxxxxx>]

Public bug reported:

nova: 6d61c61a32

To reproduce:
1. Create a new RP
2. Associate a trait with it.
3. Try to delete the RP.

Error:
Response: 
{"computeFault": {"message": "The server has either erred or is incapable of performing the requested operation.", "code": 500}}

(Pdb) __exception__
(<class 'oslo_db.exception.DBReferenceError'>, DBReferenceError(u"(pymysql.err.IntegrityError) (1451, u'Cannot delete or update a parent row: a foreign key constraint fails (`nova_api`.`resource_provider_traits`, CONSTRAINT `resource_provider_traits_ibfk_1` FOREIGN KEY (`resource_provider_id`) REFERENCES `resource_providers` (`id`))') [SQL: u'DELETE FROM resource_providers WHERE resource_providers.id = %(id_1)s'] [parameters: {u'id_1': 17}]",))

** Affects: nova
     Importance: Low
         Status: New


** Tags: low-hanging-fruit placement

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

Title:
  Placement: resource provider can't be deleted if there is trait
  associated with it

Status in OpenStack Compute (nova):
  New

Bug description:
  nova: 6d61c61a32

  To reproduce:
  1. Create a new RP
  2. Associate a trait with it.
  3. Try to delete the RP.

  Error:
  Response: 
  {"computeFault": {"message": "The server has either erred or is incapable of performing the requested operation.", "code": 500}}

  (Pdb) __exception__
  (<class 'oslo_db.exception.DBReferenceError'>, DBReferenceError(u"(pymysql.err.IntegrityError) (1451, u'Cannot delete or update a parent row: a foreign key constraint fails (`nova_api`.`resource_provider_traits`, CONSTRAINT `resource_provider_traits_ibfk_1` FOREIGN KEY (`resource_provider_id`) REFERENCES `resource_providers` (`id`))') [SQL: u'DELETE FROM resource_providers WHERE resource_providers.id = %(id_1)s'] [parameters: {u'id_1': 17}]",))

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