View Issue Details

IDProjectCategoryView StatusLast Update
0003645SymmetricDSBugpublic2018-07-25 15:00
ReporterelongAssigned Toelong 
Priorityhigh 
Status closedResolutionfixed 
Product Version3.8.37 
Target Version3.8.38Fixed in Version3.8.38 
Summary0003645: 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 0003646 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.8 c7648426

2018-07-25 14:04:06

admin

Details Diff
0003645: Auto resolve foreign key can fail on Oracle RAC in noorder mode
0003645
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 11:21 elong New Issue
2018-07-25 11:21 elong Status new => assigned
2018-07-25 11:21 elong Assigned To => elong
2018-07-25 14:06 elong Relationship added related to 0003646
2018-07-25 14:06 elong Status assigned => resolved
2018-07-25 14:06 elong Resolution open => fixed
2018-07-25 14:06 elong Fixed in Version => 3.8.38
2018-07-25 14:15 elong Status resolved => closed
2018-07-25 15:00 admin Changeset attached => SymmetricDS 3.8 c7648426