Unknown column 'ROUTINE
155*****685 发布于2021-06 浏览:1146 回复:2
0
收藏

2021-06-01 16:19:31,005 WARN (doris-mysql-nio-pool-418|8911) [StmtExecutor.execute():399] execute Exception. {}
org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Unknown column 'ROUTINE_SCHEMA' in 'ROUTINES'
at org.apache.doris.common.ErrorReport.reportAnalysisException(ErrorReport.java:52) ~[palo-fe.jar:3.4.0]
at org.apache.doris.common.ErrorReport.reportAnalysisException(ErrorReport.java:47) ~[palo-fe.jar:3.4.0]
at org.apache.doris.analysis.Analyzer.registerColumnRef(Analyzer.java:625) ~[palo-fe.jar:3.4.0]
at org.apache.doris.analysis.SlotRef.analyzeImpl(SlotRef.java:139) ~[palo-fe.jar:3.4.0]
at org.apache.doris.analysis.Expr.analyze(Expr.java:384) ~[palo-fe.jar:3.4.0]
at org.apache.doris.analysis.Expr.trySubstitute(Expr.java:672) ~[palo-fe.jar:3.4.0]
at org.apache.doris.analysis.QueryStmt.substituteOrdinalsAliases(QueryStmt.java:403) ~[palo-fe.jar:3.4.0]
at org.apache.doris.analysis.QueryStmt.createSortInfo(QueryStmt.java:285) ~[palo-fe.jar:3.4.0]
at org.apache.doris.analysis.SelectStmt.analyze(SelectStmt.java:489) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.analyzeAndGenerateQueryPlan(StmtExecutor.java:559) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:529) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:310) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:284) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:206) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:344) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:545) ~[palo-fe.jar:3.4.0]
at org.apache.doris.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:50) ~[palo-fe.jar:3.4.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]

收藏
点赞
0
个赞
共2条回复 最后由Ling缪回复于2021-06
#3Ling缪回复于2021-06

这种错误一般出现在 用户发送了一个 不合法的 查询导致的。比如 查询了一个不存在的列

0
#2155*****685回复于2021-06

fe日志中一直抛这个异常 是啥原因呢?

0
快速回复
TOP
切换版块