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
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. DBNonExistentTa ble: (sqlite3. OperationalErro r) no such table: 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 sqlalche. me/e/e3q8) python3/ dist-packages/ sqlalchemy/ engine/ base.py" , line 1245, in _execute_context do_execute( python3/ dist-packages/ sqlalchemy/ engine/ default. py", line 581, in do_execute execute( statement, parameters) OperationalErro r: no such table: credential keystone- manage" , line 10, in <module> python3/ dist-packages/ keystone/ cmd/manage. py", line 41, in main argv=sys. argv, developer_ config_ file=developer_ config) python3/ dist-packages/ keystone/ cmd/cli. py", line 1379, in main cmd_class. main() python3/ dist-packages/ keystone/ cmd/cli. py", line 780, in main credentials( ) python3/ dist-packages/ keystone/ cmd/cli. py", line 752, in migrate_credentials _api.driver. list_credential s( python3/ dist-packages/ keystone/ common/ driver_ hints.py" , line 42, in wrapper python3/ dist-packages/ keystone/ credential/ backends/ sql.py" , line 69, in list_credentials python3/ dist-packages/ sqlalchemy/ orm/query. py", line 3367, in __iter__ and_instances( context) python3/ dist-packages/ sqlalchemy/ orm/query. py", line 3392, in _execute_ and_instances querycontext. statement, self._params) python3/ dist-packages/ sqlalchemy/ engine/ base.py" , line 982, in execute python3/ dist-packages/ sqlalchemy/ sql/elements. py", line 287, in _execute_ on_connection _execute_ clauseelement( self, multiparams, params) python3/ dist-packages/ sqlalchemy/ engine/ base.py" , line 1095, in _execute_ clauseelement context( python3/ dist-packages/ sqlalchemy/ engine/ base.py" , line 1249, in _execute_context dbapi_exception ( python3/ dist-packages/ sqlalchemy/ engine/ base.py" , line 1474, in _handle_ dbapi_exception from_cause( newraise, exc_info) python3/ dist-packages/ sqlalchemy/ util/compat. py", line 398, in raise_from_cause type(exception) , exception, tb=exc_tb, cause=cause) python3/ dist-packages/ sqlalchemy/ util/compat. py", line 152, in reraise traceback( tb) python3/ dist-packages/ sqlalchemy/ engine/ base.py" , line 1245, in _execute_context do_execute( python3/ dist-packages/ sqlalchemy/ engine/ default. py", line 581, in do_execute execute( statement, parameters) exception. DBNonExistentTa ble: (sqlite3. OperationalErro r) no such table: 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 sqlalche. me/e/e3q8)
[SQL: SELECT credential.
FROM credential]
(Background on this error at: http://
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/
2021-05-19 16:26:42.938 22647 ERROR keystone self.dialect.
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
2021-05-19 16:26:42.938 22647 ERROR keystone cursor.
2021-05-19 16:26:42.938 22647 ERROR keystone sqlite3.
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/
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/
2021-05-19 16:26:42.938 22647 ERROR keystone cli.main(
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
2021-05-19 16:26:42.938 22647 ERROR keystone CONF.command.
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
2021-05-19 16:26:42.938 22647 ERROR keystone klass.migrate_
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
2021-05-19 16:26:42.938 22647 ERROR keystone credentials = self.credential
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
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/
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/
2021-05-19 16:26:42.938 22647 ERROR keystone return self._execute_
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
2021-05-19 16:26:42.938 22647 ERROR keystone result = conn.execute(
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
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/
2021-05-19 16:26:42.938 22647 ERROR keystone return connection.
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
2021-05-19 16:26:42.938 22647 ERROR keystone ret = self._execute_
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
2021-05-19 16:26:42.938 22647 ERROR keystone self._handle_
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
2021-05-19 16:26:42.938 22647 ERROR keystone util.raise_
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
2021-05-19 16:26:42.938 22647 ERROR keystone reraise(
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
2021-05-19 16:26:42.938 22647 ERROR keystone raise value.with_
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
2021-05-19 16:26:42.938 22647 ERROR keystone self.dialect.
2021-05-19 16:26:42.938 22647 ERROR keystone File "/usr/lib/
2021-05-19 16:26:42.938 22647 ERROR keystone cursor.
2021-05-19 16:26:42.938 22647 ERROR keystone oslo_db.
2021-05-19 16:26:42.938 22647 ERROR keystone [SQL: SELECT credential.
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://
2021-05-19 16:26:42.938 22647 ERROR keystone