Deletion of artifact is not possible because of foreign constraint

[Kushal Agrawal]

When created an artifact which has a string/Integer/Boolean as a field property. It is not possible while using MySql database to delete artifact because of foreign constraint failure. It fails with below error :

ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`glare`.`glare_artifact_properties`, CONSTRAINT `glare_artifact_properties_ibfk_1` FOREIGN KEY (`artifact_id`) REFERENCES `glare_artifacts` (`id`))

[Mike Fedosin (mfedosin)]

Emmm... I think the description is not fully correct. I tried to create an artifact on my devstack with dozens of custom fields of all types and then I was able to delete it without any issue.

Could you provide more details about how I can reproduce the bug?

[Kushal Agrawal (kushal2605)]

yes, I think I missed an important part of it. as it does not have any issue with sqllite. But there are issue with mysql database.

The issue is when we created database tables using alembic script we created foreign key using below command:

sa.Column('artifact_id', sa.String(36),
                  sa.ForeignKey('glare_artifacts.id'), nullable=False),

while creating we missed to provide parameter "ondelete='CASCADE'". without it in mysql it becomes as ondelete='RESTRICT' which is default value of it.

Now to drop and recreate the foreign key constraint we found that the name of the foreign-key-constraint is required which is getting decided by the database itself i.e. we do not have control over it. so right now we are not able to drop the constraint because of it. can you please suggest any way to do it?

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/538018