15.00 - 3127 Transaction aborted due to lock conflict with Queue Table Manager. - 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)

3127 Transaction aborted due to lock conflict with Queue Table Manager.

Explanation:

When the Queue Table manager requires to refresh its cache, it will submit a row collection process which needs a read lock on the table. If the lock cannot be obtained for a long while, the Queue Table manager will abort all SELECT AND CONSUME statements that are in the wait state for that table. The intention is to allow the collection to proceed by blowing away the transaction(s) which is/are potentially holding up the collection process.

Generated By:

Dispatcher.

For Whom:

End Users.

Remedy:

Resubmit the aborted transaction as needed.