yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: nova
       Status: Fix Committed => Fix Released

** Changed in: nova
    Milestone: None => liberty-3

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

Title:
  nova service-delete 11-3 returns 500 error

Status in OpenStack Compute (nova):
  Fix Released

Bug description:
  nova service-delete 11-3
  ERROR (ClientException): The server has either erred or is incapable of performing the requested operation. (HTTP 500) (Request-ID: req-931741d5-4013-477e-93cc-c0c90b302ffe)

  the logs shows we need to handle DBError Exception

  
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack     result = conn.execute(querycontext.statement, self._params)
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 662, in execute
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack     params)
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 761, in _execute_clauseelement
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack     compiled_sql, distilled_params
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack     context)
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack   File "/usr/lib/python2.6/site-packages/oslo/db/sqlalchemy/compat/handle_error.py", line 125, in _handle_dbapi_exception
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack     six.reraise(type(newraise), newraise, sys.exc_info()[2])
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack   File "/usr/lib/python2.6/site-packages/oslo/db/sqlalchemy/compat/handle_error.py", line 102, in _handle_dbapi_exception
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack     per_fn = fn(ctx)
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack   File "/usr/lib/python2.6/site-packages/oslo/db/sqlalchemy/exc_filters.py", line 323, in handler
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack     context.is_disconnect)
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack   File "/usr/lib/python2.6/site-packages/oslo/db/sqlalchemy/exc_filters.py", line 278, in _raise_for_remaining_DBAPIError
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack     raise exception.DBError(error)
  2015-07-03 09:54:01.177 11631 TRACE nova.api.openstack DBError: (DataError) ibm_db_dbi::DataError: Statement Execute Failed: [IBM][CLI Driver] CLI0112E  Error in assignment. SQLSTATE=22005 SQLCODE=-99999 'SELECT services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.id AS services_id, services.host AS services_host, services."binary" AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.disabled_reason AS services_disabled_reason \nFROM services \nWHERE services.deleted = ? AND services.id = ? FETCH FIRST 1 ROWS ONLY' (0, '11-3')

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