View Issue Details

IDProjectCategoryView StatusLast Update
0006331SymmetricDSImprovementpublic2024-04-19 15:46
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.13 
Target Version3.14.14Fixed in Version3.14.14 
Summary0006331: Allow specification of initial load select for initial load of filesync channel
DescriptionWhen executing an initial load of files, all files are sent to every node instead of allowing an initial load select to be run against the sym_file_snapshot table.
Allow the specification of an initial load select that will be applied to the sym_file_snapshot table.

1. Create an actual trigger definition for the sym_file_snapshot instead of relying on a virtual trigger definition.
        Trigger ID: sym_file_snapshot
    Table name: sym_file_snapshot
    Channel ID: dynamic (user interface does not allow it, you will have to modify after creating it)
    Reload Channel ID: filesync_reload (user interface does not allow it, you will have to modify after creating it)
    Channel Expression: $(curTriggerValue).$(curColumnPrefix)channel_id
2. Define a filesync router
        Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup>
    Router Type: filesync (user interface does not allow it, you will have to modify after creating it)
3. Define a sym_trigger_router for the filesync trigger and router
        Trigger ID: sym_file_snapshot
        Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup>
    Initial Load Select: some where clause using the relative_dir for filtering
Tagsfile sync, initial/partial load

Relationships

related to 0006332 closedpmarzullo Allow specification of initial load select for initial load of filesync channel 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 da310247

2024-04-05 17:39:58

pmarzullo

Details Diff
0006331: Allow specification of initial load select for initial load of
filesync channel
Affected Issues
0006331
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

SymmetricDS: 3.15 70d69039

2024-04-05 17:39:58

pmarzullo

Details Diff
0006331: Allow specification of initial load select for initial load of
filesync channel
Affected Issues
0006331
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

Issue History

Date Modified Username Field Change
2024-04-05 17:31 pmarzullo New Issue
2024-04-05 17:31 pmarzullo Status new => assigned
2024-04-05 17:31 pmarzullo Assigned To => pmarzullo
2024-04-05 17:31 pmarzullo Tag Attached: file sync
2024-04-05 17:31 pmarzullo Tag Attached: initial/partial load
2024-04-05 17:32 pmarzullo Relationship added related to 0006332
2024-04-05 17:40 pmarzullo Status assigned => resolved
2024-04-05 17:40 pmarzullo Resolution open => fixed
2024-04-05 17:40 pmarzullo Fixed in Version => 3.14.14
2024-04-08 12:27 pmarzullo Description Updated View Revisions
2024-04-19 15:46 pmarzullo Changeset attached => SymmetricDS 3.14 da310247
2024-04-19 15:46 pmarzullo Changeset attached => SymmetricDS 3.15 70d69039
2024-04-23 16:58 admin Status resolved => closed