View Issue Details

IDProjectCategoryView StatusLast Update
0002860SymmetricDSImprovementpublic2016-10-20 12:42
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.8.0 
Target Version3.8.7Fixed in Version3.8.7 
Summary0002860: Avoid locks in extract query with dirty reads
DescriptionSome systems get deadlocks from the extract query running, which joins sym_data, sym_data_event, and sym_outgoing_batch. Since the batch status of NE indicates the batch is committed and completed, it is safe to use an uncommitted read isolation level for this query.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 858f67bb

2016-10-13 12:31:35

admin

Details Diff
0002860: Avoid locks in extract query with dirty reads Affected Issues
0002860
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

SymmetricDS: 3.8 88070307

2016-10-13 15:17:23

admin

Details Diff
0002860: Avoid locks in extract query with dirty reads Affected Issues
0002860
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/AcknowledgeService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/IncomingBatchService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/OutgoingBatchService.java Diff File

Issue History

Date Modified Username Field Change
2016-10-13 16:29 elong New Issue
2016-10-13 16:29 elong Status new => assigned
2016-10-13 16:29 elong Assigned To => elong
2016-10-13 16:31 elong Status assigned => resolved
2016-10-13 16:31 elong Fixed in Version => 3.8.7
2016-10-13 16:31 elong Resolution open => fixed
2016-10-13 17:00 admin Changeset attached => SymmetricDS 3.8 858f67bb
2016-10-13 20:00 admin Changeset attached => SymmetricDS 3.8 88070307
2016-10-20 12:42 chenson Status resolved => closed