You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "苏锦佩 (JIRA)" <ji...@apache.org> on 2017/09/18 08:18:01 UTC
[jira] [Resolved] (TRAFODION-2721) When setting max property , copy
data from mysql to trafodion failed
[ https://issues.apache.org/jira/browse/TRAFODION-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
苏锦佩 resolved TRAFODION-2721.
----------------------------
Resolution: Fixed
> When setting max property , copy data from mysql to trafodion failed
> --------------------------------------------------------------------
>
> Key: TRAFODION-2721
> URL: https://issues.apache.org/jira/browse/TRAFODION-2721
> Project: Apache Trafodion
> Issue Type: Bug
> Components: db-utility-odb
> Affects Versions: 2.2-incubating
> Reporter: 苏锦佩
> Fix For: 2.3-incubating
>
>
> When I run odb statement with max property On EsgynDB2.3 and the max value is less than actual copy records, I found that copying data from mysql to trafodion failed.
> This is Error Log. You can reproduce it.
> ----------------------------------------
> Usecase : mysql copy with pwhere and commit=auto:rows=5000:max=3
> Command : odb64luo -u odb:trafodion -p odb:traf123 -d mysql:traf -cp src=odb_copy_customer10:tgt=TRAFODION.ODB_COPY.mysql_copy_customer10:pwhere="ID>5":max=3:commit=auto:rows=5000:loadcmd=UL
> -v
> Result : failed
> During : 2s
> Details :
> Connected to MySQL
> odb [2017-08-02 13:57:19]: starting ODBC connection(s)... 0 >1 >2
> Connected to Trafodion
> [0] odb [Ocopy(10248)] - SOURCE statement: SELECT * FROM ODB_COPY_CUSTOMER10 WHERE ID>5
> [0] odb [Ocopy(10596)] - TARGET statement: UPSERT USING LOAD INTO TRAFODION.ODB_COPY.mysql_copy_customer10 VALUES (?,?)
> [1] 0 records copied [commit]
> odb: thread 2 closing connection...
> odb: thread 1 closing connection...
> [0] odb version 1.1.0 Copy statistics:
> [0] Source: ODB_COPY_CUSTOMER10
> [0] Target: TRAFODION.ODB_COPY.mysql_copy_customer10
> [0] Total number of columns: 2
> [0] ODBC row size: 140 B (data) + 16 B (len ind)
> [0] Rowset size: 3
> [0] Rowset buffer size: 0.46 KiB
> [0] Pre-copy time: 2.108 s (00:00:02.108)
> [0] Copy time: 0.001 s (00:00:00.001)
> [0] Total records copied: 0 (0.000 krec/s)
> [0] Copy throughput (ODBC): 0.000 MiB/s (0.000 GiB/h)
> [0] Total/Wait cycles: 1/0
> [0>1] 0 records copied in 0.001 (00:00:00.001 s)
> [0>2] 0 records copied in 0.001 (00:00:00.001 s)
> odb: thread 0 closing connection...
> Error in my_thread_global_end(): 1 threads didn't exit
> odb: thread 0 is ending...
> odb: thread 1 is ending...
> odb: thread 2 is ending...
> odb [2017-08-02 13:57:22]: exiting. Session Elapsed time 2.122 seconds (00:00:02.122)
> ----------------------------------------
> Create mysql table statement.
> CREATE TABLE `odb_copy_customer10` (
> `id` int(11) DEFAULT NULL,
> `name` varchar(32) DEFAULT NULL
> );
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)