Archives of the TeradataForum

Message Posted: Mon, 30 Aug 2010 @ 08:39:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

[2631: Transaction ABORTed due to Deadlock.] has occured, and it did not retry.

     -----------------------------------------------------------------
     [Select xx from table] was executed when [Delete from dbc.accesslog] was in a session.
     The message 2631 was returned and [Select ...] job was abended.

     When RetryAccLogDeadlock on DBSCONTROL/Internal is set TRUE,
     2631 should be returned, then Teradata is supposed to retry the query.

     However, this time, DBQL did not show any record that it retried.
     This job abended.

     The [Select...] job is connecting to Teradata using SAS Access to Teradata (ANSI mode).
     (Version SAS 9.1 Foundation)
     (Teradata Version V2R.06.02)
     -----------------------------------------------------------------

My question is why it did not retry.

I was wondering if [SAS Access to Teradata] is a cause.

If so, what can I do to avoid this?

If anyone has any idea, please help me!

	<Prev	Next>		<<First	<Prev	Next>	Last>>