View Issue Details

IDProjectCategoryView StatusLast Update
0004999SymmetricDS ProBugpublic2021-05-28 20:40
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.9 
Target Version3.12.10Fixed in Version3.12.10 
Summary0004999: Oracle Log Miner needs to handle rollback to savepoints
DescriptionWhen savepoints are set, and the transaction is rolled back to the savepoint, there are events in the log that show what things should be executed to implement the rollback to savepoint. But the where clause is set to the row ID value, not the actual where clause.

So, the TransactionMiner needs to keep track of all DML statements that occur during the open transactions and associate them with the transaction ID so that when a rollback to savepoint is found, then we can use the previous DataObject that represents the row ID current state to get the primary key data, the old data, and the rest of the missing columns for the current row data when building a Data object.

Also, when a commit or rollback for a transaction ID is found, the data structure that holds the open transactions needs to be updated (the open transaction needs to be removed).
Tagsdialect: oracle, log miner

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2021-05-20 19:25 pmarzullo New Issue
2021-05-20 19:25 pmarzullo Status new => assigned
2021-05-20 19:25 pmarzullo Assigned To => pmarzullo
2021-05-20 19:25 pmarzullo Tag Attached: dialect: oracle
2021-05-20 19:25 pmarzullo Tag Attached: log-miner
2021-05-20 19:39 pmarzullo Status assigned => resolved
2021-05-20 19:39 pmarzullo Resolution open => fixed
2021-05-20 19:39 pmarzullo Fixed in Version => 3.12.10
2021-05-28 11:56 admin Project SymmetricDS => SymmetricDS Pro
2021-05-28 20:40 admin Status resolved => closed
2022-08-09 17:57 admin Tag Renamed log-miner => log miner