Hi
I'm trying migrate a keystone installation from stein to train and when I'm running :
keystone-manage db_sync --check
I see the following errors :
2024-03-29 10:48:08.193 469 WARNING py.warnings [-] /usr/lib/python3/dist-packages/sqlalchemy/dialects/mysql/reflection.py:62: SAWarning: Unknown schema content: ' "repository_id" varchar(250) NOT NULL,'
util.warn("Unknown schema content: %r" % line)
2024-03-29 10:48:08.194 469 WARNING py.warnings [-] /usr/lib/python3/dist-packages/sqlalchemy/dialects/mysql/reflection.py:62: SAWarning: Unknown schema content: ' "repository_path" text DEFAULT NULL,'
util.warn("Unknown schema content: %r" % line)
2024-03-29 10:48:08.194 469 WARNING py.warnings [-] /usr/lib/python3/dist-packages/sqlalchemy/dialects/mysql/reflection.py:62: SAWarning: Unknown schema content: ' "version" int(11) DEFAULT NULL,'
util.warn("Unknown schema content: %r" % line)
2024-03-29 10:48:08.197 469 WARNING py.warnings [-] /usr/lib/python3/dist-packages/sqlalchemy/dialects/mysql/reflection.py:62: SAWarning: Unknown schema content: ' "id" int(11) NOT NULL AUTO_INCREMENT,'
util.warn("Unknown schema content: %r" % line)
: migrate.exceptions.DatabaseNotControlledError: migrate_version
2024-03-29 10:48:08.199 469 WARNING py.warnings [-] /usr/lib/python3/dist-packages/sqlalchemy/dialects/mysql/reflection.py:62: SAWarning: Unknown schema content: ' "service" varchar(64) DEFAULT NULL,'
util.warn("Unknown schema content: %r" % line)
: migrate.exceptions.DatabaseNotControlledError: migrate_version
2024-03-29 10:48:08.199 469 WARNING py.warnings [-] /usr/lib/python3/dist-packages/sqlalchemy/dialects/mysql/reflection.py:62: SAWarning: Unknown schema content: ' "path" varchar(128) DEFAULT NULL,'
util.warn("Unknown schema content: %r" % line)
: migrate.exceptions.DatabaseNotControlledError: migrate_version
2024-03-29 10:48:08.200 469 WARNING py.warnings [-] /usr/lib/python3/dist-packages/sqlalchemy/dialects/mysql/reflection.py:62: SAWarning: Unknown schema content: ' "method" varchar(16) DEFAULT NULL,'
util.warn("Unknown schema content: %r" % line)
: migrate.exceptions.DatabaseNotControlledError: migrate_version
2024-03-29 10:48:08.201 469 CRITICAL keystone [-] Unhandled error: sqlalchemy.exc.NoSuchTableError: access_rule
2024-03-29 10:48:08.201 469 ERROR keystone Traceback (most recent call last):
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 45, in load
2024-03-29 10:48:08.201 469 ERROR keystone self.table = Table(tname, self.meta, autoload=True)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 469, in __new__
2024-03-29 10:48:08.201 469 ERROR keystone metadata._remove_table(name, schema)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 67, in __exit__
2024-03-29 10:48:08.201 469 ERROR keystone compat.reraise(exc_type, exc_value, exc_tb)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 277, in reraise
2024-03-29 10:48:08.201 469 ERROR keystone raise value
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 464, in __new__
2024-03-29 10:48:08.201 469 ERROR keystone table._init(name, metadata, *args, **kw)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 552, in _init
2024-03-29 10:48:08.201 469 ERROR keystone metadata, autoload_with, include_columns, _extend_on=_extend_on
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 590, in _autoload
2024-03-29 10:48:08.201 469 ERROR keystone _extend_on=_extend_on,
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2125, in run_callable
2024-03-29 10:48:08.201 469 ERROR keystone return conn.run_callable(callable_, *args, **kwargs)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1596, in run_callable
2024-03-29 10:48:08.201 469 ERROR keystone return callable_(self, *args, **kwargs)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 415, in reflecttable
2024-03-29 10:48:08.201 469 ERROR keystone table, include_columns, exclude_columns, **opts
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/reflection.py", line 639, in reflecttable
2024-03-29 10:48:08.201 469 ERROR keystone raise exc.NoSuchTableError(table.name)
2024-03-29 10:48:08.201 469 ERROR keystone sqlalchemy.exc.NoSuchTableError: migrate_version
2024-03-29 10:48:08.201 469 ERROR keystone
2024-03-29 10:48:08.201 469 ERROR keystone During handling of the above exception, another exception occurred:
2024-03-29 10:48:08.201 469 ERROR keystone
2024-03-29 10:48:08.201 469 ERROR keystone Traceback (most recent call last):
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/oslo_db/sqlalchemy/migration.py", line 128, in db_version
2024-03-29 10:48:08.201 469 ERROR keystone return versioning_api.db_version(engine, repository)
2024-03-29 10:48:08.201 469 ERROR keystone File "<decorator-gen-6>", line 2, in db_version
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
2024-03-29 10:48:08.201 469 ERROR keystone return f(*a, **kw)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 148, in db_version
2024-03-29 10:48:08.201 469 ERROR keystone schema = ControlledSchema(engine, repository)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 33, in __init__
2024-03-29 10:48:08.201 469 ERROR keystone self.load()
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 54, in load
2024-03-29 10:48:08.201 469 ERROR keystone exceptions.DatabaseNotControlledError(str(exc)), tb)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/six.py", line 692, in reraise
2024-03-29 10:48:08.201 469 ERROR keystone raise value.with_traceback(tb)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 45, in load
2024-03-29 10:48:08.201 469 ERROR keystone self.table = Table(tname, self.meta, autoload=True)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 469, in __new__
2024-03-29 10:48:08.201 469 ERROR keystone metadata._remove_table(name, schema)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 67, in __exit__
2024-03-29 10:48:08.201 469 ERROR keystone compat.reraise(exc_type, exc_value, exc_tb)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 277, in reraise
2024-03-29 10:48:08.201 469 ERROR keystone raise value
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 464, in __new__
2024-03-29 10:48:08.201 469 ERROR keystone table._init(name, metadata, *args, **kw)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 552, in _init
2024-03-29 10:48:08.201 469 ERROR keystone metadata, autoload_with, include_columns, _extend_on=_extend_on
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 590, in _autoload
2024-03-29 10:48:08.201 469 ERROR keystone _extend_on=_extend_on,
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2125, in run_callable
2024-03-29 10:48:08.201 469 ERROR keystone return conn.run_callable(callable_, *args, **kwargs)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1596, in run_callable
2024-03-29 10:48:08.201 469 ERROR keystone return callable_(self, *args, **kwargs)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 415, in reflecttable
2024-03-29 10:48:08.201 469 ERROR keystone table, include_columns, exclude_columns, **opts
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/reflection.py", line 639, in reflecttable
2024-03-29 10:48:08.201 469 ERROR keystone raise exc.NoSuchTableError(table.name)
2024-03-29 10:48:08.201 469 ERROR keystone migrate.exceptions.DatabaseNotControlledError: migrate_version
2024-03-29 10:48:08.201 469 ERROR keystone
2024-03-29 10:48:08.201 469 ERROR keystone During handling of the above exception, another exception occurred:
2024-03-29 10:48:08.201 469 ERROR keystone
2024-03-29 10:48:08.201 469 ERROR keystone Traceback (most recent call last):
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module>
2024-03-29 10:48:08.201 469 ERROR keystone sys.exit(main())
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/cmd/manage.py", line 41, in main
2024-03-29 10:48:08.201 469 ERROR keystone cli.main(argv=sys.argv, developer_config_file=developer_config)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/cmd/cli.py", line 1370, in main
2024-03-29 10:48:08.201 469 ERROR keystone CONF.command.cmd_class.main()
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/cmd/cli.py", line 327, in main
2024-03-29 10:48:08.201 469 ERROR keystone sys.exit(DbSync.check_db_sync_status())
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/cmd/cli.py", line 269, in check_db_sync_status
2024-03-29 10:48:08.201 469 ERROR keystone expand_version = upgrades.get_db_version(repo='expand_repo')
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/keystone/common/sql/upgrades.py", line 236, in get_db_version
2024-03-29 10:48:08.201 469 ERROR keystone session.get_bind(), repo, get_init_version(repo))
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/oslo_db/sqlalchemy/migration.py", line 131, in db_version
2024-03-29 10:48:08.201 469 ERROR keystone meta.reflect(bind=engine)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 4159, in reflect
2024-03-29 10:48:08.201 469 ERROR keystone Table(name, self, **reflect_opts)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 469, in __new__
2024-03-29 10:48:08.201 469 ERROR keystone metadata._remove_table(name, schema)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 67, in __exit__
2024-03-29 10:48:08.201 469 ERROR keystone compat.reraise(exc_type, exc_value, exc_tb)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 277, in reraise
2024-03-29 10:48:08.201 469 ERROR keystone raise value
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 464, in __new__
2024-03-29 10:48:08.201 469 ERROR keystone table._init(name, metadata, *args, **kw)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 552, in _init
2024-03-29 10:48:08.201 469 ERROR keystone metadata, autoload_with, include_columns, _extend_on=_extend_on
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 574, in _autoload
2024-03-29 10:48:08.201 469 ERROR keystone _extend_on=_extend_on,
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1596, in run_callable
2024-03-29 10:48:08.201 469 ERROR keystone return callable_(self, *args, **kwargs)
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 415, in reflecttable
2024-03-29 10:48:08.201 469 ERROR keystone table, include_columns, exclude_columns, **opts
2024-03-29 10:48:08.201 469 ERROR keystone File "/usr/lib/python3/dist-packages/sqlalchemy/engine/reflection.py", line 639, in reflecttable
2024-03-29 10:48:08.201 469 ERROR keystone raise exc.NoSuchTableError(table.name)
2024-03-29 10:48:08.201 469 ERROR keystone sqlalchemy.exc.NoSuchTableError: access_rule
2024-03-29 10:48:08.201 469 ERROR keystone
I've checked the DB and both tables are there (access_rule and migrate_version).
Do you know what could be wrong ?
Best
Alex