[Error 2631] [SQLState 40001] Transaction ABORTed due to Deadlock.
|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.
|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.