Teradata Database Message 9128 - 17.10 - 9128 - 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
The transaction exceeded the maximum number of rowhash locks allowed.
Explanation
This error is returned when a transaction has exceeded the number of rowhash locks allowed. The threshold on the number of rowhash locks allowed is defined in DBSControl via the General field 'MaxRowHashBlocksPercent'. This is done so that one transaction does not fill up the lock table with rowhash locks. The number of control blocks/locks that can fit into an AMP lock table is defined by STDMAXLOCKBLOCKS which is currently ~51860.
Generated By
LOK subsystem.
For Whom
End user.
Notes
None
Remedy
Reduce the number of rowhash locks that the transaction is acquiring. An alternative is increase the General field 'MaxRowHashBlocksPercent' value in DBSControl.