GoogleCloudPlatform / GoogleCloudPlatform/spanner-migration-tool
Spanner throws error creating Foreign Keys referring the same column concurrently
Open
p3
- Dominant language
- PLpgSQL
- Stars
- 155
- Forks
- 83
- Avg merge
- 3d 7h
- Merged PRs (30d)
- 6
Description
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.`
Contributor guide
Assessment
This issue has not been assessed yet.