[TRAFODION-2350] odbc connection failure while copy data from oracle to trafodion by odb

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: db-utility-odb
• Assignee: zhangliang
• Reporter: zhangliang
• Created: 10/Nov/16 07:59
• Updated: 10/Nov/16 08:01

Description

[root@gy08 odb_test]# ./odb64luo -u zale:trafodion -p zale:traf123 -d orac:gy_poc -cp src=BIG_TABLE:tgt=TRAFODION.ODB_COPY.COPY_p10:rows=5000:max=500000:truncate:parallel=10 -T 256 -v
Connected to Oracle
odb [main(1457)] - Warning: won't be created more thread (256) then needed (30).
odb [2016-11-10 13:15:09]: starting ODBC connection(s)... 0 >1 >2 3 >4 >5 6 >7 >8 9 >10 >11 12 >13 >14 15 >16 >17 18 >19 >20 21 >22 >23 24 >25 >26 27 >28 >29
Connected to Trafodion
odb: Now truncating target table (DELETE FROM TRAFODION.ODB_COPY.COPY_p10)
[1.0.0]--- 0 row(s) deleted in 11.604s (prep 4.868s, exec 6.736s, fetch 0.000s/0.000s)
[0] odb [Ocopy(10210)] - SOURCE statement: SELECT * FROM BIG_TABLE WHERE MOD(ORA_HASH(ROWID), 10) = 0
[12] odb [Ocopy(10210)] - SOURCE statement: SELECT * FROM BIG_TABLE WHERE MOD(ORA_HASH(ROWID), 10) = 4
[6] odb [Ocopy(10210)] - SOURCE statement: SELECT * FROM BIG_TABLE WHERE MOD(ORA_HASH(ROWID), 10) = 2
[9] odb [Ocopy(10210)] - SOURCE statement: SELECT * FROM BIG_TABLE WHERE MOD(ORA_HASH(ROWID), 10) = 3
[3] odb [Ocopy(10210)] - SOURCE statement: SELECT * FROM BIG_TABLE WHERE MOD(ORA_HASH(ROWID), 10) = 1
[6] odb [Ocopy(10552)] - TARGET statement: INSERT INTO TRAFODION.ODB_COPY.COPY_p10 VALUES (?,?)
[27] odb [Ocopy(10210)] - SOURCE statement: SELECT * FROM BIG_TABLE WHERE MOD(ORA_HASH(ROWID), 10) = 9
[21] odb [Ocopy(10210)] - SOURCE statement: SELECT * FROM BIG_TABLE WHERE MOD(ORA_HASH(ROWID), 10) = 7
[24] odb [Ocopy(10210)] - SOURCE statement: SELECT * FROM BIG_TABLE WHERE MOD(ORA_HASH(ROWID), 10) = 8
[18] odb [Ocopy(10210)] - SOURCE statement: SELECT * FROM BIG_TABLE WHERE MOD(ORA_HASH(ROWID), 10) = 6
[15] odb [Ocopy(10210)] - SOURCE statement: SELECT * FROM BIG_TABLE WHERE MOD(ORA_HASH(ROWID), 10) = 5
[7] 5,000 records copied [commit]
[18] odb [Ocopy(10552)] - TARGET statement: INSERT INTO TRAFODION.ODB_COPY.COPY_p10 VALUES (?,?)
[8] 5,000 records copied [commit]
[12] odb [Ocopy(10552)] - TARGET statement: INSERT INTO TRAFODION.ODB_COPY.COPY_p10 VALUES (?,?)
[27] odb [Ocopy(10552)] - TARGET statement: INSERT INTO TRAFODION.ODB_COPY.COPY_p10 VALUES (?,?)
[7] 10,000 records copied [commit]
[19] 5,000 records copied [commit]
[20] 5,000 records copied [commit]
[7] 15,000 records copied [commit]
[28] 5,000 records copied [commit]
[8] 10,000 records copied [commit]
[15] odb [Ocopy(10552)] - TARGET statement: INSERT INTO TRAFODION.ODB_COPY.COPY_p10 VALUES (?,?)
[7] 20,000 records copied [commit]
[3] odb [Ocopy(10552)] - TARGET statement: INSERT INTO TRAFODION.ODB_COPY.COPY_p10 VALUES (?,?)
[13] 5,000 records copied [commit]
[24] odb [Ocopy(10552)] - TARGET statement: INSERT INTO TRAFODION.ODB_COPY.COPY_p10 VALUES (?,?)
[20] 10,000 records copied [commit]
[8] 15,000 records copied [commit]
[14] 5,000 records copied [commit]
[19] 10,000 records copied [commit]
[28] 10,000 records copied [commit]
[20] 15,000 records copied [commit]
[7] 25,000 records copied [commit]
[16] 5,000 records copied [commit]
[13] 10,000 records copied [commit]
[21] odb [Ocopy(10552)] - TARGET statement: INSERT INTO TRAFODION.ODB_COPY.COPY_p10 VALUES (?,?)
[19] 15,000 records copied [commit]
[8] 20,000 records copied [commit]
[9] odb [Ocopy(10552)] - TARGET statement: INSERT INTO TRAFODION.ODB_COPY.COPY_p10 VALUES (?,?)
[4] 5,000 records copied [commit]
[14] 10,000 records copied [commit]
[25] 5,000 records copied [commit]
[29] 5,000 records copied [commit]
[20] 20,000 records copied [commit]
[7] 30,000 records copied [commit]
odb: thread 8 closing connection...
[16] 10,000 records copied [commit]
[5] 5,000 records copied [commit]
[13] 15,000 records copied [commit]
[28] 15,000 records copied [commit]
[26] 5,000 records copied [commit]
[22] 5,000 records copied [commit]
[19] 20,000 records copied [commit]
odb: thread 7 closing connection...
odb: thread 8 is ending...
[17] 5,000 records copied [commit]
[4] 10,000 records copied [commit]
[14] 15,000 records copied [commit]
[29] 10,000 records copied [commit]
[25] 10,000 records copied [commit]
[23] 5,000 records copied [commit]
[19] 25,000 records copied [commit]
[16] 15,000 records copied [commit]
[5] 10,000 records copied [commit]
[13] 20,000 records copied [commit]
[28] 20,000 records copied [commit]
[26] 10,000 records copied [commit]
[22] 10,000 records copied [commit]
odb: thread 7 is ending...
[20] 25,000 records copied [commit]
odb: thread 19 closing connection...
odb: thread 20 closing connection...
odb: thread 6 closing connection...
[17] 10,000 records copied [commit]
[4] 15,000 records copied [commit]
[14] 20,000 records copied [commit]
[29] 15,000 records copied [commit]
[25] 15,000 records copied [commit]
[23] 10,000 records copied [commit]
odb: thread 19 is ending...
odb: thread 18 closing connection...
odb: thread 6 is ending...

[10] 5,000 records copied [commit]
[16] 20,000 records copied [commit]
[5] 15,000 records copied [commit]
[13] 25,000 records copied [commit]
[28] 25,000 records copied [commit]
[26] 15,000 records copied [commit]
[22] 15,000 records copied [commit]
odb: thread 20 is ending...
odb: thread 18 is ending...
[16] 25,000 records copied [commit]
[4] 20,000 records copied [commit]
[14] 25,000 records copied [commit]
odb: thread 13 closing connection...
odb: thread 14 closing connection...
odb: thread 13 is ending...
[25] 20,000 records copied [commit]
[23] 15,000 records copied [commit]
[11] 5,000 records copied [commit]
[10] 10,000 records copied [commit]
[17] 15,000 records copied [commit]
[4] 25,000 records copied [commit]
[29] 20,000 records copied [commit]
odb: thread 14 is ending...
[25] 25,000 records copied [commit]
[22] 20,000 records copied [commit]
[10] 15,000 records copied [commit]
[11] 10,000 records copied [commit]
[4] 30,000 records copied [commit]
[0] odb [Ocopy(10552)] - TARGET statement: INSERT INTO TRAFODION.ODB_COPY.COPY_p10 VALUES (?,?)
odb: thread 12 closing connection...
[26] 20,000 records copied [commit]
[16] 30,000 records copied [commit]
odb: thread 16 closing connection...
odb: thread 16 is ending...
[5] 20,000 records copied [commit]
odb: thread 4 closing connection...
odb: thread 4 is ending...
[28] 30,000 records copied [commit]
[1] odb(10557) [2016-11-10 13:26:56] - [Trafodion ODBC Driver] COMMUNICATION LINK FAILURE. THE SERVER TIMED OUT OR DISAPPEARED. Platform: UNIX, Transport: TCPIP, Api: SQLPREPARE, Error type: DRIVER, Process: TCP:10.10.11.7/23405:ODBC, Operation: DO_WRITE_READ, function: RECV, error: 104, error_detail: 0, error text:recv() returned zero bytes. (State: 08S01 Native Err: 98)
odb: thread 12 is ending...
[22] 25,000 records copied [commit]
[17] 20,000 records copied [commit]
odb: thread 17 closing connection...
odb: thread 17 is ending...
odb: thread 29 closing connection...
odb: thread 5 closing connection...
odb: thread 29 is ending...
odb: thread 26 closing connection...
[23] 20,000 records copied [commit]
odb: thread 23 closing connection...
odb: thread 23 is ending...
[10] 20,000 records copied [commit]
odb: thread 5 is ending...
[25] 30,000 records copied [commit]
odb: thread 26 is ending...
odb: thread 15 closing connection...
odb: thread 0 closing connection...
odb: thread 15 is ending...
odb: thread 3 closing connection...
odb: thread 28 closing connection...
odb: thread 25 closing connection...
odb: thread 27 closing connection...
[10] 25,000 records copied [commit]
odb: thread 0 is ending...
odb: thread 28 is ending...
odb: thread 25 is ending...
odb: thread 1 closing connection...
odb: thread 27 is ending...
[10] 30,000 records copied [commit]
odb: thread 3 is ending...
odb: thread 24 closing connection...
odb: thread 2 closing connection...
[22] 30,000 records copied [commit]
odb: thread 24 is ending...
[10] 35,000 records copied [commit]
odb: thread 1 is ending...
odb: thread 22 closing connection...
odb: thread 2 is ending...
odb: thread 10 closing connection...
odb: thread 21 closing connection...
[11] 15,000 records copied [commit]
odb: thread 10 is ending...
odb: thread 21 is ending...
odb: thread 22 is ending...
odb: thread 11 closing connection...
odb: thread 9 closing connection...
odb: thread 11 is ending...
odb: thread 9 is ending...
odb [2016-11-10 13:28:48]: exiting. Session Elapsed time 818.825 seconds (00:13:38.825)

I will copy 500 million rows from oracle to trafodion, but odbc connection failure occurs, and only 450 million rows are copied.

SQL>select count from copy_p10;

(EXPR)
--------------------
450000

— 1 row(s) selected.