GoogleCloudPlatform / GoogleCloudPlatform/spanner-migration-tool
Bug - Web UI Does not Report Dropped Foreign Keys when migrating from MySQL
- Dominant language
- PLpgSQL
- Stars
- 155
- Forks
- 83
- Avg merge
- 3d 7h
- Merged PRs (30d)
- 6
Description
Migrating from MySQL instance, Foreign key constraint was dropped during migration process due to ON DELETE CASCADE clause that could no be parsed. Web UI did not report that the foreign key had been dropped.
Error Message (as seen in the logs):
Unexpected condition {"condition": "Can't add foreign key with statement ALTER TABLE `product_reorders` ADD CONSTRAINT `product_reorders_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `product` (`product_id`) ON DELETE CASCADE: rpc error: code = InvalidArgument desc = The foreign key `product_reorders_ibfk_1` in the table `product_reorders` cannot have an ON DELETE CASCADE referential action. The referenced table `product` has already a delete cascading effect on the referencing table `product_reorders` through an IN PARENT ON DELETE CASCADE clause."}
Contributor guide
Assessment
This issue has not been assessed yet.