Mycat2 icon indicating copy to clipboard operation
Mycat2 copied to clipboard

单库分表,查询日志报错

Open fengweifang opened this issue 3 years ago • 1 comments

单库分表,错误日志

INFO | jvm 1 | 2022/04/18 19:20:28 | 2022-04-18 19:20:28,495[ERROR]io.mycat.sqlhandler.ShardingSQLHandler.onExecute:61SELECT * INFO | jvm 1 | 2022/04/18 19:20:28 | FROM db_name.table_1 INFO | jvm 1 | 2022/04/18 19:20:28 | LIMIT 10 INFO | jvm 1 | 2022/04/18 19:20:28 | org.apache.calcite.runtime.CalciteContextException: At line 0, column 0: Object 'table_1' not found within 'db_name';

table表已在物理库中删除,table_1在屋里库中存在,且已查出10条数据,但是日志中报table_1不存在,逻辑库中有table逻辑表

是我哪里配置有问题吗?

fengweifang avatar Apr 19 '22 02:04 fengweifang

table_1要配置成逻辑表(单表)才可以被mycat访问

junwen12221 avatar Apr 19 '22 06:04 junwen12221