0 - 8 of 8 tags for deadlock

We are using Informatica PDO to load TD tables and while running multiple sessions concurrently, we encountered an issue wherein the processes were failing due to a deadlock on dbc.userrights table.

The application team experienced a deadlock issue.
There were three different jobs running:  Job A was blocked by Job B.  Job B was blocked by Job A.  Job C was blocked by both Job A and Job B.

 

CREATE SET TABLE ETL_LOG ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      ETL_Rec_Id BIGINT GENERATED ALWAYS AS IDENTITY

           (START WITH 1 

            INCREMENT BY 1 

Hello,

I have gone through JDBC documentation, but I have not found a property or any other way, how to tell jdbc to retry a query that was aborted due to a deadlock.

We are running a lot of concurrent jobs and we get sometimes a deadlock - not because of actual deadlock, but because of lock table being full on an AMP.

I am trying to understand why BTEQ .PACK command creates dead lock on tables with NUPI.

I had a scenario where I needed to load nearly 2 million rows on mutiset table with NUPI. I had lot of duplicates on NUPI columns.

When sessions set to 4, PACK set to 2000, my bteq script's run time output displayed the following:

*** Growing Buffer to 399
*** Failure 2631 Transaction ABORTed due to deadlock.
Statement# 1, Info =0

*** Warning: Attempting to resubmit last request.
*** Failure 2631 Transaction ABORTed due to deadlock.

I have been looking for answers to a basic question on table partitioning in Teradata. Can someone please shed more light. Here it is -

I have 2 BTEQs having following type of Statements. Both are submitted at the same time and both are trying to insert in the same table.

BTEQ1
---------------------------------
BT;
INSERT INTO T1 SEL * FROM GTT;
.IF ERRORCODE <> 0 THEN .GOTO LABELS
ET;
.IF ERRORCODE <> 0 THEN .GOTO LABELS
.QUIT
.LABEL LABELS
.QUIT ERRORCODE

BTEQ2
---------------------------------
BT;
INSERT INTO T1 SEL * FROM GTT;
.IF ERRORCODE <> 0 THEN .GOTO LABELS
ET;
.IF ERRORCODE <> 0 THEN .GOTO LABELS
.QUIT
.LABEL LABELS
.QUIT ERRORCODE

-----------------------------