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 | 5 months ago
  1. 0

    GitHub comment 1082#244283304

    GitHub | 5 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 | 1 month ago | gaojingsong
    java.sql.SQLNonTransientException: can't find table define in schema ID schema:TESTDB
  3. 0

    异常 find no Route

    GitHub | 1 month 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

  5. 0

    GitHub comment 963#227949179

    GitHub | 7 months ago | zzcclp
    java.sql.SQLNonTransientException: find no Route:SELECT * FROM `hdt_sys6`.`transport_statistics_5min` LIMIT 0
  6. 0

    navicat 工具连接查询报错?

    GitHub | 2 months ago | aiaix
    java.sql.SQLNonTransientException: find no Route:SELECT * FROM `testdb1`.`goods` LIMIT 0

    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.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