Stream: implementers
Topic: Deadlock using SQL Server
Pooja Gupta (Apr 28 2020 at 12:29):
Hello, I recently started using FHIR server and was trying to ingest 10 resources in a bundle, Number of Users = 5, Loop count = 10 thru Jmeter and started seeing DeadlockAcquisitionException on the console.. on analyzing further deadlock was happening on HFJ_Forced_ID table where it checks if the ResourceType + Forced_ID already exists or not. If not, then it marks the resources for creation.
All my resources, in the bundle, use PUT method and use its own ID (logical identifier).
Had gone thru the Google Group as well, and it was suggested to use READ_UNCOMMITTED isolation level. Just wondering if any other way out exists?
Any help/suggestions/feedback.
Grahame Grieve (Apr 28 2020 at 12:36):
which server is that?
Pooja Gupta (Apr 28 2020 at 12:37):
HAPI FHIR JPA Server and DB = SQL Server
Pooja Gupta (Apr 28 2020 at 12:39):
Pooja Gupta (Apr 28 2020 at 12:44):
https://groups.google.com/forum/#!msg/hapi-fhir/lLuRnQZoaU8/0hl9Qg7WAgAJ
Same issue is captured here as well.
Grahame Grieve (Apr 28 2020 at 12:53):
you should probably ask on the hapi support forum then
Pooja Gupta (Apr 28 2020 at 13:01):
sure.. looks like i am at the wrong place then.. thanks
Grahame Grieve (Apr 28 2020 at 13:03):
fraid so
Last updated: Apr 12 2022 at 19:14 UTC
