java.sql.SQLNonTransientException: find no Route:SELECT * FROM `wechat`.`activities` LIMIT 0 java.sql.SQLNonTransientException: find no Route:SELECT * FROM `wechat`.`activities` LIMIT 0

GitHub | Kagamine | 6 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    GitHub comment 1082#244283304

    GitHub | 6 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
  2. 0

    GitHub comment 1172#265123683

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

    异常 find no Route

    GitHub | 2 months ago | githublaohu
    java.sql.SQLNonTransientException: find no Route:SELECT * FROM `vp_user_800000001`.`vp_user_info` LIMIT 0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLNonTransientException

      find no Route:SELECT * FROM `wechat`.`activities` LIMIT 0 java.sql.SQLNonTransientException: find no Route:SELECT * FROM `wechat`.`activities` LIMIT 0

      at io.mycat.route.parser.druid.impl.DruidSelectParser.tryRoute()
    2. io.mycat.route
      RouteService.route
      1. io.mycat.route.parser.druid.impl.DruidSelectParser.tryRoute(DruidSelectParser.java:437)
      2. io.mycat.route.parser.druid.impl.DruidSelectParser.changeSql(DruidSelectParser.java:287)
      3. io.mycat.route.parser.druid.impl.DefaultDruidParser.parser(DefaultDruidParser.java:67)
      4. io.mycat.route.impl.DruidMycatRouteStrategy.routeNormalSqlWithAST(DruidMycatRouteStrategy.java:77)
      5. io.mycat.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:81)
      6. io.mycat.route.RouteService.route(RouteService.java:133)
      6 frames
    3. io.mycat.server
      ServerQueryHandler.query
      1. io.mycat.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:260)
      2. io.mycat.server.ServerConnection.execute(ServerConnection.java:209)
      3. io.mycat.server.handler.SelectHandler.handle(SelectHandler.java:105)
      4. io.mycat.server.ServerQueryHandler.query(ServerQueryHandler.java:79)
      4 frames
    4. 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:462)
      5. io.mycat.net.FrontendConnection.handle(FrontendConnection.java:444)
      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
    5. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame