Teradata Database Message 3127 - 17.10 - 3127 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
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.
Notes
None
Remedy
Resubmit the aborted transaction as needed.