Dead lock issue: 2631; Transaction ABORTed due to Deadlock

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

Dead lock issue: 2631; Transaction ABORTed due to Deadlock

Hi, Every one One of the session got failed with the error "Transaction ABORTed due to Deadlock." The querytext which is got failed with this error is "MERGE INTO DB1.T1 AS T1 USING DB2.T2;" I checked in DBQL logs and found all sessions are commited except SELECT TableName FROM DBC.TablesV WHERE DatabaseName = DB2 AND TableName LIKE 'T1%' AND ........ the Lock information of this query is "ACCESS" What could be the reason for this deadlock issue. Thank you for your help
Tags (1)