0005023: Sync Triggers should execute successfully in parallel by table - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0005023	SymmetricDS	Improvement	public	2021-06-10 17:41	2021-07-13 19:39

Reporter	pmarzullo	Assigned To	pmarzullo
Priority	normal
Status	closed	Resolution	fixed
Product Version	3.12.10
Target Version	3.12.11	Fixed in Version	3.12.11

Summary	0005023: Sync Triggers should execute successfully in parallel by table
Description	Sync 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.
Tags	No tags attached.

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

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
2021-07-13 17:53	admin	Status	resolved => closed
2021-07-13 19:39	elong	Relationship added	related to 0004994

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.