The error is in DB migration 80, which hasn't changed in seven years:
2022-09-15 11:00:37.348 9 CRITICAL designate [designate-manage - - - - -] Unhandled error: oslo_db.exception.DBMigrationError: Neither 'Column' object nor 'Comparator' object has an attribute '_get_table' 2022-09-15 11:00:37.348 9 ERROR designate Traceback (most recent call last): 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 846, in __getattr__ 2022-09-15 11:00:37.348 9 ERROR designate return getattr(self.comparator, key) 2022-09-15 11:00:37.348 9 ERROR designate AttributeError: 'Comparator' object has no attribute '_get_table' 2022-09-15 11:00:37.348 9 ERROR designate 2022-09-15 11:00:37.348 9 ERROR designate The above exception was the direct cause of the following exception: 2022-09-15 11:00:37.348 9 ERROR designate 2022-09-15 11:00:37.348 9 ERROR designate Traceback (most recent call last): 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/oslo_db/sqlalchemy/migration.py", line 87, in db_sync 2022-09-15 11:00:37.348 9 ERROR designate migration = versioning_api.upgrade(engine, repository, version) 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/migrate/versioning/api.py", line 186, in upgrade 2022-09-15 11:00:37.348 9 ERROR designate return _migrate(url, repository, version, upgrade=True, err=err, **opts) 2022-09-15 11:00:37.348 9 ERROR designate File "<decorator-gen-15>", line 2, in _migrate 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine 2022-09-15 11:00:37.348 9 ERROR designate return f(*a, **kw) 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/migrate/versioning/api.py", line 366, in _migrate 2022-09-15 11:00:37.348 9 ERROR designate schema.runchange(ver, change, changeset.step) 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/migrate/versioning/schema.py", line 93, in runchange 2022-09-15 11:00:37.348 9 ERROR designate change.run(self.engine, step) 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/migrate/versioning/script/py.py", line 154, in run 2022-09-15 11:00:37.348 9 ERROR designate script_func(engine) 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/designate/storage/impl_sqlalchemy/migrate_repo/versions/080_domain_to_zone_rename.py", line 108, in upgrade 2022-09-15 11:00:37.348 9 ERROR designate drop_foreign_key(fk) 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/designate/storage/impl_sqlalchemy/migrate_repo/versions/080_domain_to_zone_rename.py", line 52, in drop_foreign_key 2022-09-15 11:00:37.348 9 ERROR designate table = fk_def[0]._get_table() 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 848, in __getattr__ 2022-09-15 11:00:37.348 9 ERROR designate util.raise_( 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ 2022-09-15 11:00:37.348 9 ERROR designate raise exception 2022-09-15 11:00:37.348 9 ERROR designate AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute '_get_table' 2022-09-15 11:00:37.348 9 ERROR designate 2022-09-15 11:00:37.348 9 ERROR designate During handling of the above exception, another exception occurred: 2022-09-15 11:00:37.348 9 ERROR designate 2022-09-15 11:00:37.348 9 ERROR designate Traceback (most recent call last): 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/bin/designate-manage", line 10, in <module> 2022-09-15 11:00:37.348 9 ERROR designate sys.exit(main()) 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/designate/cmd/manage.py", line 123, in main 2022-09-15 11:00:37.348 9 ERROR designate fn(*fn_args) 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/designate/manage/database.py", line 49, in sync 2022-09-15 11:00:37.348 9 ERROR designate get_manager().upgrade(None) 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/oslo_db/sqlalchemy/migration_cli/manager.py", line 72, in upgrade 2022-09-15 11:00:37.348 9 ERROR designate results.append(plugin.upgrade(None)) 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/oslo_db/sqlalchemy/migration_cli/ext_migrate.py", line 45, in upgrade 2022-09-15 11:00:37.348 9 ERROR designate return migration.db_sync( 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/debtcollector/removals.py", line 242, in wrapper 2022-09-15 11:00:37.348 9 ERROR designate return f(*args, **kwargs) 2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/python3.9/site-packages/oslo_db/sqlalchemy/migration.py", line 89, in db_sync 2022-09-15 11:00:37.348 9 ERROR designate raise exception.DBMigrationError(ex) 2022-09-15 11:00:37.348 9 ERROR designate oslo_db.exception.DBMigrationError: Neither 'Column' object nor 'Comparator' object has an attribute '_get_table' 2022-09-15 11:00:37.348 9 ERROR designate
The error is in DB migration 80, which hasn't changed in seven years:
2022-09-15 11:00:37.348 9 CRITICAL designate [designate-manage - - - - -] Unhandled error: oslo_db. exception. DBMigrationErro r: Neither 'Column' object nor 'Comparator' object has an attribute '_get_table' python3. 9/site- packages/ sqlalchemy/ sql/elements. py", line 846, in __getattr__ self.comparator , key) python3. 9/site- packages/ oslo_db/ sqlalchemy/ migration. py", line 87, in db_sync api.upgrade( engine, repository, version) python3. 9/site- packages/ migrate/ versioning/ api.py" , line 186, in upgrade gen-15> ", line 2, in _migrate python3. 9/site- packages/ migrate/ versioning/ util/__ init__. py", line 167, in with_engine python3. 9/site- packages/ migrate/ versioning/ api.py" , line 366, in _migrate runchange( ver, change, changeset.step) python3. 9/site- packages/ migrate/ versioning/ schema. py", line 93, in runchange run(self. engine, step) python3. 9/site- packages/ migrate/ versioning/ script/ py.py", line 154, in run python3. 9/site- packages/ designate/ storage/ impl_sqlalchemy /migrate_ repo/versions/ 080_domain_ to_zone_ rename. py", line 108, in upgrade key(fk) python3. 9/site- packages/ designate/ storage/ impl_sqlalchemy /migrate_ repo/versions/ 080_domain_ to_zone_ rename. py", line 52, in drop_foreign_key 0]._get_ table() python3. 9/site- packages/ sqlalchemy/ sql/elements. py", line 848, in __getattr__ python3. 9/site- packages/ sqlalchemy/ util/compat. py", line 208, in raise_ designate- manage" , line 10, in <module> python3. 9/site- packages/ designate/ cmd/manage. py", line 123, in main python3. 9/site- packages/ designate/ manage/ database. py", line 49, in sync ).upgrade( None) python3. 9/site- packages/ oslo_db/ sqlalchemy/ migration_ cli/manager. py", line 72, in upgrade append( plugin. upgrade( None)) python3. 9/site- packages/ oslo_db/ sqlalchemy/ migration_ cli/ext_ migrate. py", line 45, in upgrade python3. 9/site- packages/ debtcollector/ removals. py", line 242, in wrapper python3. 9/site- packages/ oslo_db/ sqlalchemy/ migration. py", line 89, in db_sync DBMigrationErro r(ex) exception. DBMigrationErro r: Neither 'Column' object nor 'Comparator' object has an attribute '_get_table'
2022-09-15 11:00:37.348 9 ERROR designate Traceback (most recent call last):
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib64/
2022-09-15 11:00:37.348 9 ERROR designate return getattr(
2022-09-15 11:00:37.348 9 ERROR designate AttributeError: 'Comparator' object has no attribute '_get_table'
2022-09-15 11:00:37.348 9 ERROR designate
2022-09-15 11:00:37.348 9 ERROR designate The above exception was the direct cause of the following exception:
2022-09-15 11:00:37.348 9 ERROR designate
2022-09-15 11:00:37.348 9 ERROR designate Traceback (most recent call last):
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate migration = versioning_
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2022-09-15 11:00:37.348 9 ERROR designate File "<decorator-
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate return f(*a, **kw)
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate schema.
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate change.
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate script_func(engine)
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate drop_foreign_
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate table = fk_def[
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib64/
2022-09-15 11:00:37.348 9 ERROR designate util.raise_(
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib64/
2022-09-15 11:00:37.348 9 ERROR designate raise exception
2022-09-15 11:00:37.348 9 ERROR designate AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute '_get_table'
2022-09-15 11:00:37.348 9 ERROR designate
2022-09-15 11:00:37.348 9 ERROR designate During handling of the above exception, another exception occurred:
2022-09-15 11:00:37.348 9 ERROR designate
2022-09-15 11:00:37.348 9 ERROR designate Traceback (most recent call last):
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/bin/
2022-09-15 11:00:37.348 9 ERROR designate sys.exit(main())
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate fn(*fn_args)
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate get_manager(
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate results.
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate return migration.db_sync(
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate return f(*args, **kwargs)
2022-09-15 11:00:37.348 9 ERROR designate File "/usr/lib/
2022-09-15 11:00:37.348 9 ERROR designate raise exception.
2022-09-15 11:00:37.348 9 ERROR designate oslo_db.
2022-09-15 11:00:37.348 9 ERROR designate