String_Split issue #31
Comments
|
May I ask on which compatibility level for the SQL database you are? You can find that out by running |
beandrad
added a commit
to beandrad/terraform-provider-mssql
that referenced
this issue
Dec 14, 2022
When creating or updating a mssql user in servers with compatibility level below 130, the `string_split` function needs to be created. At the moment, this is causing issues when trying to create/update multiple users, as each of those requests tries to create the same function. This change introduces a lock on application resource in exclusive mode so that only one of the calls creates the function. Fixes betr-io#31
beandrad
added a commit
to beandrad/terraform-provider-mssql
that referenced
this issue
Dec 14, 2022
When creating or updating a mssql user in servers with compatibility level below 130, the `string_split` function needs to be created. At the moment, this is causing issues when trying to create/update multiple users, as each of those requests tries to create the same function. This change introduces a lock on application resource in exclusive mode so that only one of the calls creates the function. Fixes betr-io#31
beandrad
added a commit
to beandrad/terraform-provider-mssql
that referenced
this issue
Dec 14, 2022
When creating or updating a mssql user in servers with compatibility level below 130, the `string_split` function needs to be created. At the moment, this is causing issues when trying to create/update multiple users, as each of those requests tries to create the same function. This change introduces a lock on application resource in exclusive mode so that only one of the calls creates the function. Fixes betr-io#31
beandrad
added a commit
to beandrad/terraform-provider-mssql
that referenced
this issue
Dec 14, 2022
When creating or updating a mssql user in servers with compatibility level below 130, the `string_split` function needs to be created. At the moment, this is causing issues when trying to create/update multiple users, as each of those requests tries to create the same function. This change introduces a lock on application resource in exclusive mode so that only one of the calls creates the function. Fixes betr-io#31
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I'm currently using version 0.2.4 of the provider and I encounter issues creating multiple users for the same database.
The error message is the following :
Error: unable to create user USER: mssql: There is already an object named 'String_Split' in the databaseLooking at the previous issues and PRs, I saw that race condition can occurs if trying to create multiple users & login on the same database and it was supposedly fixed with #24.
Rolling back to 0.2.3 solved the problem
The text was updated successfully, but these errors were encountered: