You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@trafodion.apache.org by 乔彦克 <qy...@gmail.com> on 2016/08/25 04:14:34 UTC
using jdbc insert trafdion get server reading problem
Hi, all,
I use the jdbc driver load data to trafodion with the 'upsert using
load ', I write 500 or 1000 lines(each line has 50 fields) once with
preparestatement as follows:
PreparedStatement ps = null;
StringBuffer sb = new StringBuffer("upsert using load into
trafodion.seabase.visit values(),()...() ");
ps = conn.prepareStatement(sb.toString());
ps.execute();
But the load program always encountered this error after running some
time(load 100 thousand lines or something like that) below:
[image: loaderror.png]
and there will generate core file under $MY_SQROOT path.
Once wrote 100 thousand lines or something like that this picture
will be present. Does anyone come up the problem ever, or would anyone give
some advice on this issue?
Besides, [*I have a 3 nodes cluster*].
Good tips about loading data through jdbc is welcome.
Any reply is appreciated.
Thanks,
Qiao.
Re: using jdbc insert trafdion get server reading problem
Posted by 乔彦克 <qy...@gmail.com>.
Thank you Kevin, I will try addBatch method.
And yes, there are many core dumps on the server.
Xu, Kai-Hua (Kevin) <ka...@esgyn.cn>于2016年8月25日周四 下午6:57写道：
> Usually, there should be some core dump on server-side. Could you please
> have a try ps.addBatch()/ps.executeBatch()? As I see, you have large of
> data, then we recommend to use BATCH operations.
>
>
>
> Best Regards,
>
> Kevin Xu
>
>
>
> *From:* 乔彦克 [mailto:qyanke@gmail.com]
> *Sent:* Thursday, August 25, 2016 6:12 PM
> *To:* user@trafodion.incubator.apache.org
> *Cc:* Xu, Kai-Hua (Kevin) <ka...@esgyn.cn>
> *Subject:* Re: using jdbc insert trafdion get server reading problem
>
>
>
> yes, trafci works well on the server-side.
>
> Xu, Kai-Hua (Kevin) <ka...@esgyn.cn>于2016年8月25日周四 下午4:12写道：
>
> Hi Qiao,
>
>
>
> Does Trafci work for you on server-side?
>
>
>
> Best Regards,
>
> Kevin Xu
>
>
>
> *From:* 乔彦克 [mailto:qyanke@gmail.com]
> *Sent:* Thursday, August 25, 2016 12:15 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* using jdbc insert trafdion get server reading problem
>
>
>
> Hi, all,
>
> I use the jdbc driver load data to trafodion with the 'upsert using
> load ', I write 500 or 1000 lines(each line has 50 fields) once with
> preparestatement as follows:
>
>
>
> PreparedStatement ps = *null*;
>
> StringBuffer sb = *new *StringBuffer(*"upsert using load into
> trafodion.seabase.visit values(),()...() "*);
>
> ps = conn.prepareStatement(sb.toString());
>
> ps.execute();
>
>
>
> But the load program always encountered this error after running some
> time(load 100 thousand lines or something like that) below:
>
> [image: image001.png]
>
> and there will generate core file under $MY_SQROOT path.
>
> Once wrote 100 thousand lines or something like that this picture
> will be present. Does anyone come up the problem ever, or would anyone give
> some advice on this issue?
>
> Besides, [*I have a 3 nodes cluster*].
>
> Good tips about loading data through jdbc is welcome.
>
> Any reply is appreciated.
>
> Thanks,
>
> Qiao.
>
>
RE: using jdbc insert trafdion get server reading problem
Posted by "Xu, Kai-Hua (Kevin)" <ka...@esgyn.cn>.
Usually, there should be some core dump on server-side. Could you please have a try ps.addBatch()/ps.executeBatch()? As I see, you have large of data, then we recommend to use BATCH operations.
Best Regards,
Kevin Xu
From: 乔彦克 [mailto:qyanke@gmail.com]
Sent: Thursday, August 25, 2016 6:12 PM
To: user@trafodion.incubator.apache.org
Cc: Xu, Kai-Hua (Kevin) <ka...@esgyn.cn>
Subject: Re: using jdbc insert trafdion get server reading problem
yes, trafci works well on the server-side.
Xu, Kai-Hua (Kevin) <ka...@esgyn.cn>>于2016年8月25日周四 下午4:12写道：
Hi Qiao,
Does Trafci work for you on server-side?
Best Regards,
Kevin Xu
From: 乔彦克 [mailto:qyanke@gmail.com<ma...@gmail.com>]
Sent: Thursday, August 25, 2016 12:15 PM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: using jdbc insert trafdion get server reading problem
Hi, all,
I use the jdbc driver load data to trafodion with the 'upsert using load ', I write 500 or 1000 lines(each line has 50 fields) once with preparestatement as follows:
PreparedStatement ps = null;
StringBuffer sb = new StringBuffer("upsert using load into trafodion.seabase.visit values(),()...() ");
ps = conn.prepareStatement(sb.toString());
ps.execute();
But the load program always encountered this error after running some time(load 100 thousand lines or something like that) below:
[image001.png]
and there will generate core file under $MY_SQROOT path.
Once wrote 100 thousand lines or something like that this picture will be present. Does anyone come up the problem ever, or would anyone give some advice on this issue?
Besides, [I have a 3 nodes cluster].
Good tips about loading data through jdbc is welcome.
Any reply is appreciated.
Thanks,
Qiao.
Re: using jdbc insert trafdion get server reading problem
Posted by 乔彦克 <qy...@gmail.com>.
yes, trafci works well on the server-side.
Xu, Kai-Hua (Kevin) <ka...@esgyn.cn>于2016年8月25日周四 下午4:12写道：
> Hi Qiao,
>
>
>
> Does Trafci work for you on server-side?
>
>
>
> Best Regards,
>
> Kevin Xu
>
>
>
> *From:* 乔彦克 [mailto:qyanke@gmail.com]
> *Sent:* Thursday, August 25, 2016 12:15 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* using jdbc insert trafdion get server reading problem
>
>
>
> Hi, all,
>
> I use the jdbc driver load data to trafodion with the 'upsert using
> load ', I write 500 or 1000 lines(each line has 50 fields) once with
> preparestatement as follows:
>
>
>
> PreparedStatement ps = *null*;
>
> StringBuffer sb = *new *StringBuffer(*"upsert using load into
> trafodion.seabase.visit values(),()...() "*);
>
> ps = conn.prepareStatement(sb.toString());
>
> ps.execute();
>
>
>
> But the load program always encountered this error after running some
> time(load 100 thousand lines or something like that) below:
>
> [image: image001.png]
>
> and there will generate core file under $MY_SQROOT path.
>
> Once wrote 100 thousand lines or something like that this picture
> will be present. Does anyone come up the problem ever, or would anyone give
> some advice on this issue?
>
> Besides, [*I have a 3 nodes cluster*].
>
> Good tips about loading data through jdbc is welcome.
>
> Any reply is appreciated.
>
> Thanks,
>
> Qiao.
>
RE: using jdbc insert trafdion get server reading problem
Posted by "Xu, Kai-Hua (Kevin)" <ka...@esgyn.cn>.
Hi Qiao,
Does Trafci work for you on server-side?
Best Regards,
Kevin Xu
From: 乔彦克 [mailto:qyanke@gmail.com]
Sent: Thursday, August 25, 2016 12:15 PM
To: user@trafodion.incubator.apache.org
Subject: using jdbc insert trafdion get server reading problem
Hi, all,
I use the jdbc driver load data to trafodion with the 'upsert using load ', I write 500 or 1000 lines(each line has 50 fields) once with preparestatement as follows:
PreparedStatement ps = null;
StringBuffer sb = new StringBuffer("upsert using load into trafodion.seabase.visit values(),()...() ");
ps = conn.prepareStatement(sb.toString());
ps.execute();
But the load program always encountered this error after running some time(load 100 thousand lines or something like that) below:
[loaderror.png]
and there will generate core file under $MY_SQROOT path.
Once wrote 100 thousand lines or something like that this picture will be present. Does anyone come up the problem ever, or would anyone give some advice on this issue?
Besides, [I have a 3 nodes cluster].
Good tips about loading data through jdbc is welcome.
Any reply is appreciated.
Thanks,
Qiao.