Unexpected API error

[Baptiste ROSA]

Hi,

Get an error message when I run the command: "openstack compute service list - nova-compute service" command referring to the openstack documentation. the error output message : Erreur d'API inattendue. Signalez-la sur http://bugs.launchpad.net/nova/ et joignez-y le journal de l'API Nova si possible.
<class 'sqlalchemy.exc.NoSuchModuleError'> (HTTP 500) (Request-ID: req-846c6a4a-a513-4814-bddb-391350283f36)
"

I run Openstack environnement on Queens and my version of nova is :
nova --version
9.1.1

I join the nova-api.log

Thanks a lot for your help

[Matt Riedemann (mriedem)]

This is the error on startup (looks like you're not running with wsgi):

2018-03-25 19:31:17.366 3508 ERROR oslo_service.service [req-1753c2d0-d19f-4466-92fa-35f96ba6e0ac - - - - -] Error starting thread.: DBNonExistentTable: (sqlite3.OperationalError) no such table: services [SQL: u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, 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, services.last_seen_up AS services_last_seen_up, services.forced_down AS services_forced_down, services.version AS services_version \nFROM services \nWHERE services.deleted = ? AND services.host = ? AND services.binary = ?\n LIMIT ? OFFSET ?'] [parameters: (0, '0.0.0.0', 'nova-metadata', 1, 0)]
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service Traceback (most recent call last):
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/oslo_service/service.py", line 729, in run_service
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service service.start()
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/nova/service.py", line 396, in start
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service self.binary)
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/oslo_versionedobjects/base.py", line 184, in wrapper
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service result = fn(cls, context, *args, **kwargs)
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/nova/objects/service.py", line 314, in get_by_host_and_binary
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service host, binary)
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 133, in service_get_by_host_and_binary
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service return IMPL.service_get_by_host_and_binary(context, host, binary)
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 268, in wrapped
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service return f(context, *args, **kwargs)
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 526, in service_get_by_host_and_binary
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service filter_by(binary=binary).\
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2755, in first
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service ret = list(self[0:1])
2018-03-25 19:31:17.366 3508 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", li...