View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003653 | SymmetricDS Pro | Bug | public | 2018-07-31 19:24 | 2018-08-03 14:13 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.10 | ||||
| Target Version | 3.9.10 | Fixed in Version | 3.9.10 | ||
| Summary | 0003653: Oracle RAC using sequence noorder can expire last gaps | ||||
| Description | When the no-order sequence parameter is enabled for Oracle RAC, and one of the RAC nodes has cached sequences but is not being used, it is possible for a gap to be expired that would eventually contain data. For example RAC node 1 has sequence cache of 1000 through 1999 and RAC node 2 has sequence cache of 2000 through 2999. If node2 continues to make changes the last gap in sym_data_gap will continue to be updated as 3000, then 3001, etc. But if node 1 does not record any changes, the gap from 1000 to 1999 will look old and be expired. This change will "peek" at what the current caches are across the RAC cluster so routing knows all of the last gaps that should not be expired. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.9 15b88a45 2018-07-31 15:25:23 Details Diff |
0003653: Oracle RAC using sequence noorder can expire last gaps |
Affected Issues 0003653 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java | Diff File | ||
| add - symmetric-core/src/main/java/org/jumpmind/symmetric/job/OracleNoOrderHeartbeat.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/DataGap.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/DataGapFastDetector.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/RouterServiceSqlMap.java | Diff File | ||
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-07-31 19:24 | elong | New Issue | |
| 2018-07-31 19:24 | elong | Status | new => assigned |
| 2018-07-31 19:24 | elong | Assigned To | => elong |
| 2018-07-31 19:24 | elong | Relationship added | related to 0003652 |
| 2018-07-31 19:25 | elong | Status | assigned => resolved |
| 2018-07-31 19:25 | elong | Resolution | open => fixed |
| 2018-07-31 19:25 | elong | Fixed in Version | => 3.9.10 |
| 2018-07-31 20:00 | admin | Changeset attached | => SymmetricDS 3.9 15b88a45 |
| 2018-08-03 14:13 | chenson | Status | resolved => closed |