Teradata Database Message 5942 - 17.10 - 5942 - 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
Maximum deadlock retries limit reached during multi amp sampling on a AMP.
Explanation
Whenever the system encounters a deadlock response from an amp during sampling, it does retries on that AMP to get the data. If the maximum number of retries is reached, it then post this error message in the event log. This could generally happen if the system is too busy.
Generated By
mgc modules.
For Whom
Database Administrator.
Notes
None
Remedy
The system automatically switches to default one AMP sampling. If the above symptom persists, please contact your system support representative with all the details.