View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006630 | SymmetricDS | Bug | public | 2024-10-30 16:28 | 2024-11-13 20:31 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.9 | ||||
| Target Version | 3.15.10 | Fixed in Version | 3.15.10 | ||
| Summary | 0006630: Initial load with delete first captures the deletes when source and target are log mining nodes | ||||
| Description | When the source and the target are configured as log mining nodes, and the synchronization is bidirectional, and a load with deletes first is sent from source to target, the deletes that are executed at the target are captured and routed back to the source, deleting the records at the source. The Send SQL needs to use the CTE expression functionality so that those deletes are not captured at the target and sent back to the source. | ||||
| Steps To Reproduce | 1. Configure log mining source node. 2. Configure log mining target node. 3. Configure a table with bidirectional synchronization. 4. Load the table from the source to the target with deletes first. 5. Load the table from the source to the target with deletes first again (this will make sure that the deletes actually delete records at the target). 6. Deletes will be captured and routed to source, and the rows will be deleted at the source. | ||||
| Tags | initial/partial load, log miner | ||||
|
SymmetricDS: 3.15 5d2f347e 2024-10-30 16:35:15 Details Diff |
0006630: Initial load with delete first captures the deletes when source and target are log mining nodes |
Affected Issues 0006630 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/DmlStatement.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-10-30 16:28 | pmarzullo | New Issue | |
| 2024-10-30 16:28 | pmarzullo | Status | new => assigned |
| 2024-10-30 16:28 | pmarzullo | Assigned To | => pmarzullo |
| 2024-10-30 16:28 | pmarzullo | Tag Attached: initial/partial load | |
| 2024-10-30 16:28 | pmarzullo | Tag Attached: log miner | |
| 2024-10-30 16:35 | pmarzullo | Status | assigned => resolved |
| 2024-10-30 16:35 | pmarzullo | Resolution | open => fixed |
| 2024-10-30 16:35 | pmarzullo | Fixed in Version | => 3.15.10 |
| 2024-10-30 16:36 | pmarzullo | Steps to Reproduce Updated | View Revisions |
| 2024-10-30 16:36 | pmarzullo | Steps to Reproduce Updated | View Revisions |
| 2024-10-30 17:00 | pmarzullo | Changeset attached | => SymmetricDS 3.15 5d2f347e |
| 2024-11-13 20:31 | pbelov | Status | resolved => closed |