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

    GitHub comment 1082#244283304

    GitHub | 3 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 963#227949179

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

    navicat 工具连接查询报错?

    GitHub | 3 weeks ago | aiaix
    java.sql.SQLNonTransientException: find no Route:SELECT * FROM `testdb1`.`goods` LIMIT 0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    按照mycat _in_action 第一次插入 insert into orders(id,customer_id) values(2,2); 报错

    GitHub | 2 years ago | luotianwen
    java.sql.SQLNonTransientException: can't find (root) parent sharding node for sql:INSERT INTO orders (id, customer_id) VALUES (2, 2)
  6. 0

    IBM Bluemix Error

    Stack Overflow | 11 months ago | Rahul Reddy K
    java.sql.SQLNonTransientException: Connection refused DSRA0010E: SQL State = 42502, Error Code = -438 [err] at com.ibm.db2.jcc.am.hd.a(hd.java:747) 2016-01-20T15:01:15.096-0500[App/0]ERR[err] at com.ibm.db2.jcc.am.hd.a(hd.java:66) 2016-01-20T15:01:15.097-0500[App/0]ERR[err] at com.ibm.db2.jcc.am.hd.a(hd.java:135) 2016-01-20T15:01:15.098-0500[App/0]ERR[err] at com.ibm.db2.jcc.t4.y.q(y.java:859) 2016-01-20T15:01:15.098-0500[App/0]ERR[err] at com.ibm.db2.jcc.am.Connection.completeSqlca(Connection.java:5089) 2016-01-20T15:01:15.099-0500[App/0]ERR[err] at com.ibm.db2.jcc.t4.y.l(y.java:536) 2016-01-20T15:01:15.099-0500[App/0]ERR[err] at com.ibm.db2.jcc.t4.y.p(y.java:715) 2016-01-20T15:01:15.100-0500[App/0]ERR[err] at com.ibm.db2.jcc.t4.y.d(y.java:151) 2016-01-20T15:01:15.101-0500[App/0]ERR[err] at com.ibm.db2.jcc.t4.b.k(b.java:1385) 2016-01-20T15:01:15.101-0500[App/0]ERR[err] at com.ibm.db2.jcc.t4.b.b(b.java:1297) 2016-01-20T15:01:15.102-0500[App/0]ERR[err] at com.ibm.db2.jcc.t4.b.a(b.java:6426) 2016-01-20T15:01:15.103-0500[App/0]ERR[err] at com.ibm.db2.jcc.t4.b.a(b.java:764) 2016-01-20T15:01:15.103-0500[App/0]ERR[err] at com.ibm.db2.jcc.t4.b.b(b.java:847) 2016-01-20T15:01:15.104-0500[App/0]ERR[err] at com.ibm.db2.jcc.t4.b.a(b.java:422) 2016-01-20T15:01:15.104-0500[App/0]ERR[err] at com.ibm.db2.jcc.t4.b.a(b.java:397) 2016-01-20T15:01:15.105-0500[App/0]ERR[err] at com.ibm.db2.jcc.t4.b.<init>(b.java:335)

    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