IntegrityError detected when archiving table aggregates in Red Hat OpenStack Platform 10

Issue

• IntegrityError detected when archiving table aggregates in Red Hat OpenStack Platform 10

• Foreign key constraint error when trying to archive the aggregates table

• nova-manage.log shows:

2019-10-24 02:20:39.447 39627 WARNING nova.db.sqlalchemy.api [-] IntegrityError detected when archiving table aggregates: (pymysql.err.IntegrityError) (1451, u'Cannot delete or update a parent row: a foreign key constraint fails (`nova`.`aggregate_hosts`, CONSTRAINT `aggregate_hosts_ibfk_1` FOREIGN KEY (`aggregate_id`) REFERENCES `aggregates` (`id`))') [SQL: u'DELETE FROM aggregates WHERE aggregates.id in (SELECT T1.id FROM (SELECT aggregates.id \nFROM aggregates \nWHERE aggregates.deleted != %(deleted_1)s ORDER BY aggregates.id \n LIMIT %(param_1)s) as T1)'] [parameters: {u'param_1': 18109, u'deleted_1': 0}]