View Issue Details

IDProjectCategoryView StatusLast Update
0005023SymmetricDSImprovementpublic2021-06-11 18:00
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.12.10 
Target Version3.12.11Fixed in Version3.12.11 
Summary0005023: Sync Triggers should execute successfully in parallel by table
DescriptionSync Triggers, when first starting up, should be able to run in parallel so that the creation of the triggers is faster.
Right now, the problem is that the name of the triggers can collide if we run each table in parallel (from a thread pool).
We need to provide the names of all of the triggers before starting the creation of the triggers in parallel to make sure that the names do not collide.
TagsNo tags attached.

Activities

pmarzullo

2021-06-10 17:43

developer   ~0001950

Right now, by default, the number of threads to start up for synching triggers is set to 1.
The parameter name is sync.triggers.thread.count.per.server, and can be set to a value larger than 1 to run the creation of triggers in parallel.

Related Changesets

SymmetricDS: 3.12 184eebc0

2021-06-10 17:44:29

pmarzullo

Details Diff
0005023: Sync Triggers should execute successfully in parallel by table Affected Issues
0005023
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

SymmetricDS: 3.13 b47d1ca1

2021-06-10 17:44:29

pmarzullo

Details Diff
0005023: Sync Triggers should execute successfully in parallel by table Affected Issues
0005023
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

SymmetricDS: 3.12 77b2dbe4

2021-06-11 16:48:37

pmarzullo

Details Diff
0005023: Sync Triggers should execute successfully in parallel by table Affected Issues
0005023
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/Trigger.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/ITriggerRouterService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

SymmetricDS: 3.13 2ac7fe15

2021-06-11 16:48:37

pmarzullo

Details Diff
0005023: Sync Triggers should execute successfully in parallel by table Affected Issues
0005023
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/Trigger.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/ITriggerRouterService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

Issue History

Date Modified Username Field Change
2021-06-10 17:41 pmarzullo New Issue
2021-06-10 17:41 pmarzullo Status new => assigned
2021-06-10 17:41 pmarzullo Assigned To => pmarzullo
2021-06-10 17:43 pmarzullo Note Added: 0001950
2021-06-10 18:00 pmarzullo Changeset attached => SymmetricDS 3.12 184eebc0
2021-06-10 18:00 pmarzullo Changeset attached => SymmetricDS 3.13 b47d1ca1
2021-06-10 18:00 pmarzullo Status assigned => resolved
2021-06-10 18:00 pmarzullo Resolution open => fixed
2021-06-10 18:00 pmarzullo Fixed in Version => 3.12.11
2021-06-11 17:00 pmarzullo Changeset attached => SymmetricDS 3.12 77b2dbe4
2021-06-11 18:00 pmarzullo Changeset attached => SymmetricDS 3.13 2ac7fe15