View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003646 | SymmetricDS | Bug | public | 2018-07-25 18:06 | 2018-08-03 14:12 |
Reporter | elong | Assigned To | elong | ||
Priority | high | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.9.0 | ||||
Target Version | 3.9.10 | Fixed in Version | 3.9.10 | ||
Summary | 0003646: Auto resolve foreign key can fail on Oracle RAC in noorder mode | ||||
Description | On Oracle RAC with the oracle.sequence.noorder parameter enabled for performance, the auto resolution of foreign key errors can fail. Resolution works by sending the batch line number in the acknowledgement back to the source, where it queries the capture log to find the same row number. The query needs to order by the capture log create_time, and not the routing create_time. | ||||
Tags | No tags attached. | ||||
SymmetricDS: 3.9 79776dcd 2018-07-25 14:20:25 Details Diff |
0003646: Auto resolve foreign key can fail on Oracle RAC in noorder mode |
Affected Issues 0003646 |
|
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/AcknowledgeServiceSqlMap.java | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2018-07-25 18:06 | elong | New Issue | |
2018-07-25 18:06 | elong | Status | new => assigned |
2018-07-25 18:06 | elong | Assigned To | => elong |
2018-07-25 18:06 | elong | Relationship added | related to 0003645 |
2018-07-25 18:21 | elong | Status | assigned => resolved |
2018-07-25 18:21 | elong | Resolution | open => fixed |
2018-07-25 18:21 | elong | Fixed in Version | => 3.9.10 |
2018-07-25 19:00 | admin | Changeset attached | => SymmetricDS 3.9 79776dcd |
2018-08-03 14:12 | chenson | Status | resolved => closed |