GoogleCloudPlatform / GoogleCloudPlatform/spanner-migration-tool

Bug - Web UI Does not Report Dropped Foreign Keys when migrating from MySQL

Open
#1,318 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.