View Issue Details

IDProjectCategoryView StatusLast Update
0006959SymmetricDS ProBugpublic2025-06-19 13:20
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.16.2 
Target Version3.16.4Fixed in Version3.16.4 
Summary0006959: SQL-Server log miner goes back to older change version in loop
DescriptionSQL-Server log miner can continue to go back to an older change version to mine changes in a loop. For example, current version is 1, it sees a change waiting at 2, so it mines it and advances to wait for 3, but then logic decreases it back to 1.

[LogMinerService] [SQL_target-job-12] Obtained a start ID 3 from sym_context
[LogMinerService] [SQL_target-job-12] Decreasing the next ID from 3 to 1 because it's greater than the current ID of 1
[LogMinerService] [SQL_target-job-12] Saving position at ID 1 with 0 open XIDs:

The logic appears to have been introduce in issue 0006863.
Tagsdialect: sql-server, log miner

Relationships

related to 0006863 closedemiller Log miner should check current SCN & if it's less than the next SCN in sym_context, reset it to the current SCN & log an error 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2025-06-19 12:58 elong New Issue
2025-06-19 12:58 elong Status new => assigned
2025-06-19 12:58 elong Assigned To => elong
2025-06-19 12:58 elong Tag Attached: dialect: sql-server
2025-06-19 12:58 elong Tag Attached: log miner
2025-06-19 12:59 elong Description Updated View Revisions
2025-06-19 12:59 elong Relationship added related to 0006863
2025-06-19 13:20 elong Status assigned => resolved
2025-06-19 13:20 elong Resolution open => fixed
2025-06-19 13:20 elong Fixed in Version => 3.16.4