carbon-kernel icon indicating copy to clipboard operation
carbon-kernel copied to clipboard

Published 20 hours ago • verified publisher icon wso2

Apply select with update lock only for MSSQL for updatePropertyWithID method

Open UdeshAthukorala opened this issue 6 months ago • 0 comments

Purpose

The related PR added a change where an update lock is applied to the relevant user attribute rows before being updated. It was noted that this deadlock scenario occurs only in SQL Server, and this syntax of using lock hints WITH (UPDLOCK) is only supported in MSSQL. The deadlock scenario is not reproduced in H2. Therefore this PR excludes other types of DBs from being affected by this fix.

Related PRs

  • https://github.com/wso2/carbon-kernel/pull/3751
  • https://github.com/wso2/carbon-kernel/pull/3748

Related Issues

UdeshAthukorala avatar Aug 12 '24 04:08 UdeshAthukorala