View Issue Details

IDProjectCategoryView StatusLast Update
0004544SymmetricDSImprovementpublic2020-09-23 16:34
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.4Fixed in Version3.12.4 
Summary0004544: Batch acknowledgement lookup failed data ID only once
DescriptionEvery time a batch is tried or retried with an error, the acknowledgement service queries sym_data to find the failed data ID that matches that line number from the batch. The constant repeating of this query can put a strain on some systems, especially when many clients have batch errors. Instead, we will start recording the failed line number on sym_outgoing_batch. Then, only query the failed data ID if the failed line number has changed.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 d06144ce

2020-09-12 10:12:28

admin

Details Diff
0004544: Batch acknowledgement lookup failed data ID only once Affected Issues
0004544
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/AbstractBatch.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/IncomingBatch.java Diff File
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/OutgoingBatchService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/OutgoingBatchServiceSqlMap.java Diff File

Issue History

Date Modified Username Field Change
2020-09-12 10:10 elong New Issue
2020-09-12 10:10 elong Status new => assigned
2020-09-12 10:10 elong Assigned To => elong
2020-09-12 10:12 elong Status assigned => resolved
2020-09-12 10:12 elong Resolution open => fixed
2020-09-12 10:12 elong Fixed in Version => 3.12.4
2020-09-12 11:00 admin Changeset attached => SymmetricDS 3.12 d06144ce
2020-09-23 16:34 admin Status resolved => closed