Services list is unavailable

[Alexander Tivelkov]

Two OSTF tests have failed for job: https://packaging-ci.infra.mirantis.net/job/9.0-pkg-systest-ubuntu/2249

AssertionError: Failed 2 OSTF tests; should fail 0 tests. Names of failed tests:
  - Request active services list (failure) Services list is unavailable. Please refer to OpenStack logs for more details.
  - Check that required services are running (failure) 'nova service-list' command execution failed. Please refer to OpenStack logs for more details.

Seems like there is some issue with listing of services.

Traceback: http://paste.openstack.org/show/589867/

[Oleksiy Molchanov (omolchanov)]

Nova team, can you check?

<179>Nov 16 00:15:13 node-1 nova-api: 2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions [req-85919abf-fb3c-4d6a-9a6e-dc41de42c0b7 22c816ec2dd540b78f62e7a77e1d3de8 f194e4daf70e460fb873bd63e92adbaa - - -] Unexpected exception in API method
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions Traceback (most recent call last):
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/api/openstack/extensions.py", line 478, in wrapped
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions return f(*args, **kwargs)
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/api/openstack/compute/services.py", line 194, in index
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions _services = self._get_services_list(req)
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/api/openstack/compute/services.py", line 87, in _get_services_list
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions _services = self._get_services(req)
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/api/openstack/compute/services.py", line 49, in _get_services
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions for s in self.host_api.service_get_all(context, set_zones=True)
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 3736, in service_get_all
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions set_zones=set_zones)
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/oslo_versionedobjects/base.py", line 181, in wrapper
2016-11-16 00:15:13.171 28169 ERROR nova.api.openstack.extensions result = fn(cls, context, *args, **kwargs)
2016-11-16 00:15:13.171 28169 ERROR nova.api.op
<182>Nov 16 00:15:13 node-1 nova-api: 2016-11-16 00:15:13.214 28169 INFO nova.api.openstack.wsgi [req-85919abf-fb3c-4d6a-9a6e-dc41de42c0b7 22c816ec2dd540b78f62e7a77e1d3de8 f194e4daf70e460fb873bd63e92adbaa - - -] HTTP exception thrown: Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
<class 'sqlalchemy.exc.OperationalError'>
<183>Nov 16 00:15:13 node-1 nova-api: 2016-11-16 00:15:13.217 28169 DEBUG nova.api.openstack.wsgi [req-85919abf-fb3c-4d6a-9a6e-dc41de42c0b7 22c816ec2dd540b78f62e7a77e1d3de8 f194e4daf70e460fb873bd63e92adbaa - - -] Returning 500 to user: Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
<class 'sqlalchemy.exc.OperationalError'> __call__ /usr/lib/python2.7/dist-packages/nova/api/openstack/wsgi.py:1070