View Issue Details

IDProjectCategoryView StatusLast Update
0003652SymmetricDSBugpublic2018-07-31 16:00
ReporterelongAssigned Toelong 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.8.39 
Target Version3.8.39Fixed in Version3.8.39 
Summary0003652: Oracle RAC using sequence noorder can expire last gaps
DescriptionWhen 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.

Relationships

related to 0003653 closedelong SymmetricDS Pro Oracle RAC using sequence noorder can expire last gaps 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 96981e8a

2018-07-31 15:24:54

admin

Details Diff
0003652: Oracle RAC using sequence noorder can expire last gaps
0003652
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

Issue History

Date Modified Username Field Change
2018-07-31 15:23 elong New Issue
2018-07-31 15:23 elong Status new => assigned
2018-07-31 15:23 elong Assigned To => elong
2018-07-31 15:24 elong Relationship added related to 0003653
2018-07-31 15:31 elong Status assigned => resolved
2018-07-31 15:31 elong Resolution open => fixed
2018-07-31 15:31 elong Fixed in Version => 3.8.39
2018-07-31 15:41 admin Status resolved => closed
2018-07-31 16:00 admin Changeset attached => SymmetricDS 3.8 96981e8a