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."}
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_reordersADD CONSTRAINTproduct_reorders_ibfk_1FOREIGN KEY (product_id) REFERENCESproduct(product_id) ON DELETE CASCADE: rpc error: code = InvalidArgument desc = The foreign keyproduct_reorders_ibfk_1in the tableproduct_reorderscannot have an ON DELETE CASCADE referential action. The referenced tableproducthas already a delete cascading effect on the referencing tableproduct_reordersthrough an IN PARENT ON DELETE CASCADE clause."}