登峰造Geek 2016-01-07 01:00 采纳率: 0%
浏览 2014

amoeba路由报错,但信息能正常查询

问题:最近将ecshop与amoeba进行结合,修改了部分ecshop的insert语句,因为不符合amoeba的要求,但是在做查询时,出现路由错误,如下异常:
2016-01-07 08:36:04,941 ERROR route.AbstractQueryRouter - SELECT id, number, type FROM wdsl.ecs_template WHERE filename = 'flow' AND type > 0 AND remarks ='' AND theme='newtemps'
com.meidusa.amoeba.parser.ParseException: com.meidusa.amoeba.mysql.parser.sql.ParseException: Encountered "number" at line 1, column 12.
Was expecting one of:
"SELECT" ...
"(" ...
"(" ...

at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.doParse(MysqlParser.java:117)
at com.meidusa.amoeba.route.SqlBaseQueryRouter.parseStatement(SqlBaseQueryRouter.java:138)
at com.meidusa.amoeba.mysql.handler.MySqlCommandDispatcher.handleQueryCommandMessage(MySqlCommandDispatcher.java:73)
at com.meidusa.amoeba.mysql.handler.MySqlCommandDispatcher$1.run(MySqlCommandDispatcher.java:246)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.meidusa.amoeba.mysql.parser.sql.ParseException: Encountered "number" at line 1, column 12.
Was expecting one of:
"SELECT" ...
"(" ...
"(" ...

at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.generateParseException(MysqlParser.java:5848)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.jj_consume_token(MysqlParser.java:5718)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SelectItem(MysqlParser.java:2033)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SelectList(MysqlParser.java:1980)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SelectClause(MysqlParser.java:1943)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SubSelectStatement(MysqlParser.java:1734)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.FullSelectStatement(MysqlParser.java:1681)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SelectQuery(MysqlParser.java:1309)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.parserInner(MysqlParser.java:355)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.parse(MysqlParser.java:268)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.doParse(MysqlParser.java:114)
... 6 more
但是结果可以正常显示,就是比ecshop直连mysql要慢1秒左右,每次刷新页面,amoeba的错误日志能到600行。麻烦有没有做过amoeba的人事帮忙看一下

  • 写回答

1条回答 默认 最新

  • devmiao 2016-01-20 21:10
    关注
    评论

报告相同问题?

悬赏问题

  • ¥15 kafka 分区副本增加会导致消息丢失或者不可用吗?
  • ¥15 微信公众号自制会员卡没有收款渠道啊
  • ¥15 stable diffusion
  • ¥100 Jenkins自动化部署—悬赏100元
  • ¥15 关于#python#的问题:求帮写python代码
  • ¥20 MATLAB画图图形出现上下震荡的线条
  • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘
  • ¥15 perl MISA分析p3_in脚本出错
  • ¥15 k8s部署jupyterlab,jupyterlab保存不了文件
  • ¥15 ubuntu虚拟机打包apk错误