View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005793 | SymmetricDS Pro | Bug | public | 2023-04-17 15:32 | 2023-04-17 15:49 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.23 | Fixed in Version | 3.12.23 | ||
| Summary | 0005793: SQL Server log miner skips over changes on a busy system | ||||
| Description | When changes are being made while the log miner job is running, the SQL Server log miner can skip over changes. This occurs because the SQL Server log miner relies on snapshot isolation, but snapshot isolation does not work correctly. The log miner calls CHANGE_TRACKING_CURRENT_VERSION() to get the latest version number but CHANGETABLE() unexpectedly returns rows with a version number greater than this number. The log miner quits reading from the cursor when it comes across a row with a version number that is too high. This behavior contradicts Microsoft's documentation, which states that when snapshot isolation is enabled, "the calls to CHANGETABLE(CHANGES ...) will never return changes with a version later than that returned by CHANGE_TRACKING_CURRENT_VERSION()". https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/work-with-change-tracking-sql-server#use-snapshot-isolation As a workaround, we must implement the second alternative from Microsoft's documentation, which will capture duplicate changes but will not miss anything. https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/work-with-change-tracking-sql-server#alternatives-to-snapshot-isolation | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-04-17 15:32 | emiller | New Issue | |
| 2023-04-17 15:32 | emiller | Status | new => assigned |
| 2023-04-17 15:32 | emiller | Assigned To | => emiller |
| 2023-04-17 15:33 | emiller | Issue cloned: 0005794 | |
| 2023-04-17 15:33 | emiller | Relationship added | related to 0005794 |
| 2023-04-17 15:34 | emiller | Relationship added | related to 0005795 |
| 2023-04-17 15:49 | emiller | Status | assigned => resolved |
| 2023-04-17 15:49 | emiller | Resolution | open => fixed |
| 2023-04-17 15:49 | emiller | Fixed in Version | => 3.12.23 |
| 2023-05-12 19:43 | admin | Status | resolved => closed |