Teradata Database Message 3679 - 3679 - Analytics Database - Teradata Vantage
Analytics Database Messages
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 15.xx,16.xx,17.xx
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2023-01-05
- dita:mapPath
- sfx1628096178347.ditamap
- dita:ditavalPath
- ft:empty
- dita:id
- B035-1096
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- Message
- Transaction ABORTed due to resource shortage.
- Explanation
- A transaction was aborted which required dictionary information that it was unable to receive due to being blocked by other locks. All available AMP tasks were busy or were also waiting for locks. Accepting this request would have created a possibility of an unbreakable resource deadlock. The limit of retries for this condition was exhausted and the transaction was aborted. The application program was informed with a 2631 error that it's transaction was aborted and that it must resubmit the request. This entry and it's associated information has been placed into the ErrorLog to aid in understanding the ErrAMPLokDeadLock (2631) which was reported to the application. The probable cause of this condition is a long running DDL operation being performed while many other requests are also being presented to the database.
- Generated By
- MgcExpRq
- For Whom
- Database Administrator.
- Notes
- None
- Remedy
- No action is required for this error. If this condition is recurrent, review the use of DDL during the time the events occur. If adjustments to the use of DDL during these periods cannot resolve the problem, notify your support representative.