Teradata Database Message 2515 - 2515 - Analytics Database - Teradata Vantage

Message

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.