PRB: Error 7129 If Concurrent Processes Update Same Text Page

ID: Q66872

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2
Microsoft SQL Server version 4.2x

SYMPTOMS

When executing concurrent processes that are performing text type operations on the same table, one of the processes sometimes aborts with the following error message:

Msg 7129, Level 16, State 2:
Synchronization time stamp does not agree with text data page values.

CAUSE

This is expected behavior if the two processes are trying to update the same text page at the same time. Both processes select for a text pointer, one of the processes locks the text data page first and updates it. When the other process tries to update the text page, the timestamp is different and the second process is not allowed to update the text page. The process is then aborted with the error message listed above.

Additional query words: Transact-SQL Windows NT

Keywords : kbother SSrvServer SSrvWinNT
Version : 4.2 | 4.2
Platform : OS/2 WINDOWS
Issue type :