FHIR Chat · Sql server transaction deadlocked on concurrent transactions · hapi

Stream: hapi

Topic: Sql server transaction deadlocked on concurrent transactions


view this post on Zulip Chandan Datta (Feb 17 2020 at 06:03):

When we try to process concurrent write transactions to a SQL Server 2019 engine using the HAPI RestfulServer class embedded in a spring boot app, we are getting a transaction deadlock error. Each transaction has bundle of 100 resources being saved as a resource type batch. It seems to happen in SQL server, but not in HSQL db in-memory. Is this deadlock issue due to the unique way that Spring JPA deals with SQL server's transaction? Has anyone else run into a similar issue or the same issue?

pasted image


Last updated: Apr 12 2022 at 19:14 UTC