powerauth-server icon indicating copy to clipboard operation
powerauth-server copied to clipboard

Activation expiration can lead to a deadlock on MSSQL

Open romanstrobl opened this issue 7 months ago • 2 comments

When a concurrent update occurs due to activation expiration, this situation can lead to a deadlock on MSSQL, similar to the situation described in issue https://github.com/wultra/powerauth-server/issues/1609.

Deadlock scenario:

  • UPDATE due to background expiration of an activation
  • UPDATE due to expiration of an activation due to request for an activation list, activation status, activation lookup, etc.

romanstrobl avatar Jul 27 '24 19:07 romanstrobl