View Issue Details

IDProjectCategoryView StatusLast Update
0004591SymmetricDSBugpublic2020-11-09 15:15
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.5Fixed in Version3.12.5 
Summary0004591: Multi-primary out of sync race condition with NEWER_WINS conflicts
DescriptionIn a multi-primary configuration, it is possible to get out of sync when using the default NEWER_WINS conflict resolver included in 3.12. When using more than 2 nodes, there is a race to sync first with a conflicting row. The detection and resolution steps need to keep a lock on the row in the database and record the winning row.
Tagsconflict manager

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 c5de28fe

2020-10-16 12:36:47

admin

Details Diff
0004591: Multi-primary out of sync race condition with NEWER_WINS
conflicts
Affected Issues
0004591
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/load/DefaultDataLoaderFactory.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IDataService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataServiceSqlMap.java Diff File
add - symmetric-db/src/main/java/org/jumpmind/db/util/DatabaseConstants.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/reader/ProtocolDataReader.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/AbstractDatabaseWriter.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/AbstractDatabaseWriterConflictResolver.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/AbstractProtocolDataWriter.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/Conflict.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java Diff File

SymmetricDS: 3.12 368ae3ef

2020-10-23 12:50:34

admin

Details Diff
0004591: Multi-primary out of sync race condition with NEWER_WINS
conflicts
Affected Issues
0004591
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/load/DefaultDataLoaderFactory.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java Diff File

SymmetricDS: 3.12 94236e55

2020-11-02 21:50:02

admin

Details Diff
0004591: improve defensive code Affected Issues
0004591
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/load/DefaultDataLoaderFactory.java Diff File

Issue History

Date Modified Username Field Change
2020-10-15 19:38 elong New Issue
2020-10-15 19:38 elong Status new => assigned
2020-10-15 19:38 elong Assigned To => elong
2020-10-15 19:38 elong Tag Attached: conflict manager
2020-10-16 12:37 elong Status assigned => resolved
2020-10-16 12:37 elong Resolution open => fixed
2020-10-16 12:37 elong Fixed in Version => 3.12.5
2020-10-16 13:00 admin Changeset attached => SymmetricDS 3.12 c5de28fe
2020-10-28 19:00 admin Changeset attached => SymmetricDS 3.12 368ae3ef
2020-11-02 22:00 admin Changeset attached => SymmetricDS 3.12 94236e55
2020-11-09 15:15 admin Status resolved => closed