View Issue Details

IDProjectCategoryView StatusLast Update
0006019SymmetricDS ProBugpublic2024-05-28 12:20
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.14.10Fixed in Version3.14.10 
Summary0006019: Oracle log miner stuck on resetting SCN number ORA-01281
DescriptionOracle log miner can get stuck on ORA-01281 message about an invalid SCN number if the range uses an ending SCN number that is not yet recorded. It currently handles the case where the starting SCN is before the first possible SCN. It doesn't handle the case where the ending SCN is after the last possible SCN. It gets stuck in a loop because it asks for the current SCN based on the current time, which isn't recorded yet.

WARN Resetting SCN number from 1234
Tagsdialect: oracle, log miner

Relationships

related to 0006020 closedelong Oracle log miner stuck on resetting SCN number ORA-01281 
related to 0006450 closedelong Oracle log miner stuck on resetting SCN number ORA-01281 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2023-10-12 15:09 elong New Issue
2023-10-12 15:09 elong Status new => assigned
2023-10-12 15:09 elong Assigned To => elong
2023-10-12 15:09 elong Tag Attached: log miner
2023-10-12 15:10 elong Tag Attached: dialect: oracle
2023-10-12 15:12 elong Status assigned => resolved
2023-10-12 15:12 elong Resolution open => fixed
2023-10-12 15:12 elong Fixed in Version => 3.14.10
2023-10-12 15:17 elong Issue cloned: 0006020
2023-10-12 15:17 elong Relationship added related to 0006020
2023-10-27 20:06 admin Status resolved => closed
2024-05-28 12:20 elong Issue cloned: 0006450
2024-05-28 12:20 elong Relationship added related to 0006450