View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006657 | SymmetricDS | Bug | public | 2024-11-25 19:26 | 2024-12-04 14:29 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.11 | Fixed in Version | 3.15.11 | ||
| Summary | 0006657: Data reload events with reload where clause should not be routed in common mode | ||||
| Description | When a data reload event is created, it is attempted to route the reload event in common mode without taking into consideration whether or not the where clause specification (provided in the row_data column of the sym_data record). If a where clause is provided, then the routing of the data reload event should not be done in common mode because the where clause could provide a different set of records for each node_id that the data event is routed to. | ||||
| Steps To Reproduce | 1. Configure routing for a table that has a column value that can be assigned to a external_id value. 2. Create a reload data event for all the target nodes, specifying a where clause that would split the set of records up across the nodes: insert into sym_data (table_name, event_type, row_data, trigger_hist_id, channel_id, node_list, create_time) values('t1','R','external_id=''$(externalId)''',(select max(trigger_hist_id) from sym_trigger_hist where source_table_name = 't1'),'reload','88B,88D,90B,90D',current_timestamp); 3. All nodes in the same groups will get the same set of records, even though each node should get a different set of records. | ||||
| Tags | initial/partial load | ||||
|
|
Patch provided here: https://downloads.jumpmind.com/symmetricds/patches/3.15/patch-0006657v2.jar |
|
|
Included in the SymmetricDS release 3.15.11 |
|
SymmetricDS: 3.15 e86a2202 2024-11-25 19:27:30 Details Diff |
0006657: Data reload events with reload where clause should not be routed in common mode |
Affected Issues 0006657 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java | Diff File | ||
|
SymmetricDS: 3.15 5c91bffd 2024-11-26 16:47:20 Details Diff |
0006657: Handle when trigger router has an initial load select specified |
Affected Issues 0006657 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-11-25 19:26 | pmarzullo | New Issue | |
| 2024-11-25 19:26 | pmarzullo | Status | new => assigned |
| 2024-11-25 19:26 | pmarzullo | Assigned To | => pmarzullo |
| 2024-11-25 19:26 | pmarzullo | Tag Attached: initial/partial load | |
| 2024-11-25 20:00 | pmarzullo | Changeset attached | => SymmetricDS 3.15 e86a2202 |
| 2024-11-25 21:13 | pmarzullo | Status | assigned => resolved |
| 2024-11-25 21:13 | pmarzullo | Resolution | open => fixed |
| 2024-11-25 21:13 | pmarzullo | Fixed in Version | => 3.15.11 |
| 2024-11-26 16:50 | pmarzullo | Note Added: 0002532 | |
| 2024-11-26 17:00 | pmarzullo | Changeset attached | => SymmetricDS 3.15 5c91bffd |
| 2024-12-04 14:29 | pbelov | Status | resolved => closed |
| 2024-12-04 14:29 | pbelov | Note Added: 0002539 |