Deadlock Retry | Teradata Data Mover - 17.11 - Deadlock Retry - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)
When Data Mover runs SQL on source and target systems, the SQL execution may fail if there is a deadlock on an object. This situation may cause the following Teradata Database error:
[Error 2631] [SQLState 40001] Transaction ABORTed due to Deadlock.
The 2631 error is a retryable error that may not occur if the SQL is started after an interval. There are three configuration properties in configuration.xml that you can configure to retry running the query:
Property Description
deadlock.retry.enabled If a SQL query execution fails with Teradata Database error 2631 due to a deadlock, retries running the query after a specified time interval.

Default is false. Specify true to enable.

The two properties listed below are disregarded if deadlock.retry.enabled property is set to false.

deadlock.retry.interval An interval to retry running a SQL query that fails due to Teradata Database deadlock error 2631. Data Mover waits this interval before trying to run a failed query.
Specify values for each of the two elements. The default is 1 minute.
  • value: specify the number of seconds or minutes for the retry interval. Must be a positive integer.
  • unit: specify SECONDS or MINUTES
deadlock.retry.maxAttempts The maximum number of attempts to retry running a SQL query that fails with Teradata Database deadlock error 2631.

If the SQL query fails after being retried for the number of times specified by this property, an error is returned to the user.

The default is 10. Must be a positive integer.

The deadlock retry properties do not apply to queries run by the JDBC, Teradata PT API, or DSA operators during the extract and load process. The properties only apply to SQL run by Data Mover during job creation time or before or after data load time.