Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

java.lang.NumberFormatException: Value out of range. Value:"65535" Radix:10 #2622

Open
zhengweisk opened this issue Oct 27, 2020 · 3 comments

Comments

@zhengweisk
Copy link

2020-10-27 06:00:26.828 WARN [$_NIOREACTOR-1-RW] (io.mycat.net.NIOReactor$RW.run(NIOReactor.java:118)) - caught err:
java.lang.NumberFormatException: Value out of range. Value:"65535" Radix:10
at java.lang.Short.parseShort(Short.java:120) ~[?:1.8.0_265]
at java.lang.Short.parseShort(Short.java:144) ~[?:1.8.0_265]
at io.mycat.util.ByteUtil.getShort(ByteUtil.java:158) ~[Mycat-server-1.6.7.5-release.jar:?]
at io.mycat.net.mysql.BinaryRowDataPacket.convert(BinaryRowDataPacket.java:163) ~[Mycat-server-1.6.7.5-release.jar:?]
at io.mycat.net.mysql.BinaryRowDataPacket.read(BinaryRowDataPacket.java:97) ~[Mycat-server-1.6.7.5-release.jar:?]
at io.mycat.backend.mysql.nio.handler.SingleNodeHandler.rowResponse(SingleNodeHandler.java:515) ~[Mycat-server-1.6.7.5-release.jar:?]
at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handleRowPacket(MySQLConnectionHandler.java:232) ~[Mycat-server-1.6.7.5-release.jar:?]
at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handleData(MySQLConnectionHandler.java:137) ~[Mycat-server-1.6.7.5-release.jar:?]
at io.mycat.net.handler.BackendAsyncHandler.offerData(BackendAsyncHandler.java:36) ~[Mycat-server-1.6.7.5-release.jar:?]
at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handle(MySQLConnectionHandler.java:82) ~[Mycat-server-1.6.7.5-release.jar:?]
at io.mycat.net.AbstractConnection.handle(AbstractConnection.java:269) ~[Mycat-server-1.6.7.5-release.jar:?]
at io.mycat.net.AbstractConnection.onReadData(AbstractConnection.java:327) ~[Mycat-server-1.6.7.5-release.jar:?]
at io.mycat.net.NIOSocketWR.asynRead(NIOSocketWR.java:216) ~[Mycat-server-1.6.7.5-release.jar:?]
at io.mycat.net.AbstractConnection.asynRead(AbstractConnection.java:279) ~[Mycat-server-1.6.7.5-release.jar:?]
at io.mycat.net.NIOReactor$RW.run(NIOReactor.java:113) [Mycat-server-1.6.7.5-release.jar:?]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_265]

@funnyAnt
Copy link
Collaborator

@zhengweisk 提供下mysql数据库里面数据的值,初步看是prepare语句结果集转换的时候超出了short范围。

@junwen12221
Copy link
Collaborator

收到的数据是无符号short,但是被作为有符号short处理超出范围报错

@funnyAnt
Copy link
Collaborator

@zhengweisk 已经解决。

junwen12221 added a commit that referenced this issue Nov 1, 2020
#2622 解决prepare因不支持mysql unsigned 类型导致的超出short范围报错
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants