pengpeng.yang created TRAFODION-2656:
----------------------------------------
Summary: trafodion odb copy data from mysql table to trafodion
table display Error in log
Key: TRAFODION-2656
URL: https://issues.apache.org/jira/browse/TRAFODION-2656
Project: Apache Trafodion
Issue Type: Bug
Components: db-utility-odb
Affects Versions: any
Reporter: pengpeng.yang
Priority: Minor
When I execute odb copy test from mysql copy data to trafodion, data is copy
success, but it display Error in log.The command is as follow.
$odb64luo -u mysqlusernamet:trafodionusername -p mysqlpasswd:trafodionpasswd -d
mysqldb:trafodiondb -cp
src=BIG_TABLE:tgt=TRAFODION.ODB_COPY.COPY_T1:rows=5000:max=500000:truncate -v
Error log is as follow.
Connected to MySQL
odb [2017-06-19 18:04:39]: starting ODBC connection(s)... 0 >1 >2
Connected to Trafodion
odb: Now truncating target table (PURGEDATA TRAFODION.ODB_COPY.COPY_T1)
[1.0.0]--- command executed in 10.078s (prep 0.750s, exec 9.328s, fetch
0.000s/0.000s)
[0] odb [Ocopy(10214)] - SOURCE statement: SELECT * FROM BIG_TABLE
[0] odb [Ocopy(10556)] - TARGET statement: INSERT INTO
TRAFODION.ODB_COPY.COPY_T1 VALUES (?,?)
[1] 5 records copied [commit]
odb: thread 2 closing connection...
[0] odb version 1.1.0 Copy statistics:
[0] Source: BIG_TABLE
[0] Target: TRAFODION.ODB_COPY.COPY_T1
odb: thread 1 closing connection...
[0] Total number of columns: 2
[0] ODBC row size: 15 B (data) + 16 B (len ind)
[0] Rowset size: 5,000
[0] Rowset buffer size: 151.37 KiB
[0] Pre-copy time: 18.164 s (00:00:18.164)
[0] Copy time: 2.028 s (00:00:02.028)
[0] Total records copied: 5 (0.002 krec/s)
[0] Copy throughput (ODBC): 0.000 MiB/s (0.000 GiB/h)
[0] Total/Wait cycles: 1/0
[0>1] 5 records copied in 2.028 (00:00:02.028 s)
[0>2] 0 records copied in 2.028 (00:00:02.028 s)
odb: thread 2 is ending...
odb: thread 0 closing connection...
odb: thread 1 is ending...
{color:red}Error in my_thread_global_end(): 1 threads didn't exit{color}
odb: thread 0 is ending...
odb [2017-06-19 18:04:59]: exiting. Session Elapsed time 20.251 seconds
(00:00:20.251)
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
