[
https://issues.apache.org/jira/browse/TRAFODION-2677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16074609#comment-16074609
]
ASF GitHub Bot commented on TRAFODION-2677:
-------------------------------------------
GitHub user SuJinpei reopened a pull request:
https://github.com/apache/incubator-trafodion/pull/1165
[TRAFODION-2677] odb load source with src=-file is failure
root cause: each thread try to call splitcso to get Catalog/Schema/Table
from the same tgt buffer, but splitcso will modify tgt buffer, so only one
thread can get the correct result.
fix way: 1. Catalog/Schema/Table can be determined when creating etab, so
move it forward.
2. etab[*].tgt is used elsewhere and is assumed not split, so
make a copy of tgt.
3. add globalPointers to save pointers to buffers which may be
shared by many thread and length determined at run time.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/SuJinpei/incubator-trafodion Trafodion-2677
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1165.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1165
----
commit ee497fe94d5e6e7ca24657288fbc62f47a9e4e17
Author: SuJinpei <[email protected]>
Date: 2017-07-05T01:52:44Z
[TRAFODION-2677] odb load source with src=-file is falure
commit ecc76bd45282008d7ea45e4bea4090a6d3616bcd
Author: SuJinpei <[email protected]>
Date: 2017-07-05T10:10:32Z
fix TRAFODION-2677
----
> odb load source with src=-file is failure
> -----------------------------------------
>
> Key: TRAFODION-2677
> URL: https://issues.apache.org/jira/browse/TRAFODION-2677
> Project: Apache Trafodion
> Issue Type: Bug
> Components: db-utility-odb
> Reporter: 苏锦佩
> Fix For: 2.3-incubating
>
>
> I'm using the statement "odb64luo -u trafuser -p trafpasswd -d trafdb -l
> src=-odb_load_file:tgt=trafodion.odb_test.sp_person3:max=10000:rows=5000:parallel=1:loadcmd=UL:fs=\!:sq=\""
> to load some files into a trafodion table，then I see the error display as
> follow.
> ERROR MESSAGES
> Connected to Trafodion
> Connected to Trafodion
> Connected to Trafodion
> [4] odb(13004) [2017-06-08 01:16:30] - [Trafodion ODBC Driver][Trafodion
> Database] SQL ERROR:*** ERROR[8822] The statement was not prepared.
> [2017-06-08 01:16:30] (State: X08MU Native Err: -8822)
> [4] odb(13004) [2017-06-08 01:16:30] - [Trafodion ODBC Driver][Trafodion
> Database] SQL ERROR:*** ERROR[4082] Object TRAFODION.QA.TRAFODION does not
> exist or is inaccessible. [2017-06-08 01:16:30] (State: 42000 Native Err:
> -4082)
> odb [Oload(6388)] - Error analyzing target table (null).(null).TRAFODION
> odb: thread 4 closing connection...
> odb: thread 4 is ending...
> odb: thread 5 closing connection...
> [2] odb(13004) [2017-06-08 01:16:30] - [Trafodion ODBC Driver][Trafodion
> Database] SQL ERROR:*** ERROR[8822] The statement was not prepared.
> [2017-06-08 01:16:30] (State: X08MU Native Err: -8822)
> [2] odb(13004) [2017-06-08 01:16:30] - [Trafodion ODBC Driver][Trafodion
> Database] SQL ERROR:*** ERROR[4082] Object TRAFODION.QA.TRAFODION does not
> exist or is inaccessible. [2017-06-08 01:16:30] (State: 42000 Native Err:
> -4082)
> odb [Oload(6388)] - Error analyzing target table (null).(null).TRAFODION
> odb: thread 2 closing connection...
> odb: thread 2 is ending...
> odb: thread 3 closing connection...
> odb: thread 5 is ending...
> odb: thread 3 is ending...
> odb [Oload(7053)] - INSERT
> statement:PID","FNAME","LNAME","COUNTRY","CITY","BDATE","SEX","EMAIL","SALARY","EMPL","NOTES","LOADTS")
> VALUES(?,?,?,?,?,?,?,?,?,?,?,?)
> [0] odb(7150) [2017-06-08 01:16:34] - [Trafodion ODBC Driver][Trafodion
> Database] SQL ERROR:*** ERROR[8822] The statement was not prepared.
> [2017-06-08 01:16:34] (State: X08MU Native Err: -8822)
> [0] odb(7150) [2017-06-08 01:16:34] - [Trafodion ODBC Driver][Trafodion
> Database] SQL ERROR:*** ERROR[15005] Unmatched quote in input (unterminated
> string):
> PID","FNAME","LNAME","COUNTRY","CITY","BDATE","SEX","EMAIL","SALARY","EMPL","NOTES","LOADTS")
> VALUES(?,?,?,?,?,?,?,?,?,?,?,?); [2017-06-08 01:16:34] (State: 42000 Native
> Err: -15005)
> odb: thread 1 closing connection...
> odb: thread 0 closing connection...
> odb: thread 0 is ending...
> odb: thread 1 is ending...
> odb [2017-06-08 01:16:34]: exiting. Session Elapsed time 6.588 seconds
> (00:00:06.588)
> *step to reproduce:*
> 1. create trafodion table
> CREATE TABLE TRAFODION.odb_test."SP_PERSON3" (PID BIGINT SIGNED NOT
> NULL,FNAME CHAR(20) NOT NULL,LNAME CHAR(20) NOT NULL,COUNTRY VARCHAR(40) NOT
> NULL,CITY VARCHAR(40) NOT NULL,BDATE DATE NOT NULL,SEX CHAR(1) NOT NULL,EMAIL
> VARCHAR(40) NOT NULL,SALARY NUMERIC(9,2) NOT NULL,EMPL VARCHAR(40) NOT
> NULL,NOTES VARCHAR(80),LOADTS TIMESTAMP(0),PRIMARY KEY (PID));
> 2.create directory and create three file in this directory, then input data
> to these files.
> example
> mkdir -p data
> touch data/test1
> touch data/test2
> touch data/test3
> data format as follow.
> 1!"Shi-Fu"!"Wu"!"Canada"!"Shanghai"!1918-06-23!"U"!"[email protected]"!304030!"Esgyn"!"aaaa"!2016-10-24
> 17:04:24
> 3.touch file named "odb_load_file",it contain content as follow.
> src=data/test1
> src=data/test2
> src=data/test3
> 4.execute the odb statement as follow.
> odb64luo -u trafuser -p trafpasswd -d trafdb -l
> src=-odb_load_file:tgt=trafodion.odb_test.sp_person3:max=10000:rows=5000:parallel=1:loadcmd=UL:fs=\!:sq=\"
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
