yahoo-eng-team team mailing list archive

[jichenjc <jichenjc@xxxxxxxxxx>]

Public bug reported:

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')

** Affects: nova
     Importance: Undecided
     Assignee: jichenjc (jichenjc)
         Status: New

** Changed in: nova
     Assignee: (unassigned) => jichenjc (jichenjc)

-- 
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):
  New

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