View Issue Details

IDProjectCategoryView StatusLast Update
0005672SymmetricDSImprovementpublic2023-01-31 19:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.0 
Target Version3.13.11Fixed in Version3.13.11 
Summary0005672: Sync triggers fails with deadlock on SQL-Server
DescriptionOn SQL-Server, if the mssql.trigger.order.first parameter is used, it will query system tables to see if there is any existing trigger ordered as first. The query can get a deadlock with other queries on the same system table because of the isolation used on the query.
Tagstrigger

Relationships

related to 0003576 closedelong Sync triggers fails with deadlock on SQL-Server 
related to 0005673 closedelong Sync triggers fails with deadlock on SQL-Server 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.13 67fea918

2023-01-31 18:45:54

admin

Details Diff
0005672: Sync triggers fails with deadlock on SQL-Server Affected Issues
0005672
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlSymmetricDialect.java Diff File

Issue History

Date Modified Username Field Change
2023-01-31 18:56 elong New Issue
2023-01-31 18:56 elong Status new => assigned
2023-01-31 18:56 elong Assigned To => elong
2023-01-31 18:56 elong Tag Attached: trigger
2023-01-31 18:56 elong Issue generated from: 0003576
2023-01-31 18:56 elong Relationship added related to 0003576
2023-01-31 18:56 elong Status assigned => resolved
2023-01-31 18:56 elong Resolution open => fixed
2023-01-31 18:56 elong Fixed in Version => 3.13.11
2023-01-31 18:57 elong Issue cloned: 0005673
2023-01-31 18:57 elong Relationship added related to 0005673
2023-01-31 19:00 admin Changeset attached => SymmetricDS 3.13 67fea918
2023-02-15 20:26 admin Status resolved => closed