mycat错误之 SQLNonTransientException: find no Route:SELECT * FROM `db_xichuan`.`info` LIMIT 0, 1000

最新推荐文章于 2024-04-18 01:00:00 发布

兮川

最新推荐文章于 2024-04-18 01:00:00 发布

阅读量3.1k

点赞数 2

分类专栏：后端文章标签： mycat SQLNonTransientException mycat异常

本文链接：https://blog.csdn.net/zc_ad/article/details/83540995

版权

本以为mycat基础配置会很简单，却被这个错误搞了两三天了，错误日志：

2018-10-30 14:05:55.128  WARN [$_NIOREACTOR-0-RW] (io.mycat.route.parser.druid.impl.DruidSelectParser.tryRoute(DruidSelectParser.java:436)) -  find no Route:SELECT * FROM `db_xichuan`.`info` LIMIT 0, 1000
2018-10-30 14:05:55.139  WARN [$_NIOREACTOR-0-RW] (io.mycat.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:281)) - ServerConnection [id=1, schema=db_xichuan, host=12.12.12.12, user=root,txIsolation=3, autocommit=true, schema=db_xichuan]SELECT * FROM `db_xichuan`.`info` LIMIT 0, 1000 err:java.sql.SQLNonTransientException:  find no Route:SELECT * FROM `db_xichuan`.`info` LIMIT 0, 1000
java.sql.SQLNonTransientException:  find no Route:SELECT * FROM `db_xichuan`.`info` LIMIT 0, 1000
	at io.mycat.route.parser.druid.impl.DruidSelectParser.tryRoute(D