View Issue Details

IDProjectCategoryView StatusLast Update
0003646SymmetricDSBugpublic2018-08-03 10:12
ReporterelongAssigned Toelong 
Priorityhigh 
Status closedResolutionfixed 
Product Version3.9.0 
Target Version3.9.10Fixed in Version3.9.10 
Summary0003646: Auto resolve foreign key can fail on Oracle RAC in noorder mode
DescriptionOn 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.

Relationships

related to 0003645 closedelong Auto resolve foreign key can fail on Oracle RAC in noorder mode 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 79776dcd

2018-07-25 14:20:25

admin

Details Diff
0003646: Auto resolve foreign key can fail on Oracle RAC in noorder mode
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

Issue History

Date Modified Username Field Change
2018-07-25 14:06 elong New Issue
2018-07-25 14:06 elong Status new => assigned
2018-07-25 14:06 elong Assigned To => elong
2018-07-25 14:06 elong Relationship added related to 0003645
2018-07-25 14:21 elong Status assigned => resolved
2018-07-25 14:21 elong Resolution open => fixed
2018-07-25 14:21 elong Fixed in Version => 3.9.10
2018-07-25 15:00 admin Changeset attached => SymmetricDS 3.9 79776dcd
2018-08-03 10:12 chenson Status resolved => closed