Comment 3 for bug 1989795

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