java.lang.IllegalArgumentException: columnValue:B8F05EB0-D870-E149-748E-EA36ABDBA6A0 Please eliminate any quote and non number within it.

GitHub | learninton | 2 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    mycat 1.6 插入报错,错误信息如下

    GitHub | 2 months ago | learninton
    java.lang.IllegalArgumentException: columnValue:B8F05EB0-D870-E149-748E-EA36ABDBA6A0 Please eliminate any quote and non number within it.
  2. 0

    GitHub comment 1172#265123683

    GitHub | 4 months ago | gaojingsong
    java.sql.SQLNonTransientException: can't find table define in schema ID schema:TESTDB
  3. 0

    GitHub comment 1082#244283304

    GitHub | 7 months ago | Kagamine
    java.sql.SQLNonTransientException: find no Route:SELECT * FROM `wechat`.`activities` LIMIT 0 java.sql.SQLNonTransientException: find no Route:SELECT * FROM `wechat`.`activities` LIMIT 0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    异常 find no Route

    GitHub | 3 months ago | githublaohu
    java.sql.SQLNonTransientException: find no Route:SELECT * FROM `vp_user_800000001`.`vp_user_info` LIMIT 0
  6. 0

    插入英文字符"?"时出现错误

    GitHub | 3 months ago | laula001
    com.alibaba.druid.sql.parser.ParserException: syntax error

  1. jesse 1 times, last 2 weeks ago
  2. poroszd 1 times, last 2 months ago
  3. treefolk 1 times, last 4 months ago
  4. MoYapro 5 times, last 4 months ago
  5. Handemelindo 6 times, last 3 days ago
15 more registered users
17 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.lang.NumberFormatException

    For input string: "B8F05EB0-D870-E149-748E-EA36ABDBA6A0"

    at java.lang.NumberFormatException.forInputString()
  2. Java RT
    Long.parseLong
    1. java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    2. java.lang.Long.parseLong(Long.java:589)
    3. java.lang.Long.parseLong(Long.java:631)
    3 frames
  3. io.mycat.route
    RouteService.route
    1. io.mycat.route.function.PartitionByLong.calculate(PartitionByLong.java:61)
    2. io.mycat.route.util.RouterUtil.findRouteWithcConditionsForTables(RouterUtil.java:1278)
    3. io.mycat.route.util.RouterUtil.tryRouteForOneTable(RouterUtil.java:1075)
    4. io.mycat.route.util.RouterUtil.tryRouteForTables(RouterUtil.java:947)
    5. io.mycat.route.impl.DruidMycatRouteStrategy.routeNormalSqlWithAST(DruidMycatRouteStrategy.java:109)
    6. io.mycat.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:81)
    7. io.mycat.route.RouteService.route(RouteService.java:133)
    7 frames
  4. io.mycat.server
    ServerQueryHandler.query
    1. io.mycat.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:273)
    2. io.mycat.server.ServerConnection.execute(ServerConnection.java:222)
    3. io.mycat.server.ServerQueryHandler.query(ServerQueryHandler.java:136)
    3 frames
  5. io.mycat.net
    NIOReactor$RW.run
    1. io.mycat.net.FrontendConnection.query(FrontendConnection.java:317)
    2. io.mycat.net.FrontendConnection.query(FrontendConnection.java:337)
    3. io.mycat.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:71)
    4. io.mycat.net.FrontendConnection.rawHandle(FrontendConnection.java:478)
    5. io.mycat.net.FrontendConnection.handle(FrontendConnection.java:460)
    6. io.mycat.net.AbstractConnection.onReadData(AbstractConnection.java:321)
    7. io.mycat.net.NIOSocketWR.asynRead(NIOSocketWR.java:190)
    8. io.mycat.net.AbstractConnection.asynRead(AbstractConnection.java:273)
    9. io.mycat.net.NIOReactor$RW.run(NIOReactor.java:102)
    9 frames
  6. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame