spanner-migration-tool icon indicating copy to clipboard operation
spanner-migration-tool copied to clipboard

Spanner throws error creating Foreign Keys referring the same column concurrently

Open Deep1998 opened this issue 3 years ago • 0 comments

When multiple create FK requests are sent to spanner where the referenced column is same and require internal index creation, spanner throws an error of the form The schema change adding index IDX_contract_ContractID_U_09F242C8CD7BD34 for foreign key FK_contract_sku_3 must finish before adding foreign key FK_fingerprint_contract_2.

Deep1998 avatar Sep 08 '21 17:09 Deep1998