会员可以在此提问,百战程序员老师有问必答
对大家有帮助的问答会被标记为“推荐”
看完课程过来浏览一下别人提的问题,会帮你学得更全面
截止目前,同学们一共提了 132652个问题
Python 全系列/第一阶段:Python入门/编程基本概念 1351楼
JAVA 全系列/第三阶段:数据库编程/SQL 语言 1352楼
JAVA 全系列/第二阶段:JAVA 基础深化和提高/异常机制 1353楼
JAVA 全系列/(旧的隐藏)第七阶段:JAVA 高级技术/Dubbo 1355楼
JAVA 全系列/第七阶段:生产环境部署与协同开发/Linux 1357楼
Python 全系列/第一阶段:Python入门/编程基本概念 1358楼
Python 全系列/第四阶段:函数式编程和核心特性/函数式编程核心(高阶函数、闭包等) 1360楼

主从库可以,但在用mycat连接mysql时,无法查询到表信息,报错:数据无法操作,百度上的各种方法都试过了,还是不行啊【schame.xml上的配置没问题,与视频中的区别就是 逻辑库也用了 demo1,表是user】

image.png


以下是日志信息:

2020-07-22 18:50:32.528  INFO [$_NIOREACTOR-0-RW] (io.mycat.backend.datasource.PhysicalDBPool.initSource(PhysicalDBPool.java:319)) - init result :finished 0 success 0 target count:0

2020-07-22 18:50:32.528 ERROR [$_NIOREACTOR-0-RW] (io.mycat.backend.datasource.PhysicalDBPool.init(PhysicalDBPool.java:279)) - #!MyCat#localhost1 init failure

2020-07-22 18:50:32.528  WARN [$_NIOREACTOR-0-RW] (io.mycat.server.NonBlockingSession.execute(NonBlockingSession.java:135)) - ServerConnection [id=5, schema=demo1, host=192.168.2.1, user=root,txIsolation=3, autocommit=true, schema=demo1]SHOW CREATE TABLE user, route={

   1 -> dn1{SHOW CREATE TABLE user}

}

java.lang.IllegalArgumentException: Invalid DataSource:0

at io.mycat.backend.datasource.PhysicalDBNode.getConnection(PhysicalDBNode.java:140) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.backend.mysql.nio.handler.SingleNodeHandler.execute(SingleNodeHandler.java:182) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.server.NonBlockingSession.execute(NonBlockingSession.java:132) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:288) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.server.ServerConnection.execute(ServerConnection.java:222) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.server.handler.ShowHandler.handle(ShowHandler.java:60) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.server.ServerQueryHandler.query(ServerQueryHandler.java:76) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.net.FrontendConnection.query(FrontendConnection.java:317) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.net.FrontendConnection.query(FrontendConnection.java:337) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:71) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.net.FrontendConnection.rawHandle(FrontendConnection.java:478) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.net.FrontendConnection.handle(FrontendConnection.java:460) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.net.AbstractConnection.onReadData(AbstractConnection.java:321) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.net.NIOSocketWR.asynRead(NIOSocketWR.java:190) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.net.AbstractConnection.asynRead(AbstractConnection.java:273) ~[Mycat-server-1.6-RELEASE.jar:?]

at io.mycat.net.NIOReactor$RW.run(NIOReactor.java:102) ~[Mycat-server-1.6-RELEASE.jar:?]

at java.lang.Thread.run(Thread.java:748) [?:1.8.0_221]

2020-07-22 18:50:33.180  INFO [$_NIOREACTOR-0-RW] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:508)) - close connection,reason:quit cmd ,ServerConnection [id=7, schema=demo1, host=192.168.2.1, user=root,txIsolation=3, autocommit=true, schema=demo1]

2020-07-22 18:50:35.196  INFO [$_NIOConnector] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:508)) - close connection,reason:java.net.NoRouteToHostException: 没有到主机的路由 ,MySQLConnection [id=0, lastTime=1595415032113, user=root, schema=demo1, old shema=demo1, borrowed=false, fromSlaveDB=false, threadId=0, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=null, host=192.168.2.120, port=3306, statusSync=null, writeQueue=0, modifiedSQLExecuted=false]

2020-07-22 18:50:35.196  INFO [$_NIOConnector] (io.mycat.sqlengine.SQLJob.connectionError(SQLJob.java:114)) - can't get connection for sql :select user()

2020-07-22 18:50:35.196  INFO [$_NIOConnector] (io.mycat.backend.datasource.PhysicalDatasource.getConnection(PhysicalDatasource.java:413)) - no ilde connection in pool,create new connection for host1 of schema demo1

2020-07-22 18:50:35.197  INFO [$_NIOConnector] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:508)) - close connection,reason:java.net.NoRouteToHostException: 没有到主机的路由 ,MySQLConnection [id=0, lastTime=1595415032113, user=root, schema=demo1, old shema=demo1, borrowed=false, fromSlaveDB=true, threadId=0, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=null, host=192.168.2.121, port=3306, statusSync=null, writeQueue=0, modifiedSQLExecuted=false]

2020-07-22 18:50:35.197  INFO [$_NIOConnector] (io.mycat.sqlengine.SQLJob.connectionError(SQLJob.java:114)) - can't get connection for sql :select user()

2020-07-22 18:50:35.197  INFO [$_NIOConnector] (io.mycat.backend.datasource.PhysicalDatasource.getConnection(PhysicalDatasource.java:413)) - no ilde connection in pool,create new connection for host2 of schema demo1

[root@localhost logs]#


JAVA 全系列/第十三阶段:高性能数据处理、NoSQL、分库分表/MyCat 1364楼
Python 全系列/第一阶段:Python入门/控制语句 1365楼

课程分类

百战程序员微信公众号

百战程序员微信小程序

©2014-2025百战汇智(北京)科技有限公司 All Rights Reserved 北京亦庄经济开发区科创十四街 赛蒂国际工业园
网站维护:百战汇智(北京)科技有限公司
京公网安备 11011402011233号    京ICP备18060230号-3    营业执照    经营许可证:京B2-20212637