Ask Your Question
0

magnum-api DBNonExistentTable (sqlite3.OperationalError) no such table: magnum_service

asked 2017-05-26 00:28:56 -0500

CK Lai gravatar image

I'm installing Magnum by following https://docs.openstack.org/project-install-guide/container-infrastructure-management/ocata/get_started.html (this guide). Installation was smooth but it is having error in verifying steps. When I run "magnum service-list", it returned:

ERROR: Remote error: DBNonExistentTable (sqlite3 (HTTP 500) (Request-ID: req-6ee72050-d534-42bd-be0f-12ece7d2c262)

The following error is shown in magnum-api.log:

2017-05-26 02:02:12.028 46907 ERROR wsme.api [req-5cd06f3e-6c02-49fe-b479-438501d6e629 10822534c1a64b838ca654b1805cf468 1a0a4243540c4c3cb5a0964e8adc600c default - -] Server-side error: "Remote error: DBNonExistentTable (sqlite3.OperationalError) no such table: magnum_service [SQL: u'SELECT magnum_service.created_at AS magnum_service_created_at, magnum_service.updated_at AS magnum_service_updated_at, magnum_service.id AS magnum_service_id, magnum_service.host AS magnum_service_host, magnum_service.binary AS magnum_service_binary, magnum_service.disabled AS magnum_service_disabled, magnum_service.disabled_reason AS magnum_service_disabled_reason, magnum_service.last_seen_up AS magnum_service_last_seen_up, magnum_service.forced_down AS magnum_service_forced_down, magnum_service.report_count AS magnum_service_report_count \nFROM magnum_service ORDER BY magnum_service.id ASC']
[u'Traceback (most recent call last):\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/magnum/conductor/handlers/indirection_api.py", line 33, in _object_dispatch\n    return getattr(target, method)(context, *args, **kwargs)\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/oslo_versionedobjects/base.py", line 184, in wrapper\n    result = fn(cls, context, *args, **kwargs)\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/magnum/objects/magnum_service.py", line 84, in list\n    sort_dir=sort_dir)\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/magnum/db/sqlalchemy/api.py", line 547, in get_magnum_service_list\n    sort_key, sort_dir, query)\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/magnum/db/sqlalchemy/api.py", line 114, in _paginate_query\n    return query.all()\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2703, in all\n    return list(self)\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2855, in __iter__\n    return self._execute_and_instances(context)\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in _execute_and_instances\n    result = conn.execute(querycontext.statement, self._params)\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute\n    return meth(self, multiparams, params)\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement\n    compiled_sql, distilled_params\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context\n    context)\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1398, in _handle_dbapi_exception\n    util.raise_from_cause(newraise, exc_info)\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause\n    reraise(type(exception), exception, tb=exc_tb, cause=cause)\n', u'  File "/var/lib/magnum/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context\n    context)\n', u'  File "/var ...
(more)
edit retag flag offensive close merge delete

1 answer

Sort by » oldest newest most voted
0

answered 2017-05-26 04:42:53 -0500

CK Lai gravatar image

This issue is fixed. It was due to the environment settings for magnum which was configured in Liberty release. I have wiped the Liberty and installed Ocata release but have missed these environment settings for magnum.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2017-05-26 00:28:56 -0500

Seen: 212 times

Last updated: May 26 '17