All Forums General
achikan01 13 posts Joined 06/12
09 Oct 2014
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:
Raja_KT 1246 posts Joined 07/09
09 Oct 2014

Usually deadlock occurs due to retry like in bteq.
You could have placed your post under  TOOLS  and you can get better response :)

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

achikan01 13 posts Joined 06/12
10 Oct 2014

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

You must sign in to leave a comment.