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

tip

Java does not handle IPv6 nameservers before 1.8.0_60. Upgrade to the latest JVM.


rp
tip

This is a bug in Wise, updating to v4.10 seems to solve the problem.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Twitter4j NumberFormatException
    via Stack Overflow by Hooman
    ,
  • failed to parse [facility] with gelf input
    via by Andrew Beresford,
  • GitHub comment 248#160440073
    via GitHub by SpokeU
    ,
  • GitHub comment 108#166923778
    via GitHub by 123dev
    ,
    • java.lang.IllegalArgumentException: columnValue:B8F05EB0-D870-E149-748E-EA36ABDBA6A0 Please eliminate any quote and non number within it. at io.mycat.route.function.PartitionByLong.calculate(PartitionByLong.java:64) at io.mycat.route.util.RouterUtil.findRouteWithcConditionsForTables(RouterUtil.java:1278) at io.mycat.route.util.RouterUtil.tryRouteForOneTable(RouterUtil.java:1075) at io.mycat.route.util.RouterUtil.tryRouteForTables(RouterUtil.java:947) at io.mycat.route.impl.DruidMycatRouteStrategy.routeNormalSqlWithAST(DruidMycatRouteStrategy.java:109) at io.mycat.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:81) at io.mycat.route.RouteService.route(RouteService.java:133) at io.mycat.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:273) at io.mycat.server.ServerConnection.execute(ServerConnection.java:222) at io.mycat.server.ServerQueryHandler.query(ServerQueryHandler.java:136) at io.mycat.net.FrontendConnection.query(FrontendConnection.java:317) at io.mycat.net.FrontendConnection.query(FrontendConnection.java:337) at io.mycat.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:71) at io.mycat.net.FrontendConnection.rawHandle(FrontendConnection.java:478) at io.mycat.net.FrontendConnection.handle(FrontendConnection.java:460) at io.mycat.net.AbstractConnection.onReadData(AbstractConnection.java:321) at io.mycat.net.NIOSocketWR.asynRead(NIOSocketWR.java:190) at io.mycat.net.AbstractConnection.asynRead(AbstractConnection.java:273) at io.mycat.net.NIOReactor$RW.run(NIOReactor.java:102) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NumberFormatException: For input string: "B8F05EB0-D870-E149-748E-EA36ABDBA6A0" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Long.parseLong(Long.java:589) at java.lang.Long.parseLong(Long.java:631) at io.mycat.route.function.PartitionByLong.calculate(PartitionByLong.java:61) ... 19 more

    Users with the same issue

    Luka
    Luka2 times, last one,
    tvrmsmith
    tvrmsmith1 times, last one,
    poroszd
    poroszd1 times, last one,
    marcbouvierdav
    marcbouvierdav1 times, last one,
    tyson925
    tyson9254 times, last one,
    201 more bugmates