Blog Post

SQL Server Blog
2 MIN READ

Temporal: Encountering Error 13535 Data modification failed on system-versioned table...

BobDorr's avatar
BobDorr
Icon for Microsoft rankMicrosoft
Jun 13, 2022
When 2 or more workers are modifying the same row, it is possible to encounter 13535.  The time of the begin transaction and the modification are the defining properties.  When the transaction begin ...
Updated Jun 13, 2022
Version 1.0
bobsql
AbairM's avatar
AbairM
Copper Contributor
Jun 15, 2022

Thanks again for sharing the knowledge.  I keep forgetting how handy OStress can be for testing / reproducing race conditions.  After reading a couple of the issues you've been troubleshooting I know now to keep that handy in the toolbox. 

 

Gone are the days of me opening 2 multiple query windows in SSMS adding a "GO 5000" to the bottom of each query hoping that the issue will repro before SSMS crashes from too many result panes being returned!! :lol:

 

Keep it up!

-Mike