MyCATApache / Mycat-Server

GNU General Public License v2.0
9.5k stars 3.85k forks source link

err:java.sql.SQLNonTransientException: can't find table define in schema #2365

Open ethanxzw opened 4 years ago

ethanxzw commented 4 years ago

mycat后台一直不停打印WARN日志(一小时几百兆),内容如下: 2019-11-29 11:06:58.622 WARN [$_NIOREACTOR-5-RW] (io.mycat.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:307)) - ServerConnection [id=11, schema=ins0, host=10.11.17.222, user=root,txIsolation=3, autocommit=true, schema=ins0, executeSql=SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'ins0' ORDER BY TABLE_SCHEMA, TABLE_TYPE]SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'ins0' ORDER BY TABLE_SCHEMA, TABLE_TYPE err:java.sql.SQLNonTransientException: can't find table define in schema TABLES schema:ins0

2019-11-29 11:06:58.626 WARN [$_NIOREACTOR-5-RW] (io.mycat.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:307)) - ServerConnection [id=11, schema=ins0, host=10.11.17.222, user=root,txIsolation=3, autocommit=true, schema=ins0, executeSql=SELECT DISTINCT ROUTINE_SCHEMA, ROUTINE_NAME, PARAMS.PARAMETER FROM information_schema.ROUTINES LEFT JOIN ( SELECT SPECIFIC_SCHEMA, SPECIFIC_NAME, GROUP_CONCAT(CONCAT(DATA_TYPE, ' ', PARAMETER_NAME) ORDER BY ORDINAL_POSITION SEPARATOR ', ') PARAMETER, ROUTINE_TYPE FROM information_schema.PARAMETERS GROUP BY SPECIFIC_SCHEMA, SPECIFIC_NAME, ROUTINE_TYPE ) PARAMS ON ROUTINES.ROUTINE_SCHEMA = PARAMS.SPECIFIC_SCHEMA AND ROUTINES.ROUTINE_NAME = PARAMS.SPECIFIC_NAME AND ROUTINES.ROUTINE_TYPE = PARAMS.ROUTINE_TYPE WHERE ROUTINE_SCHEMA = 'ins0' ORDER BY ROUTINE_SCHEMA]SELECT DISTINCT ROUTINE_SCHEMA, ROUTINE_NAME, PARAMS.PARAMETER FROM information_schema.ROUTINES LEFT JOIN ( SELECT SPECIFIC_SCHEMA, SPECIFIC_NAME, GROUP_CONCAT(CONCAT(DATA_TYPE, ' ', PARAMETER_NAME) ORDER BY ORDINAL_POSITION SEPARATOR ', ') PARAMETER, ROUTINE_TYPE FROM information_schema.PARAMETERS GROUP BY SPECIFIC_SCHEMA, SPECIFIC_NAME, ROUTINE_TYPE ) PARAMS ON ROUTINES.ROUTINE_SCHEMA = PARAMS.SPECIFIC_SCHEMA AND ROUTINES.ROUTINE_NAME = PARAMS.SPECIFIC_NAME AND ROUTINES.ROUTINE_TYPE = PARAMS.ROUTINE_TYPE WHERE ROUTINE_SCHEMA = 'ins0' ORDER BY ROUTINE_SCHEMA err:java.sql.SQLNonTransientException: can't find table define in schema PARAMETERS schema:ins0

客户端登录mycat后,没有发现information_schema这个schema,请问这个是怎么生成的?

ethanxzw commented 4 years ago

发现用Navicat客户端连接mycat时就会一直提示上面描述问题,换成SQLyog客户端就没报错了。