View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004999 | SymmetricDS Pro | Bug | public | 2021-05-20 19:25 | 2021-05-28 20:40 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.9 | ||||
| Target Version | 3.12.10 | Fixed in Version | 3.12.10 | ||
| Summary | 0004999: Oracle Log Miner needs to handle rollback to savepoints | ||||
| Description | When 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). | ||||
| Tags | dialect: oracle, log miner | ||||
| 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 |