View Issue Details

IDProjectCategoryView StatusLast Update
0005431SymmetricDSImprovementpublic2022-10-04 15:15
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.14.2Fixed in Version3.14.2 
Summary0005431: Install triggers on registration server before configuration is complete
DescriptionFor a registration server, install triggers on the SYM tables as soon as they are created before any configuration is entered. When users register nodes, perform initial loads, and build configuration incrementally, there is a race between those operations and triggers being installed, which can cause errors and let SYM tables get out of sync.

Examples: 1) registering a node with a new node group leaves the registration_enabled flag turned on at the client, 2) starting an initial load before triggers have synced results in errors because sym_trigger_hist is missing.
Tagssync-trigger

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 39ea7c51

2022-08-31 12:04:52

admin

Details Diff
0005431: Install triggers on registration server before configuration is
complete
Affected Issues
0005431
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/Constants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

Issue History

Date Modified Username Field Change
2022-08-31 12:02 elong New Issue
2022-08-31 12:02 elong Status new => assigned
2022-08-31 12:02 elong Assigned To => elong
2022-08-31 12:02 elong Tag Attached: sync-trigger
2022-08-31 12:05 elong Status assigned => resolved
2022-08-31 12:05 elong Resolution open => fixed
2022-08-31 12:05 elong Fixed in Version => 3.14.2
2022-08-31 13:00 admin Changeset attached => SymmetricDS 3.14 39ea7c51
2022-10-04 15:15 admin Status resolved => closed