You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@doris.apache.org by 王 铁 <wa...@outlook.com> on 2021/12/13 08:01:28 UTC
error when connect Doris via mysql
Hi
I have compiled source code with using docker image, and I have started fe progress on one server
when I tried to connect use : ./mysql-client -h host -P port -uroot
there is an error shown on screen : ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
and in the same time , there are some warn infomation which is printed in fe.warn.log like this
ERROR (doris-mysql-nio-pool-8|143) [AcceptListener.lambda$handleEvent$1():86] connect processor exception because
java.lang.NoSuchMethodError: java.nio.ByteBuffer.limit(I)Ljava/nio/ByteBuffer;
at org.apache.doris.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:259) ~[palo-fe.jar:3.4.0]
at org.apache.doris.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:265) ~[palo-fe.jar:3.4.0]
at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:169) ~[palo-fe.jar:3.4.0]
at org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63) ~[palo-fe.jar:3.4.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_121]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_121]
at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
is this an issue or my mistake ?
thank you guys.
Re: error when connect Doris via mysql
Posted by 王 铁 <wa...@outlook.com>.
I am pretty sure this is not an issue because I launched fe in docker，it works good. I will try more thanks guys
获取 Outlook for iOS<https://aka.ms/o0ukef>
________________________________
发件人: ling miao <li...@apache.org>
发送时间: Tuesday, December 14, 2021 2:11:46 PM
收件人: dev <de...@doris.apache.org>
主题: Re: error when connect Doris via mysql
The jdk version is openJDK 11 in default.
If you use the default values when compiling in the image, you need to run
with openjdk 11.
Compile doc: [
https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
]
Ling Miao
王 铁 <wa...@outlook.com> 于2021年12月14日周二 12:37写道：
> I changed OpenJDK today but still got this error
>
> 获取 Outlook for iOS<https://aka.ms/o0ukef>
> ________________________________
> 发件人: ling miao <li...@apache.org>
> 发送时间: Monday, December 13, 2021 6:30:37 PM
> 收件人: dev <de...@doris.apache.org>
> 主题: Re: error when connect Doris via mysql
>
> We use open in Doris image,
> So you need to use open also ~
>
> Ling Miao
>
> 王 铁 <wa...@outlook.com> 于2021年12月13日周一 17:33写道：
>
> > I am using Oracle JDK 1.8.0_121
> >
> > ok I will change it and retry
> >
> > thanks
> > ________________________________
> > 发件人: ling miao <li...@apache.org>
> > 发送时间: 2021年12月13日 16:49
> > 收件人: dev <de...@doris.apache.org>
> > 主题: Re: error when connect Doris via mysql
> >
> > Are you using oracle jdk or open jdk？
> >
> > Ling Miao
> >
> > 王 铁 <wa...@outlook.com> 于2021年12月13日周一 16:47写道：
> >
> > > so I compiled source code with java 1.8.0_302 which from docker env
> > >
> > > and I launched fe with java 1.8.0_121
> > >
> > > is this tiny difference the reason we discussed before?
> > >
> > > ________________________________
> > > 发件人: Jianliang Qi <ji...@gmail.com>
> > > 发送时间: 2021年12月13日 16:32
> > > 收件人: dev@doris.apache.org <de...@doris.apache.org>
> > > 主题: Re: error when connect Doris via mysql
> > >
> > > Hi wangtie.
> > >
> > > Running and compiling Doris JDK must be consistent.
> > >
> > > You can reference the compile doc[1] to change the JDK version while
> > > compiling.
> > >
> > > [1]
> > >
> > >
> >
> https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
> > >
> > > On Mon, Dec 13, 2021 at 4:17 PM 王 铁 <wa...@outlook.com> wrote:
> > >
> > > > Hi
> > > >
> > > > I have compiled source code with using docker image, and I have
> started
> > > fe
> > > > progress on one server
> > > >
> > > > when I tried to connect use : ./mysql-client -h host -P port -uroot
> > > >
> > > > there is an error shown on screen : ERROR 2013 (HY000): Lost
> connection
> > > to
> > > > MySQL server at 'reading initial communication packet', system
> error: 0
> > > >
> > > > and in the same time , there are some warn infomation which is
> printed
> > in
> > > > fe.warn.log like this
> > > >
> > > > ERROR (doris-mysql-nio-pool-8|143)
> > > > [AcceptListener.lambda$handleEvent$1():86] connect processor
> exception
> > > > because
> > > > java.lang.NoSuchMethodError:
> > > > java.nio.ByteBuffer.limit(I)Ljava/nio/ByteBuffer;
> > > > at
> > > >
> > org.apache.doris.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:259)
> > > > ~[palo-fe.jar:3.4.0]
> > > > at
> > > org.apache.doris.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:265)
> > > > ~[palo-fe.jar:3.4.0]
> > > > at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:169)
> > > > ~[palo-fe.jar:3.4.0]
> > > > at
> > > >
> > >
> >
> org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63)
> > > > ~[palo-fe.jar:3.4.0]
> > > > at
> > > >
> > >
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> > > > [?:1.8.0_121]
> > > > at
> > > >
> > >
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> > > > [?:1.8.0_121]
> > > > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
> > > >
> > > > is this an issue or my mistake ?
> > > >
> > > > thank you guys.
> > > >
> > >
> >
>
回复: Re:Re: error when connect Doris via mysql
Posted by 王 铁 <wa...@outlook.com>.
I found the reason
because when I compiled source code , I have executed commands below
$ alternatives --set java java-1.8.0-openjdk.x86_64
$ alternatives --set javac java-1.8.0-openjdk.x86_64
$ export JAVA_HOME=/usr/lib/jvm/java-1.8.0
however the last command did not take effective or I miss it maybe
so actually I compiled the source code with java 11 and run fe in docker
and on server I used java 8
sorry to bother you so much guys
________________________________
发件人: 陈明雨 <mo...@163.com>
发送时间: 2021年12月14日 16:34
收件人: dev@doris.apache.org <de...@doris.apache.org>
主题: Re:Re: error when connect Doris via mysql
Could you try using Oracle JDK 8 at runtime?
--
此致！Best Regards
陈明雨 Mingyu Chen
Email:
chenmingyu@apache.org
在 2021-12-14 16:16:57，"王 铁" <wa...@outlook.com> 写道：
>I compiled with open jdk 1.8.0_302
>
>and I launched fe with the same version but I still got this error info
>
>获取 Outlook for iOS<https://aka.ms/o0ukef>
>________________________________
>发件人: ling miao <li...@apache.org>
>发送时间: Tuesday, December 14, 2021 2:11:46 PM
>收件人: dev <de...@doris.apache.org>
>主题: Re: error when connect Doris via mysql
>
>The jdk version is openJDK 11 in default.
>If you use the default values when compiling in the image, you need to run
>with openjdk 11.
>
>Compile doc: [
>https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
>]
>
>Ling Miao
>
>王 铁 <wa...@outlook.com> 于2021年12月14日周二 12:37写道：
>
>> I changed OpenJDK today but still got this error
>>
>> 获取 Outlook for iOS<https://aka.ms/o0ukef>
>> ________________________________
>> 发件人: ling miao <li...@apache.org>
>> 发送时间: Monday, December 13, 2021 6:30:37 PM
>> 收件人: dev <de...@doris.apache.org>
>> 主题: Re: error when connect Doris via mysql
>>
>> We use open in Doris image,
>> So you need to use open also ~
>>
>> Ling Miao
>>
>> 王 铁 <wa...@outlook.com> 于2021年12月13日周一 17:33写道：
>>
>> > I am using Oracle JDK 1.8.0_121
>> >
>> > ok I will change it and retry
>> >
>> > thanks
>> > ________________________________
>> > 发件人: ling miao <li...@apache.org>
>> > 发送时间: 2021年12月13日 16:49
>> > 收件人: dev <de...@doris.apache.org>
>> > 主题: Re: error when connect Doris via mysql
>> >
>> > Are you using oracle jdk or open jdk？
>> >
>> > Ling Miao
>> >
>> > 王 铁 <wa...@outlook.com> 于2021年12月13日周一 16:47写道：
>> >
>> > > so I compiled source code with java 1.8.0_302 which from docker env
>> > >
>> > > and I launched fe with java 1.8.0_121
>> > >
>> > > is this tiny difference the reason we discussed before?
>> > >
>> > > ________________________________
>> > > 发件人: Jianliang Qi <ji...@gmail.com>
>> > > 发送时间: 2021年12月13日 16:32
>> > > 收件人: dev@doris.apache.org <de...@doris.apache.org>
>> > > 主题: Re: error when connect Doris via mysql
>> > >
>> > > Hi wangtie.
>> > >
>> > > Running and compiling Doris JDK must be consistent.
>> > >
>> > > You can reference the compile doc[1] to change the JDK version while
>> > > compiling.
>> > >
>> > > [1]
>> > >
>> > >
>> >
>> https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
>> > >
>> > > On Mon, Dec 13, 2021 at 4:17 PM 王 铁 <wa...@outlook.com> wrote:
>> > >
>> > > > Hi
>> > > >
>> > > > I have compiled source code with using docker image, and I have
>> started
>> > > fe
>> > > > progress on one server
>> > > >
>> > > > when I tried to connect use : ./mysql-client -h host -P port -uroot
>> > > >
>> > > > there is an error shown on screen : ERROR 2013 (HY000): Lost
>> connection
>> > > to
>> > > > MySQL server at 'reading initial communication packet', system
>> error: 0
>> > > >
>> > > > and in the same time , there are some warn infomation which is
>> printed
>> > in
>> > > > fe.warn.log like this
>> > > >
>> > > > ERROR (doris-mysql-nio-pool-8|143)
>> > > > [AcceptListener.lambda$handleEvent$1():86] connect processor
>> exception
>> > > > because
>> > > > java.lang.NoSuchMethodError:
>> > > > java.nio.ByteBuffer.limit(I)Ljava/nio/ByteBuffer;
>> > > > at
>> > > >
>> > org.apache.doris.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:259)
>> > > > ~[palo-fe.jar:3.4.0]
>> > > > at
>> > > org.apache.doris.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:265)
>> > > > ~[palo-fe.jar:3.4.0]
>> > > > at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:169)
>> > > > ~[palo-fe.jar:3.4.0]
>> > > > at
>> > > >
>> > >
>> >
>> org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63)
>> > > > ~[palo-fe.jar:3.4.0]
>> > > > at
>> > > >
>> > >
>> >
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>> > > > [?:1.8.0_121]
>> > > > at
>> > > >
>> > >
>> >
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>> > > > [?:1.8.0_121]
>> > > > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
>> > > >
>> > > > is this an issue or my mistake ?
>> > > >
>> > > > thank you guys.
>> > > >
>> > >
>> >
>>
Re:Re: error when connect Doris via mysql
Posted by 陈明雨 <mo...@163.com>.
Could you try using Oracle JDK 8 at runtime?
--
此致！Best Regards
陈明雨 Mingyu Chen
Email:
chenmingyu@apache.org
在 2021-12-14 16:16:57，"王 铁" <wa...@outlook.com> 写道：
>I compiled with open jdk 1.8.0_302
>
>and I launched fe with the same version but I still got this error info
>
>获取 Outlook for iOS<https://aka.ms/o0ukef>
>________________________________
>发件人: ling miao <li...@apache.org>
>发送时间: Tuesday, December 14, 2021 2:11:46 PM
>收件人: dev <de...@doris.apache.org>
>主题: Re: error when connect Doris via mysql
>
>The jdk version is openJDK 11 in default.
>If you use the default values when compiling in the image, you need to run
>with openjdk 11.
>
>Compile doc: [
>https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
>]
>
>Ling Miao
>
>王 铁 <wa...@outlook.com> 于2021年12月14日周二 12:37写道：
>
>> I changed OpenJDK today but still got this error
>>
>> 获取 Outlook for iOS<https://aka.ms/o0ukef>
>> ________________________________
>> 发件人: ling miao <li...@apache.org>
>> 发送时间: Monday, December 13, 2021 6:30:37 PM
>> 收件人: dev <de...@doris.apache.org>
>> 主题: Re: error when connect Doris via mysql
>>
>> We use open in Doris image,
>> So you need to use open also ~
>>
>> Ling Miao
>>
>> 王 铁 <wa...@outlook.com> 于2021年12月13日周一 17:33写道：
>>
>> > I am using Oracle JDK 1.8.0_121
>> >
>> > ok I will change it and retry
>> >
>> > thanks
>> > ________________________________
>> > 发件人: ling miao <li...@apache.org>
>> > 发送时间: 2021年12月13日 16:49
>> > 收件人: dev <de...@doris.apache.org>
>> > 主题: Re: error when connect Doris via mysql
>> >
>> > Are you using oracle jdk or open jdk？
>> >
>> > Ling Miao
>> >
>> > 王 铁 <wa...@outlook.com> 于2021年12月13日周一 16:47写道：
>> >
>> > > so I compiled source code with java 1.8.0_302 which from docker env
>> > >
>> > > and I launched fe with java 1.8.0_121
>> > >
>> > > is this tiny difference the reason we discussed before?
>> > >
>> > > ________________________________
>> > > 发件人: Jianliang Qi <ji...@gmail.com>
>> > > 发送时间: 2021年12月13日 16:32
>> > > 收件人: dev@doris.apache.org <de...@doris.apache.org>
>> > > 主题: Re: error when connect Doris via mysql
>> > >
>> > > Hi wangtie.
>> > >
>> > > Running and compiling Doris JDK must be consistent.
>> > >
>> > > You can reference the compile doc[1] to change the JDK version while
>> > > compiling.
>> > >
>> > > [1]
>> > >
>> > >
>> >
>> https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
>> > >
>> > > On Mon, Dec 13, 2021 at 4:17 PM 王 铁 <wa...@outlook.com> wrote:
>> > >
>> > > > Hi
>> > > >
>> > > > I have compiled source code with using docker image, and I have
>> started
>> > > fe
>> > > > progress on one server
>> > > >
>> > > > when I tried to connect use : ./mysql-client -h host -P port -uroot
>> > > >
>> > > > there is an error shown on screen : ERROR 2013 (HY000): Lost
>> connection
>> > > to
>> > > > MySQL server at 'reading initial communication packet', system
>> error: 0
>> > > >
>> > > > and in the same time , there are some warn infomation which is
>> printed
>> > in
>> > > > fe.warn.log like this
>> > > >
>> > > > ERROR (doris-mysql-nio-pool-8|143)
>> > > > [AcceptListener.lambda$handleEvent$1():86] connect processor
>> exception
>> > > > because
>> > > > java.lang.NoSuchMethodError:
>> > > > java.nio.ByteBuffer.limit(I)Ljava/nio/ByteBuffer;
>> > > > at
>> > > >
>> > org.apache.doris.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:259)
>> > > > ~[palo-fe.jar:3.4.0]
>> > > > at
>> > > org.apache.doris.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:265)
>> > > > ~[palo-fe.jar:3.4.0]
>> > > > at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:169)
>> > > > ~[palo-fe.jar:3.4.0]
>> > > > at
>> > > >
>> > >
>> >
>> org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63)
>> > > > ~[palo-fe.jar:3.4.0]
>> > > > at
>> > > >
>> > >
>> >
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>> > > > [?:1.8.0_121]
>> > > > at
>> > > >
>> > >
>> >
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>> > > > [?:1.8.0_121]
>> > > > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
>> > > >
>> > > > is this an issue or my mistake ?
>> > > >
>> > > > thank you guys.
>> > > >
>> > >
>> >
>>
Re: error when connect Doris via mysql
Posted by 王 铁 <wa...@outlook.com>.
I compiled with open jdk 1.8.0_302
and I launched fe with the same version but I still got this error info
获取 Outlook for iOS<https://aka.ms/o0ukef>
________________________________
发件人: ling miao <li...@apache.org>
发送时间: Tuesday, December 14, 2021 2:11:46 PM
收件人: dev <de...@doris.apache.org>
主题: Re: error when connect Doris via mysql
The jdk version is openJDK 11 in default.
If you use the default values when compiling in the image, you need to run
with openjdk 11.
Compile doc: [
https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
]
Ling Miao
王 铁 <wa...@outlook.com> 于2021年12月14日周二 12:37写道：
> I changed OpenJDK today but still got this error
>
> 获取 Outlook for iOS<https://aka.ms/o0ukef>
> ________________________________
> 发件人: ling miao <li...@apache.org>
> 发送时间: Monday, December 13, 2021 6:30:37 PM
> 收件人: dev <de...@doris.apache.org>
> 主题: Re: error when connect Doris via mysql
>
> We use open in Doris image,
> So you need to use open also ~
>
> Ling Miao
>
> 王 铁 <wa...@outlook.com> 于2021年12月13日周一 17:33写道：
>
> > I am using Oracle JDK 1.8.0_121
> >
> > ok I will change it and retry
> >
> > thanks
> > ________________________________
> > 发件人: ling miao <li...@apache.org>
> > 发送时间: 2021年12月13日 16:49
> > 收件人: dev <de...@doris.apache.org>
> > 主题: Re: error when connect Doris via mysql
> >
> > Are you using oracle jdk or open jdk？
> >
> > Ling Miao
> >
> > 王 铁 <wa...@outlook.com> 于2021年12月13日周一 16:47写道：
> >
> > > so I compiled source code with java 1.8.0_302 which from docker env
> > >
> > > and I launched fe with java 1.8.0_121
> > >
> > > is this tiny difference the reason we discussed before?
> > >
> > > ________________________________
> > > 发件人: Jianliang Qi <ji...@gmail.com>
> > > 发送时间: 2021年12月13日 16:32
> > > 收件人: dev@doris.apache.org <de...@doris.apache.org>
> > > 主题: Re: error when connect Doris via mysql
> > >
> > > Hi wangtie.
> > >
> > > Running and compiling Doris JDK must be consistent.
> > >
> > > You can reference the compile doc[1] to change the JDK version while
> > > compiling.
> > >
> > > [1]
> > >
> > >
> >
> https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
> > >
> > > On Mon, Dec 13, 2021 at 4:17 PM 王 铁 <wa...@outlook.com> wrote:
> > >
> > > > Hi
> > > >
> > > > I have compiled source code with using docker image, and I have
> started
> > > fe
> > > > progress on one server
> > > >
> > > > when I tried to connect use : ./mysql-client -h host -P port -uroot
> > > >
> > > > there is an error shown on screen : ERROR 2013 (HY000): Lost
> connection
> > > to
> > > > MySQL server at 'reading initial communication packet', system
> error: 0
> > > >
> > > > and in the same time , there are some warn infomation which is
> printed
> > in
> > > > fe.warn.log like this
> > > >
> > > > ERROR (doris-mysql-nio-pool-8|143)
> > > > [AcceptListener.lambda$handleEvent$1():86] connect processor
> exception
> > > > because
> > > > java.lang.NoSuchMethodError:
> > > > java.nio.ByteBuffer.limit(I)Ljava/nio/ByteBuffer;
> > > > at
> > > >
> > org.apache.doris.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:259)
> > > > ~[palo-fe.jar:3.4.0]
> > > > at
> > > org.apache.doris.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:265)
> > > > ~[palo-fe.jar:3.4.0]
> > > > at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:169)
> > > > ~[palo-fe.jar:3.4.0]
> > > > at
> > > >
> > >
> >
> org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63)
> > > > ~[palo-fe.jar:3.4.0]
> > > > at
> > > >
> > >
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> > > > [?:1.8.0_121]
> > > > at
> > > >
> > >
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> > > > [?:1.8.0_121]
> > > > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
> > > >
> > > > is this an issue or my mistake ?
> > > >
> > > > thank you guys.
> > > >
> > >
> >
>
Re: error when connect Doris via mysql
Posted by ling miao <li...@apache.org>.
The jdk version is openJDK 11 in default.
If you use the default values when compiling in the image, you need to run
with openjdk 11.
Compile doc: [
https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
]
Ling Miao
王 铁 <wa...@outlook.com> 于2021年12月14日周二 12:37写道：
> I changed OpenJDK today but still got this error
>
> 获取 Outlook for iOS<https://aka.ms/o0ukef>
> ________________________________
> 发件人: ling miao <li...@apache.org>
> 发送时间: Monday, December 13, 2021 6:30:37 PM
> 收件人: dev <de...@doris.apache.org>
> 主题: Re: error when connect Doris via mysql
>
> We use open in Doris image,
> So you need to use open also ~
>
> Ling Miao
>
> 王 铁 <wa...@outlook.com> 于2021年12月13日周一 17:33写道：
>
> > I am using Oracle JDK 1.8.0_121
> >
> > ok I will change it and retry
> >
> > thanks
> > ________________________________
> > 发件人: ling miao <li...@apache.org>
> > 发送时间: 2021年12月13日 16:49
> > 收件人: dev <de...@doris.apache.org>
> > 主题: Re: error when connect Doris via mysql
> >
> > Are you using oracle jdk or open jdk？
> >
> > Ling Miao
> >
> > 王 铁 <wa...@outlook.com> 于2021年12月13日周一 16:47写道：
> >
> > > so I compiled source code with java 1.8.0_302 which from docker env
> > >
> > > and I launched fe with java 1.8.0_121
> > >
> > > is this tiny difference the reason we discussed before?
> > >
> > > ________________________________
> > > 发件人: Jianliang Qi <ji...@gmail.com>
> > > 发送时间: 2021年12月13日 16:32
> > > 收件人: dev@doris.apache.org <de...@doris.apache.org>
> > > 主题: Re: error when connect Doris via mysql
> > >
> > > Hi wangtie.
> > >
> > > Running and compiling Doris JDK must be consistent.
> > >
> > > You can reference the compile doc[1] to change the JDK version while
> > > compiling.
> > >
> > > [1]
> > >
> > >
> >
> https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
> > >
> > > On Mon, Dec 13, 2021 at 4:17 PM 王 铁 <wa...@outlook.com> wrote:
> > >
> > > > Hi
> > > >
> > > > I have compiled source code with using docker image, and I have
> started
> > > fe
> > > > progress on one server
> > > >
> > > > when I tried to connect use : ./mysql-client -h host -P port -uroot
> > > >
> > > > there is an error shown on screen : ERROR 2013 (HY000): Lost
> connection
> > > to
> > > > MySQL server at 'reading initial communication packet', system
> error: 0
> > > >
> > > > and in the same time , there are some warn infomation which is
> printed
> > in
> > > > fe.warn.log like this
> > > >
> > > > ERROR (doris-mysql-nio-pool-8|143)
> > > > [AcceptListener.lambda$handleEvent$1():86] connect processor
> exception
> > > > because
> > > > java.lang.NoSuchMethodError:
> > > > java.nio.ByteBuffer.limit(I)Ljava/nio/ByteBuffer;
> > > > at
> > > >
> > org.apache.doris.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:259)
> > > > ~[palo-fe.jar:3.4.0]
> > > > at
> > > org.apache.doris.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:265)
> > > > ~[palo-fe.jar:3.4.0]
> > > > at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:169)
> > > > ~[palo-fe.jar:3.4.0]
> > > > at
> > > >
> > >
> >
> org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63)
> > > > ~[palo-fe.jar:3.4.0]
> > > > at
> > > >
> > >
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> > > > [?:1.8.0_121]
> > > > at
> > > >
> > >
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> > > > [?:1.8.0_121]
> > > > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
> > > >
> > > > is this an issue or my mistake ?
> > > >
> > > > thank you guys.
> > > >
> > >
> >
>
Re: error when connect Doris via mysql
Posted by 王 铁 <wa...@outlook.com>.
I changed OpenJDK today but still got this error
获取 Outlook for iOS<https://aka.ms/o0ukef>
________________________________
发件人: ling miao <li...@apache.org>
发送时间: Monday, December 13, 2021 6:30:37 PM
收件人: dev <de...@doris.apache.org>
主题: Re: error when connect Doris via mysql
We use open in Doris image,
So you need to use open also ~
Ling Miao
王 铁 <wa...@outlook.com> 于2021年12月13日周一 17:33写道：
> I am using Oracle JDK 1.8.0_121
>
> ok I will change it and retry
>
> thanks
> ________________________________
> 发件人: ling miao <li...@apache.org>
> 发送时间: 2021年12月13日 16:49
> 收件人: dev <de...@doris.apache.org>
> 主题: Re: error when connect Doris via mysql
>
> Are you using oracle jdk or open jdk？
>
> Ling Miao
>
> 王 铁 <wa...@outlook.com> 于2021年12月13日周一 16:47写道：
>
> > so I compiled source code with java 1.8.0_302 which from docker env
> >
> > and I launched fe with java 1.8.0_121
> >
> > is this tiny difference the reason we discussed before?
> >
> > ________________________________
> > 发件人: Jianliang Qi <ji...@gmail.com>
> > 发送时间: 2021年12月13日 16:32
> > 收件人: dev@doris.apache.org <de...@doris.apache.org>
> > 主题: Re: error when connect Doris via mysql
> >
> > Hi wangtie.
> >
> > Running and compiling Doris JDK must be consistent.
> >
> > You can reference the compile doc[1] to change the JDK version while
> > compiling.
> >
> > [1]
> >
> >
> https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
> >
> > On Mon, Dec 13, 2021 at 4:17 PM 王 铁 <wa...@outlook.com> wrote:
> >
> > > Hi
> > >
> > > I have compiled source code with using docker image, and I have started
> > fe
> > > progress on one server
> > >
> > > when I tried to connect use : ./mysql-client -h host -P port -uroot
> > >
> > > there is an error shown on screen : ERROR 2013 (HY000): Lost connection
> > to
> > > MySQL server at 'reading initial communication packet', system error: 0
> > >
> > > and in the same time , there are some warn infomation which is printed
> in
> > > fe.warn.log like this
> > >
> > > ERROR (doris-mysql-nio-pool-8|143)
> > > [AcceptListener.lambda$handleEvent$1():86] connect processor exception
> > > because
> > > java.lang.NoSuchMethodError:
> > > java.nio.ByteBuffer.limit(I)Ljava/nio/ByteBuffer;
> > > at
> > >
> org.apache.doris.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:259)
> > > ~[palo-fe.jar:3.4.0]
> > > at
> > org.apache.doris.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:265)
> > > ~[palo-fe.jar:3.4.0]
> > > at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:169)
> > > ~[palo-fe.jar:3.4.0]
> > > at
> > >
> >
> org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63)
> > > ~[palo-fe.jar:3.4.0]
> > > at
> > >
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> > > [?:1.8.0_121]
> > > at
> > >
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> > > [?:1.8.0_121]
> > > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
> > >
> > > is this an issue or my mistake ?
> > >
> > > thank you guys.
> > >
> >
>
Re: error when connect Doris via mysql
Posted by ling miao <li...@apache.org>.
We use open in Doris image,
So you need to use open also ~
Ling Miao
王 铁 <wa...@outlook.com> 于2021年12月13日周一 17:33写道：
> I am using Oracle JDK 1.8.0_121
>
> ok I will change it and retry
>
> thanks
> ________________________________
> 发件人: ling miao <li...@apache.org>
> 发送时间: 2021年12月13日 16:49
> 收件人: dev <de...@doris.apache.org>
> 主题: Re: error when connect Doris via mysql
>
> Are you using oracle jdk or open jdk？
>
> Ling Miao
>
> 王 铁 <wa...@outlook.com> 于2021年12月13日周一 16:47写道：
>
> > so I compiled source code with java 1.8.0_302 which from docker env
> >
> > and I launched fe with java 1.8.0_121
> >
> > is this tiny difference the reason we discussed before?
> >
> > ________________________________
> > 发件人: Jianliang Qi <ji...@gmail.com>
> > 发送时间: 2021年12月13日 16:32
> > 收件人: dev@doris.apache.org <de...@doris.apache.org>
> > 主题: Re: error when connect Doris via mysql
> >
> > Hi wangtie.
> >
> > Running and compiling Doris JDK must be consistent.
> >
> > You can reference the compile doc[1] to change the JDK version while
> > compiling.
> >
> > [1]
> >
> >
> https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
> >
> > On Mon, Dec 13, 2021 at 4:17 PM 王 铁 <wa...@outlook.com> wrote:
> >
> > > Hi
> > >
> > > I have compiled source code with using docker image, and I have started
> > fe
> > > progress on one server
> > >
> > > when I tried to connect use : ./mysql-client -h host -P port -uroot
> > >
> > > there is an error shown on screen : ERROR 2013 (HY000): Lost connection
> > to
> > > MySQL server at 'reading initial communication packet', system error: 0
> > >
> > > and in the same time , there are some warn infomation which is printed
> in
> > > fe.warn.log like this
> > >
> > > ERROR (doris-mysql-nio-pool-8|143)
> > > [AcceptListener.lambda$handleEvent$1():86] connect processor exception
> > > because
> > > java.lang.NoSuchMethodError:
> > > java.nio.ByteBuffer.limit(I)Ljava/nio/ByteBuffer;
> > > at
> > >
> org.apache.doris.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:259)
> > > ~[palo-fe.jar:3.4.0]
> > > at
> > org.apache.doris.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:265)
> > > ~[palo-fe.jar:3.4.0]
> > > at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:169)
> > > ~[palo-fe.jar:3.4.0]
> > > at
> > >
> >
> org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63)
> > > ~[palo-fe.jar:3.4.0]
> > > at
> > >
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> > > [?:1.8.0_121]
> > > at
> > >
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> > > [?:1.8.0_121]
> > > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
> > >
> > > is this an issue or my mistake ?
> > >
> > > thank you guys.
> > >
> >
>
回复: error when connect Doris via mysql
Posted by 王 铁 <wa...@outlook.com>.
I am using Oracle JDK 1.8.0_121
ok I will change it and retry
thanks
________________________________
发件人: ling miao <li...@apache.org>
发送时间: 2021年12月13日 16:49
收件人: dev <de...@doris.apache.org>
主题: Re: error when connect Doris via mysql
Are you using oracle jdk or open jdk？
Ling Miao
王 铁 <wa...@outlook.com> 于2021年12月13日周一 16:47写道：
> so I compiled source code with java 1.8.0_302 which from docker env
>
> and I launched fe with java 1.8.0_121
>
> is this tiny difference the reason we discussed before?
>
> ________________________________
> 发件人: Jianliang Qi <ji...@gmail.com>
> 发送时间: 2021年12月13日 16:32
> 收件人: dev@doris.apache.org <de...@doris.apache.org>
> 主题: Re: error when connect Doris via mysql
>
> Hi wangtie.
>
> Running and compiling Doris JDK must be consistent.
>
> You can reference the compile doc[1] to change the JDK version while
> compiling.
>
> [1]
>
> https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
>
> On Mon, Dec 13, 2021 at 4:17 PM 王 铁 <wa...@outlook.com> wrote:
>
> > Hi
> >
> > I have compiled source code with using docker image, and I have started
> fe
> > progress on one server
> >
> > when I tried to connect use : ./mysql-client -h host -P port -uroot
> >
> > there is an error shown on screen : ERROR 2013 (HY000): Lost connection
> to
> > MySQL server at 'reading initial communication packet', system error: 0
> >
> > and in the same time , there are some warn infomation which is printed in
> > fe.warn.log like this
> >
> > ERROR (doris-mysql-nio-pool-8|143)
> > [AcceptListener.lambda$handleEvent$1():86] connect processor exception
> > because
> > java.lang.NoSuchMethodError:
> > java.nio.ByteBuffer.limit(I)Ljava/nio/ByteBuffer;
> > at
> > org.apache.doris.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:259)
> > ~[palo-fe.jar:3.4.0]
> > at
> org.apache.doris.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:265)
> > ~[palo-fe.jar:3.4.0]
> > at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:169)
> > ~[palo-fe.jar:3.4.0]
> > at
> >
> org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63)
> > ~[palo-fe.jar:3.4.0]
> > at
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> > [?:1.8.0_121]
> > at
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> > [?:1.8.0_121]
> > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
> >
> > is this an issue or my mistake ?
> >
> > thank you guys.
> >
>
Re: error when connect Doris via mysql
Posted by ling miao <li...@apache.org>.
Are you using oracle jdk or open jdk？
Ling Miao
王 铁 <wa...@outlook.com> 于2021年12月13日周一 16:47写道：
> so I compiled source code with java 1.8.0_302 which from docker env
>
> and I launched fe with java 1.8.0_121
>
> is this tiny difference the reason we discussed before?
>
> ________________________________
> 发件人: Jianliang Qi <ji...@gmail.com>
> 发送时间: 2021年12月13日 16:32
> 收件人: dev@doris.apache.org <de...@doris.apache.org>
> 主题: Re: error when connect Doris via mysql
>
> Hi wangtie.
>
> Running and compiling Doris JDK must be consistent.
>
> You can reference the compile doc[1] to change the JDK version while
> compiling.
>
> [1]
>
> https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
>
> On Mon, Dec 13, 2021 at 4:17 PM 王 铁 <wa...@outlook.com> wrote:
>
> > Hi
> >
> > I have compiled source code with using docker image, and I have started
> fe
> > progress on one server
> >
> > when I tried to connect use : ./mysql-client -h host -P port -uroot
> >
> > there is an error shown on screen : ERROR 2013 (HY000): Lost connection
> to
> > MySQL server at 'reading initial communication packet', system error: 0
> >
> > and in the same time , there are some warn infomation which is printed in
> > fe.warn.log like this
> >
> > ERROR (doris-mysql-nio-pool-8|143)
> > [AcceptListener.lambda$handleEvent$1():86] connect processor exception
> > because
> > java.lang.NoSuchMethodError:
> > java.nio.ByteBuffer.limit(I)Ljava/nio/ByteBuffer;
> > at
> > org.apache.doris.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:259)
> > ~[palo-fe.jar:3.4.0]
> > at
> org.apache.doris.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:265)
> > ~[palo-fe.jar:3.4.0]
> > at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:169)
> > ~[palo-fe.jar:3.4.0]
> > at
> >
> org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63)
> > ~[palo-fe.jar:3.4.0]
> > at
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> > [?:1.8.0_121]
> > at
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> > [?:1.8.0_121]
> > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
> >
> > is this an issue or my mistake ?
> >
> > thank you guys.
> >
>
回复: error when connect Doris via mysql
Posted by 王 铁 <wa...@outlook.com>.
so I compiled source code with java 1.8.0_302 which from docker env
and I launched fe with java 1.8.0_121
is this tiny difference the reason we discussed before?
________________________________
发件人: Jianliang Qi <ji...@gmail.com>
发送时间: 2021年12月13日 16:32
收件人: dev@doris.apache.org <de...@doris.apache.org>
主题: Re: error when connect Doris via mysql
Hi wangtie.
Running and compiling Doris JDK must be consistent.
You can reference the compile doc[1] to change the JDK version while
compiling.
[1]
https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
On Mon, Dec 13, 2021 at 4:17 PM 王 铁 <wa...@outlook.com> wrote:
> Hi
>
> I have compiled source code with using docker image, and I have started fe
> progress on one server
>
> when I tried to connect use : ./mysql-client -h host -P port -uroot
>
> there is an error shown on screen : ERROR 2013 (HY000): Lost connection to
> MySQL server at 'reading initial communication packet', system error: 0
>
> and in the same time , there are some warn infomation which is printed in
> fe.warn.log like this
>
> ERROR (doris-mysql-nio-pool-8|143)
> [AcceptListener.lambda$handleEvent$1():86] connect processor exception
> because
> java.lang.NoSuchMethodError:
> java.nio.ByteBuffer.limit(I)Ljava/nio/ByteBuffer;
> at
> org.apache.doris.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:259)
> ~[palo-fe.jar:3.4.0]
> at org.apache.doris.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:265)
> ~[palo-fe.jar:3.4.0]
> at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:169)
> ~[palo-fe.jar:3.4.0]
> at
> org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63)
> ~[palo-fe.jar:3.4.0]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> [?:1.8.0_121]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> [?:1.8.0_121]
> at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
>
> is this an issue or my mistake ?
>
> thank you guys.
>
Re: error when connect Doris via mysql
Posted by Jianliang Qi <ji...@gmail.com>.
Hi wangtie.
Running and compiling Doris JDK must be consistent.
You can reference the compile doc[1] to change the JDK version while
compiling.
[1]
https://doris.apache.org/master/zh-CN/installing/compilation.html#%E4%BD%BF%E7%94%A8-docker-%E5%BC%80%E5%8F%91%E9%95%9C%E5%83%8F%E7%BC%96%E8%AF%91-%E6%8E%A8%E8%8D%90
On Mon, Dec 13, 2021 at 4:17 PM 王 铁 <wa...@outlook.com> wrote:
> Hi
>
> I have compiled source code with using docker image, and I have started fe
> progress on one server
>
> when I tried to connect use : ./mysql-client -h host -P port -uroot
>
> there is an error shown on screen : ERROR 2013 (HY000): Lost connection to
> MySQL server at 'reading initial communication packet', system error: 0
>
> and in the same time , there are some warn infomation which is printed in
> fe.warn.log like this
>
> ERROR (doris-mysql-nio-pool-8|143)
> [AcceptListener.lambda$handleEvent$1():86] connect processor exception
> because
> java.lang.NoSuchMethodError:
> java.nio.ByteBuffer.limit(I)Ljava/nio/ByteBuffer;
> at
> org.apache.doris.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:259)
> ~[palo-fe.jar:3.4.0]
> at org.apache.doris.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:265)
> ~[palo-fe.jar:3.4.0]
> at org.apache.doris.mysql.MysqlProto.negotiate(MysqlProto.java:169)
> ~[palo-fe.jar:3.4.0]
> at
> org.apache.doris.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:63)
> ~[palo-fe.jar:3.4.0]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> [?:1.8.0_121]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> [?:1.8.0_121]
> at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
>
> is this an issue or my mistake ?
>
> thank you guys.
>