Unexpected API error
Bug #1759035 reported by
Baptiste ROSA
This bug report is a duplicate of:
Bug #1757472: Required to define database/connection when running services for nova_api cell.
Edit
Remove
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
New
|
Undecided
|
Unassigned |
Bug Description
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://
<class 'sqlalchemy.
"
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
To post a comment you must log in.
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-35f96ba6e0 ac - - - - -] Error starting thread.: DBNonExistentTable: (sqlite3. OperationalErro r) 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)] service Traceback (most recent call last): service File "/usr/lib/ python2. 7/dist- packages/ oslo_service/ service. py", line 729, in run_service service service.start() service File "/usr/lib/ python2. 7/dist- packages/ nova/service. py", line 396, in start service self.binary) service File "/usr/lib/ python2. 7/dist- packages/ oslo_versionedo bjects/ base.py" , line 184, in wrapper service result = fn(cls, context, *args, **kwargs) service File "/usr/lib/ python2. 7/dist- packages/ nova/objects/ service. py", line 314, in get_by_ host_and_ binary service host, binary) service File "/usr/lib/ python2. 7/dist- packages/ nova/db/ api.py" , line 133, in service_ get_by_ host_and_ binary service return IMPL.service_ get_by_ host_and_ binary( context, host, binary) service File "/usr/lib/ python2. 7/dist- packages/ nova/db/ sqlalchemy/ api.py" , line 268, in wrapped service return f(context, *args, **kwargs) service File "/usr/lib/ python2. 7/dist- packages/ nova/db/ sqlalchemy/ api.py" , line 526, in service_ get_by_ host_and_ binary service filter_ by(binary= binary) .\ service File "/usr/lib/ python2. 7/dist- packages/ sqlalchemy/ orm/query. py", line 2755, in first service ret = list(self[0:1]) service File "/usr/lib/ python2. 7/dist- packages/ sqlalchemy/ orm/query. py", li...
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.
2018-03-25 19:31:17.366 3508 ERROR oslo_service.