GoogleCloudPlatform / GoogleCloudPlatform/spanner-migration-tool

Spanner throws error creating Foreign Keys referring the same column concurrently

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

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.