When trying to insreat into log table getting deadlock on TPT script

General
Enthusiast

When trying to insreat into log table getting deadlock on TPT script

  I am getting deadlock issue, when trying to insert into log table ( TABLE_LOG_TABLE_1).

I am not sure what is wrong? Can you please let me know you need more information

  ===================================================================

     =                                                                 =

     =                 Target/Error Table Information                  =

     =                                                                 =

     ===================================================================

LOAD_OPERATOR: preparing target table

DOBEGINLOAD: entering

PC_DOREQUEST: entering

ISSUEBEGINLOAD: entering

**** 13:10:58 This job will use the following tables:

              Target Table:  'TEST_PRELOAD_T.TABLE_1'

              Error Table 1: 'TEST_WORK_T.ER1_TABLE_1'

              Error Table 2: 'TEST_WORK_T.ER2_TABLE_1'

PC_PROCESSREQ: entering

PC_INITIATEREQ: entering with request: 'BEGIN LOADING TEST_PRELOAD_T.TABLE_1 ERRORFILES TEST_WORK_T.ER1_TABLE_1, TEST_WORK_T.ER2_TABLE_1 WITH INTERVAL;'

PC_INITIATEREQ: request length: 177

PC_INITIATEREQ: Using length: 0

PC_INITIATEREQ: leaving with return code: 0

PC_FETCHRESP: entering, expecting flavor: 8

PC_ERRORSET: entering with CLI error code: 0

PC_ERRORSET: parcel received: 8

PC_ERRORSET: Success!, Activity Count: 42

PC_ERRORSET: stmnt #:     1

PC_ERRORSET: field ct:    0

PC_ERRORSET: act type:    40

PC_ERRORSET: warningcode: 0

PC_ERRORSET: warning len: 0

PC_ERRORSET: error code is:     0

PC_ERRORSET: leaving with return code: 0

PC_FETCHRESP: leaving with return code: 0

PC_PROCESSREQ: leaving with result: 0

PC_ISREQUESTDEADLOCKED: entering

PC_ISREQUESTDEADLOCKED: CLI/DBS result 0 is not a deadlock error

PC_ISREQUESTDEADLOCKED: leaving

PC_FETCHRESP: entering, expecting flavor: 10

PC_ERRORSET: entering with CLI error code: 0

PC_ERRORSET: parcel received: 10

PC_ERRORSET: error code is:     0

PC_ERRORSET: leaving with return code: 0

PC_FETCHRESP: leaving with return code: 0

PROCESSAMPINFO: entering

PROCESSAMPINFO: source: 1 (1-BEGIN LOADING,2-LOGTABLE)

PROCESSAMPINFO: AMP map length: 3282

PROCESSAMPINFO: total AMP count: 546

PROCESSAMPINFO: up AMP count: 546

PROCESSAMPINFO: down AMP count: 0

PROCESSAMPINFO: Amp Array length: 3276

PROCESSAMPINFO: leaving with return code: 0

PC_FETCHRESP: entering, expecting flavor: 11

PC_ERRORSET: entering with CLI error code: 0

PC_ERRORSET: parcel received: 11

PC_ERRORSET: error code is:     0

PC_ERRORSET: leaving with return code: 0

PC_FETCHRESP: leaving with return code: 0

PC_FETCHRESP: entering, expecting flavor: 8

PC_ERRORSET: entering with CLI error code: 0

PC_ERRORSET: parcel received: 8

PC_ERRORSET: Success!, Activity Count: 1

PC_ERRORSET: stmnt #:     2

PC_ERRORSET: field ct:    1

PC_ERRORSET: act type:    51

PC_ERRORSET: warningcode: 0

PC_ERRORSET: warning len: 0

PC_ERRORSET: error code is:     0

PC_ERRORSET: leaving with return code: 0

PC_FETCHRESP: leaving with return code: 0

PC_FETCHRESP: entering, expecting flavor: 10

PC_ERRORSET: entering with CLI error code: 0

PC_ERRORSET: parcel received: 10

PC_ERRORSET: error code is:     0

PC_ERRORSET: leaving with return code: 0

PC_FETCHRESP: leaving with return code: 0

PC_FETCHRESP: entering, expecting flavor: 11

PC_ERRORSET: entering with CLI error code: 0

PC_ERRORSET: parcel received: 11

PC_ERRORSET: error code is:     0

PC_ERRORSET: leaving with return code: 0

PC_FETCHRESP: leaving with return code: 0

PC_FETCHRESP: entering, expecting flavor: 12

PC_ERRORSET: entering with CLI error code: 0

PC_ERRORSET: parcel received: 12

PC_ERRORSET: error code is:     0

PC_ERRORSET: leaving with return code: 0

PC_FETCHRESP: leaving with return code: 0

PC_ENDREQUEST: entering

PC_ENDREQUEST: leaving

ISSUEBEGINLOAD: leaving

PC_DOREQUEST: leaving successfully

DOBEGINLOAD: Action:   0

DOBEGINLOAD: DBS flag: 0

DOBEGINLOAD: table is new

DOBEGINLOAD: delete rows except LOGT_INIT row in log table

PC_DOREQUEST: entering

PC_ISSUESQLAUX: entering

PC_ISSUESQLAUX: Issuing SQL statement: 'DELETE FROM TEST_WORK_T.LOG_TABLE_1 WHERE (LOGTYPE <> 50);'

PC_SIMPLEREQ: entering

PC_SIMPLEREQ: request length: 80

PC_SIMPLEREQ: Using length: 0

PC_PROCESSREQ: entering

PC_INITIATEREQ: entering with request: 'DELETE FROM TEST_WORK_T.LOG_TABLE_1 WHERE (LOGTYPE <> 50);'

PC_INITIATEREQ: request length: 80

PC_INITIATEREQ: Using length: 0

PC_INITIATEREQ: leaving with return code: 0

PC_FETCHRESP: entering, expecting flavor: 8

PC_ERRORSET: entering with CLI error code: 0

PC_ERRORSET: parcel received: 8

PC_ERRORSET: Success!, Activity Count: 0

PC_ERRORSET: stmnt #:     1

PC_ERRORSET: field ct:    0

PC_ERRORSET: act type:    5

PC_ERRORSET: warningcode: 0

PC_ERRORSET: warning len: 0

PC_ERRORSET: error code is:     0

PC_ERRORSET: leaving with return code: 0

PC_FETCHRESP: leaving with return code: 0

PC_PROCESSREQ: leaving with result: 0

PC_FINREQUEST: entering

PC_FETCHRESP: entering, expecting flavor: 11

PC_ERRORSET: entering with CLI error code: 0

PC_ERRORSET: parcel received: 11

PC_ERRORSET: error code is:     0

PC_ERRORSET: leaving with return code: 0

PC_FETCHRESP: leaving with return code: 0

PC_FETCHRESP: entering, expecting flavor: 12

PC_ERRORSET: entering with CLI error code: 0

PC_ERRORSET: parcel received: 12

PC_ERRORSET: error code is:     0

PC_ERRORSET: leaving with return code: 0

PC_FETCHRESP: leaving with return code: 0

PC_ENDREQUEST: entering

PC_ENDREQUEST: leaving

PC_FINREQUEST: leaving with result: 0

PC_SIMPLEREQ: leaving with result: 0

PC_ISREQUESTDEADLOCKED: entering

PC_ISREQUESTDEADLOCKED: CLI/DBS result 0 is not a deadlock error

PC_ISREQUESTDEADLOCKED: leaving

PC_ISSUESQLAUX: leaving with result: 0

PC_DOREQUEST: leaving successfully

DOBEGINLOAD: insert AMP info into log table

PC_DOREQUEST: entering

INSERTAMPINFO: entering

INSERTAMPINFO: request: 'USING TAMP(SMALLINT),UAMP(SMALLINT),DAMP(SMALLINT),AARRAY(VARBYTE(24576)) INSERT INTO TEST_WORK_T.LOG_TABLE_1 (LOGTYPE,OPERSEQ,TAMP,UAMP,DAMP,AARRAY) VALUES (130,10,:TAMP,:UAMP,:DAMP,:AARRAY);'

INSERTAMPINFO: InsLength = 3284

INSERTAMPINFO: Inserting AMPCount: 546

INSERTAMPINFO: Inserting UpAMPs: 546

INSERTAMPINFO: Inserting DnAMPs: 0

INSERTAMPINFO: Inserting varlen for amp array: 3276

INSERTAMPINFO: Inserting phase: 130

INSERTAMPINFO: Inserting sequence: 10

PC_SIMPLEREQ: entering

PC_SIMPLEREQ: request length: 253

PC_SIMPLEREQ: Using length: 3284

PC_PROCESSREQ: entering

PC_INITIATEREQ: entering with request: 'USING TAMP(SMALLINT),UAMP(SMALLINT),DAMP(SMALLINT),AARRAY(VARBYTE(24576)) INSERT INTO TEST_WORK_T.LOG_TABLE_1 (LOGTYPE,OPERSEQ,TAMP,UAMP,DAMP,AARRAY) VALUES (130,10,:TAMP,:UAMP,:DAMP,:AARRAY);'

PC_INITIATEREQ: request length: 253

PC_INITIATEREQ: Using length: 3284

PC_INITIATEREQ: leaving with return code: 0

PC_FETCHRESP: entering, expecting flavor: 8

PC_ERRORSET: entering with CLI error code: 0

PC_ERRORSET: parcel received: 9

PC_ERRORSET: error code is:     2631

PC_ISEXCEPTION: entering with error code: 2631

PC_ISEXCEPTION: checking original exception code

PC_ISEXCEPTION: checking new exception code list

PC_ISEXCEPTION: number of codes in list: 0

PC_ISEXCEPTION: error does not match any exception code

PC_ISEXCEPTION: leaving with FALSE

PC_OUTDBSER: entering

PC_LOGJOBMETADATA: entering

PC_LOGJOBMETADATA: leaving

PC_OUTDBSER: DBS Error set to 2631

PC_OUTDBSER: placing message in global memory: Transaction ABORTed due to Deadlock.

Tags (1)
2 REPLIES
Enthusiast

Re: When trying to insreat into log table getting deadlock on TPT script

Usually deadlock occurs due to retry like in bteq.

You could have placed your post under  TOOLS  and you can get better response :)

Enthusiast

Re: When trying to insreat into log table getting deadlock on TPT script

This is not BTEQ questions, This is TPT question. I will put it in the tools.