回复: Re:Re: error when connect Doris via mysql

[王 铁 <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.
>> > > >
>> > >
>> >
>>