0005018: MS log miner needs snapshot isolation to work under heavy load - SymmetricDS

Summary	0005018: MS log miner needs snapshot isolation to work under heavy load

Revision	2021-06-08 16:54 by elong
Description	The Log Miner for Microsoft SQL-Server database needs to use snapshot isolation to avoid concurrency issues that result in missing changes. The changetable may not reflect all changes for the current change number returned by change_tracking_current_version() with other isolation levels.

Revision	2021-06-08 16:56 by elong
Description	The Log Miner for Microsoft SQL-Server database needs to use snapshot isolation to avoid concurrency issues that result in missing changes. The changetable may not reflect all changes for the current change number returned by change_tracking_current_version() with other isolation levels. Setting needed in engine file: target.db.jdbc.isolation.level=4096 SQL needed to run on database: ALTER DATABASE AdventureWorksLT SET ALLOW_SNAPSHOT_ISOLATION ON;