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

Solution In Progress - Updated -

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}]

Environment

Red Hat OpenStack Platform 10

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In