Operational Defect Database
BugZero found this defect 763 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 14579161
Assume that you have tables with data on the peers and then you set a peer-to-peer publication by using a last-writer conflict detection policy. The distribution agent occurs the following conflict if you delete a row that was present before the publication was created: A conflict of type 'Delete-Update' was detected at peer 1 between peer 100 (incoming), transaction id <tranid> and peer (null) (on disk), transaction id (null) for Table <TableName> with Primary Key(s): PK values, Current Version '(null)', Pre-Version '(null)' and Post-Version <VersionNumber>
Last update date:
4/18/2022
Affected products:
SQL Server 2019 on Linux
SQL Server 2019 on Windows
Affected releases:
build lower than 15.0.4223.1
Fixed releases:
15.0.4223.1
Description:
Assume that you have tables with data on the peers and then you set a peer-to-peer publication by using a last-writer conflict detection policy. The distribution agent occurs the following conflict if you delete a row that was present before the publication was created: A conflict of type 'Delete-Update' was detected at peer 1 between peer 100 (incoming), transaction id <tranid> and peer (null) (on disk), transaction id (null) for Table <TableName> with Primary Key(s): PK values, Current Version '(null)', Pre-Version '(null)' and Post-Version <VersionNumber>
