yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1452697] [NEW] Error Instance can't be deleted when its host is NULL

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: yjx <yjx1991@xxxxxxxxxxxxxxxx>
Date: Thu, 07 May 2015 11:47:16 -0000
Reply-to: Bug 1452697 <1452697@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

     When I created an instance,it failed and VM-state is ERROR.I query the table which named nova.instances ,host is NULL,it results to that I can't be able to delete this instance .
the log is :
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack Traceback (most recent call last):
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/api/openstack/__init__.py", line 119, in __call__
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return req.get_response(self.application)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1296, in send
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     application, catch_exc_info=False)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1260, in call_application
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     app_iter = application(self.environ, start_response)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return resp(environ, start_response)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/keystoneclient/middleware/auth_token.py", line 690, in __call__
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return self.app(env, start_response)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return resp(environ, start_response)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return resp(environ, start_response)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/routes/middleware.py", line 131, in __call__
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     response = self.app(environ, start_response)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return resp(environ, start_response)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 130, in __call__
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     content_type, body, accept)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/api/openstack/wsgi.py", line 997, in _process_stack
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     action_result = self.dispatch(meth, request, action_args)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/api/openstack/wsgi.py", line 1078, in dispatch
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return method(req=request, **action_args)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/api/openstack/compute/servers.py", line 989, in _delete
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     self.compute_api.delete(context, instance)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 202, in wrapped
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return func(self, context, target, *args, **kwargs)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 192, in inner
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return function(self, context, instance, *args, **kwargs)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 219, in _wrapped
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return fn(self, context, instance, *args, **kwargs)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 173, in inner
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return f(self, context, instance, *args, **kw)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 1586, in delete
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     self._delete_instance(context, instance)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 1576, in _delete_instance
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     task_state=task_states.DELETING)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 1410, in _delete
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     user_id=user_id)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 1357, in _delete
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     instance.destroy()
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/objects/base.py", line 147, in wrapper
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return fn(self, ctxt, *args, **kwargs)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/objects/instance.py", line 351, in destroy
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     db.instance_destroy(context, self.uuid, constraint=constraint)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 593, in instance_destroy
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     rv = IMPL.instance_destroy(context, instance_uuid, constraint)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 126, in wrapper
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return f(*args, **kwargs)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 1661, in instance_destroy
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     query = constraint.apply(models.Instance, query)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 338, in apply
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     for clause in condition.clauses(getattr(model, key)):
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 349, in clauses
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return or_([field == value for value in self.values])
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "<string>", line 2, in or_
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 1870, in or_
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return cls._construct(operators.or_, False_, True_, *clauses)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 1774, in _construct
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     clause = _literal_as_text(clause)
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 3462, in _literal_as_text
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     "SQL expression object or string expected."
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack ArgumentError: SQL expression object or string expected.
2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack

my version is havana and icehouse,I test both,all ERROR.

** 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/1452697

Title:
  Error Instance can't be deleted when its host is NULL

Status in OpenStack Compute (Nova):
  New

Bug description:
       When I created an instance,it failed and VM-state is ERROR.I query the table which named nova.instances ,host is NULL,it results to that I can't be able to delete this instance .
  the log is :
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack Traceback (most recent call last):
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/api/openstack/__init__.py", line 119, in __call__
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return req.get_response(self.application)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1296, in send
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     application, catch_exc_info=False)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1260, in call_application
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     app_iter = application(self.environ, start_response)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return resp(environ, start_response)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/keystoneclient/middleware/auth_token.py", line 690, in __call__
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return self.app(env, start_response)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return resp(environ, start_response)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return resp(environ, start_response)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/routes/middleware.py", line 131, in __call__
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     response = self.app(environ, start_response)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return resp(environ, start_response)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 130, in __call__
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     content_type, body, accept)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/api/openstack/wsgi.py", line 997, in _process_stack
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     action_result = self.dispatch(meth, request, action_args)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/api/openstack/wsgi.py", line 1078, in dispatch
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return method(req=request, **action_args)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/api/openstack/compute/servers.py", line 989, in _delete
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     self.compute_api.delete(context, instance)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 202, in wrapped
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return func(self, context, target, *args, **kwargs)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 192, in inner
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return function(self, context, instance, *args, **kwargs)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 219, in _wrapped
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return fn(self, context, instance, *args, **kwargs)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 173, in inner
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return f(self, context, instance, *args, **kw)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 1586, in delete
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     self._delete_instance(context, instance)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 1576, in _delete_instance
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     task_state=task_states.DELETING)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 1410, in _delete
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     user_id=user_id)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 1357, in _delete
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     instance.destroy()
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/objects/base.py", line 147, in wrapper
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return fn(self, ctxt, *args, **kwargs)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/objects/instance.py", line 351, in destroy
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     db.instance_destroy(context, self.uuid, constraint=constraint)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 593, in instance_destroy
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     rv = IMPL.instance_destroy(context, instance_uuid, constraint)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 126, in wrapper
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return f(*args, **kwargs)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 1661, in instance_destroy
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     query = constraint.apply(models.Instance, query)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 338, in apply
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     for clause in condition.clauses(getattr(model, key)):
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 349, in clauses
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return or_([field == value for value in self.values])
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "<string>", line 2, in or_
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 1870, in or_
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     return cls._construct(operators.or_, False_, True_, *clauses)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 1774, in _construct
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     clause = _literal_as_text(clause)
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 3462, in _literal_as_text
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack     "SQL expression object or string expected."
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack ArgumentError: SQL expression object or string expected.
  2015-05-07 16:55:38.240 23178 TRACE nova.api.openstack

  my version is havana and icehouse,I test both,all ERROR.

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

[Bug 1452697] Re: Error Instance can't be deleted when its host is NULL
From: Markus Zoeller, 2015-06-12
[Bug 1452697] [NEW] Error Instance can't be deleted when its host is NULL
From: yjx, 2015-05-07
References

[Bug 1452697] [NEW] Error Instance can't be deleted when its host is NULL
From: yjx, 2015-05-07