[
https://issues.apache.org/jira/browse/TRAFODION-2350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
zhangliang updated TRAFODION-2350:
----------------------------------
Summary: odbc connection failure while copy data from oracle to trafodion
by odb (was: odbc connect falure while copy data from oracle to trafodion by
odb)
> odbc connection failure while copy data from oracle to trafodion by odb
> -----------------------------------------------------------------------
>
> Key: TRAFODION-2350
> URL: https://issues.apache.org/jira/browse/TRAFODION-2350
> Project: Apache Trafodion
> Issue Type: Bug
> Components: db-utility-odb
> Reporter: zhangliang
> Assignee: zhangliang
> Priority: Minor
>
> [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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
