View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006263 | SymmetricDS | Bug | public | 2024-02-28 17:31 | 2024-04-19 15:46 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.0 | ||||
| Target Version | 3.14.13 | Fixed in Version | 3.14.13 | ||
| Summary | 0006263: Include source_node_id in the where clause when updating or deleting from sym_table_reload_status | ||||
| Description | Currently, the source_node_id column is often excluded from the where clause when updating or deleting from sym_table_reload_status. This can cause issues when an outgoing load_id happens to overlap with an incoming load_id. For example, before inserting into sym_table_reload_status, DataService first deletes from sym_table_reload_status using only the load_id in the where clause. If any incoming loads share the same load_id as the load_id being inserted, then their sym_table_reload_status rows get deleted. Adding the source_node_id to the where clause would prevent this. | ||||
| Tags | initial/partial load | ||||
|
SymmetricDS: 3.14 188a9385 2024-02-29 19:32:37 evan-miller-jumpmind Details Diff |
0006263: Included source_node_id in the where clause when updating or deleting from sym_table_reload_status |
Affected Issues 0006263 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/extract/SelectFromSymDataSource.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/load/ConfigurationChangedDatabaseWriterFilter.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IDataService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/AcknowledgeService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataServiceSqlMap.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/InitialLoadService.java | Diff File | ||
|
SymmetricDS: 3.14 713a9d30 2024-03-06 12:50:21 evan-miller-jumpmind Details Diff |
0006263: Included source_node_id in the where clause when updating or deleting from sym_table_reload_status |
Affected Issues 0006263 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-02-28 17:31 | emiller | New Issue | |
| 2024-02-28 17:31 | emiller | Status | new => assigned |
| 2024-02-28 17:31 | emiller | Assigned To | => emiller |
| 2024-02-28 17:31 | emiller | Tag Attached: initial/partial load | |
| 2024-02-28 17:32 | emiller | Issue cloned: 0006264 | |
| 2024-02-28 17:32 | emiller | Relationship added | related to 0006264 |
| 2024-02-29 19:34 | emiller | Status | assigned => resolved |
| 2024-02-29 19:34 | emiller | Resolution | open => fixed |
| 2024-02-29 19:34 | emiller | Fixed in Version | => 3.14.13 |
| 2024-03-19 16:20 | admin | Status | resolved => closed |
| 2024-04-19 15:46 | Changeset attached | => SymmetricDS 3.14 713a9d30 | |
| 2024-04-19 15:46 | Changeset attached | => SymmetricDS 3.14 188a9385 |