search

mbari-org / annosaurus

Service for storing and retrieving video/image annotations from VARS
https://docs.mbari.org/annosaurus/
Apache License 2.0
1 stars 1 forks source link

Deadlocks when annotating while merge is running #7

Closed hohonuuli closed 11 months ago

hohonuuli commented 5 years ago

Getting this exception: 

[EL Warning]: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 219) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Error Code: 1205
Call: DELETE FROM ancillary_data WHERE imaged_moment_uuid IN (SELECT uuid FROM imaged_moments WHERE video_reference_uuid = ?)
    bind => [1 parameter bound]
Query: DataModifyQuery(sql="DELETE FROM ancillary_data WHERE imaged_moment_uuid IN (SELECT uuid FROM imaged_moments WHERE video_reference_uuid = ?)")

My suspicion is that the deadlocks are occurring while merge is happening on data sets that users are annotating.

hohonuuli commented 11 months ago

This hasn't occurred in a few years now. Closing.