15.00 - 2515 The modification at this time instant can violate serializability. Please retry the request. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

2515 The modification at this time instant can violate serializability. Please retry the request.

Explanation:

Reported when multiple temporal DML are concurrently updating the same table that may violate serializability. This can be a transaction level abort.

Generated By:

AMP steps.

For Whom:

User.

Notes:

This abort can result from any of the following situations: 1. Two concurrent CURRENT transactions modify the same row, and for one of the transactions, the row is modified in the time between the beginning of the transaction and the actual modification carried out by the transaction. 2. There are two concurrent transactions. One is CURRENT and the other is SEQUENCED, NONSEQUENCED, or NONTEMPORAL. They modify the same row and one of the following occurs: a) The VT of the row ends before the modification time of either transaction. b) The VT of the row is between the beginning of the transaction and the actual time of modification. These situations should be rare since they depend on very small amounts of time, and can generally be solved by retrying the request which generated the abort.

Remedy:

Retry the request.