Comment 6 for bug 1894866

Revision history for this message
John George (jog) wrote :

keystone-manage.log has the following error:

CRITICAL keystone [-] Unhandled error: oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) no such table: credential
[SQL: SELECT credential.encrypted_blob AS credential_encrypted_blob, credential.id AS credential_id, credential.user_id AS credential_user_id, credential.project_id AS credential_project_id, credential.type AS credential_type, credential.key_hash AS credential_key_hash, credential.extra AS credential_extra
FROM credential]
(Background on this error at: http://sqlalche.me/e/e3q8)
2020-09-25 22:06:58.834 22172 ERROR keystone Traceback (most recent call last):
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
2020-09-25 22:06:58.834 22172 ERROR keystone cursor, statement, parameters, context
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
2020-09-25 22:06:58.834 22172 ERROR keystone cursor.execute(statement, parameters)
2020-09-25 22:06:58.834 22172 ERROR keystone sqlite3.OperationalError: no such table: credential
2020-09-25 22:06:58.834 22172 ERROR keystone
2020-09-25 22:06:58.834 22172 ERROR keystone The above exception was the direct cause of the following exception:
2020-09-25 22:06:58.834 22172 ERROR keystone
2020-09-25 22:06:58.834 22172 ERROR keystone Traceback (most recent call last):
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module>
2020-09-25 22:06:58.834 22172 ERROR keystone sys.exit(main())
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/cmd/manage.py", line 41, in main
2020-09-25 22:06:58.834 22172 ERROR keystone cli.main(argv=sys.argv, developer_config_file=developer_config)
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/cmd/cli.py", line 1379, in main
2020-09-25 22:06:58.834 22172 ERROR keystone CONF.command.cmd_class.main()
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/cmd/cli.py", line 780, in main
2020-09-25 22:06:58.834 22172 ERROR keystone klass.migrate_credentials()
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/cmd/cli.py", line 753, in migrate_credentials
2020-09-25 22:06:58.834 22172 ERROR keystone driver_hints.Hints()
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/common/driver_hints.py", line 42, in wrapper
2020-09-25 22:06:58.834 22172 ERROR keystone return f(self, hints, *args, **kwargs)
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/credential/backends/sql.py", line 69, in list_credentials
2020-09-25 22:06:58.834 22172 ERROR keystone return [s.to_dict() for s in credentials]
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3367, in __iter__
2020-09-25 22:06:58.834 22172 ERROR keystone return self._execute_and_instances(context)
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3392, in _execute_and_instances
2020-09-25 22:06:58.834 22172 ERROR keystone result = conn.execute(querycontext.statement, self._params)
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 982, in execute
2020-09-25 22:06:58.834 22172 ERROR keystone return meth(self, multiparams, params)
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
2020-09-25 22:06:58.834 22172 ERROR keystone return connection._execute_clauseelement(self, multiparams, params)
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1101, in _execute_clauseelement
2020-09-25 22:06:58.834 22172 ERROR keystone distilled_params,
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1250, in _execute_context
2020-09-25 22:06:58.834 22172 ERROR keystone e, statement, parameters, cursor, context
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1474, in _handle_dbapi_exception
2020-09-25 22:06:58.834 22172 ERROR keystone util.raise_from_cause(newraise, exc_info)
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
2020-09-25 22:06:58.834 22172 ERROR keystone reraise(type(exception), exception, tb=exc_tb, cause=cause)
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 152, in reraise
2020-09-25 22:06:58.834 22172 ERROR keystone raise value.with_traceback(tb)
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
2020-09-25 22:06:58.834 22172 ERROR keystone cursor, statement, parameters, context
2020-09-25 22:06:58.834 22172 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
2020-09-25 22:06:58.834 22172 ERROR keystone cursor.execute(statement, parameters)
2020-09-25 22:06:58.834 22172 ERROR keystone oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) no such table: credential
2020-09-25 22:06:58.834 22172 ERROR keystone [SQL: SELECT credential.encrypted_blob AS credential_encrypted_blob, credential.id AS credential_id, credential.user_id AS credential_user_id, credential.project_id AS credential_project_id, credential.type AS credential_type, credential.key_hash AS credential_key_hash, credential.extra AS credential_extra
2020-09-25 22:06:58.834 22172 ERROR keystone FROM credential]
2020-09-25 22:06:58.834 22172 ERROR keystone (Background on this error at: http://sqlalche.me/e/e3q8)
2020-09-25 22:06:58.834 22172 ERROR keystone