Comment 3 for bug 1904599

Missing credential table reported in the keystone manage log. Authentication service not available to the other services.

2021-05-19 16:26:42.938 22647 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)
2021-05-19 16:26:42.938 22647 ERROR keystone Traceback (most recent call last):
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
2021-05-19 16:26:42.938 22647 ERROR keystone self.dialect.do_execute(
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
2021-05-19 16:26:42.938 22647 ERROR keystone cursor.execute(statement, parameters)
2021-05-19 16:26:42.938 22647 ERROR keystone sqlite3.OperationalError: no such table: credential
2021-05-19 16:26:42.938 22647 ERROR keystone
2021-05-19 16:26:42.938 22647 ERROR keystone The above exception was the direct cause of the following exception:
2021-05-19 16:26:42.938 22647 ERROR keystone
2021-05-19 16:26:42.938 22647 ERROR keystone Traceback (most recent call last):
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module>
2021-05-19 16:26:42.938 22647 ERROR keystone sys.exit(main())
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/cmd/manage.py", line 41, in main
2021-05-19 16:26:42.938 22647 ERROR keystone cli.main(argv=sys.argv, developer_config_file=developer_config)
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/cmd/cli.py", line 1379, in main
2021-05-19 16:26:42.938 22647 ERROR keystone CONF.command.cmd_class.main()
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/cmd/cli.py", line 780, in main
2021-05-19 16:26:42.938 22647 ERROR keystone klass.migrate_credentials()
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/cmd/cli.py", line 752, in migrate_credentials
2021-05-19 16:26:42.938 22647 ERROR keystone credentials = self.credential_api.driver.list_credentials(
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/common/driver_hints.py", line 42, in wrapper
2021-05-19 16:26:42.938 22647 ERROR keystone return f(self, hints, *args, **kwargs)
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/credential/backends/sql.py", line 69, in list_credentials
2021-05-19 16:26:42.938 22647 ERROR keystone return [s.to_dict() for s in credentials]
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3367, in __iter__
2021-05-19 16:26:42.938 22647 ERROR keystone return self._execute_and_instances(context)
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3392, in _execute_and_instances
2021-05-19 16:26:42.938 22647 ERROR keystone result = conn.execute(querycontext.statement, self._params)
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 982, in execute
2021-05-19 16:26:42.938 22647 ERROR keystone return meth(self, multiparams, params)
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
2021-05-19 16:26:42.938 22647 ERROR keystone return connection._execute_clauseelement(self, multiparams, params)
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1095, in _execute_clauseelement
2021-05-19 16:26:42.938 22647 ERROR keystone ret = self._execute_context(
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
2021-05-19 16:26:42.938 22647 ERROR keystone self._handle_dbapi_exception(
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1474, in _handle_dbapi_exception
2021-05-19 16:26:42.938 22647 ERROR keystone util.raise_from_cause(newraise, exc_info)
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
2021-05-19 16:26:42.938 22647 ERROR keystone reraise(type(exception), exception, tb=exc_tb, cause=cause)
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 152, in reraise
2021-05-19 16:26:42.938 22647 ERROR keystone raise value.with_traceback(tb)
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
2021-05-19 16:26:42.938 22647 ERROR keystone self.dialect.do_execute(
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
2021-05-19 16:26:42.938 22647 ERROR keystone cursor.execute(statement, parameters)
2021-05-19 16:26:42.938 22647 ERROR keystone oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) no such table: credential
2021-05-19 16:26:42.938 22647 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
2021-05-19 16:26:42.938 22647 ERROR keystone FROM credential]
2021-05-19 16:26:42.938 22647 ERROR keystone (Background on this error at: http://sqlalche.me/e/e3q8)
2021-05-19 16:26:42.938 22647 ERROR keystone