最新文章专题视频专题问答1问答10问答100问答1000问答2000关键字专题1关键字专题50关键字专题500关键字专题1500TAG最新视频文章推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37视频文章20视频文章30视频文章40视频文章50视频文章60 视频文章70视频文章80视频文章90视频文章100视频文章120视频文章140 视频2关键字专题关键字专题tag2tag3文章专题文章专题2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章专题3
当前位置: 首页 - 科技 - 知识百科 - 正文

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

来源:动视网 责编:小采 时间:2020-11-09 16:52:37
文档

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

mysql-amoeba路由报错,但信息能正常查询:amoebamysql 问题:最近将ecshop与amoeba进行结合,修改了部分ecshop的insert语句,因为不符合amoeba的要求,但是在做查询时,出现路由错误,如下异常:2016-01-07 08:36:04,941 ERROR route.AbstractQueryRouter - SEL
推荐度:
导读mysql-amoeba路由报错,但信息能正常查询:amoebamysql 问题:最近将ecshop与amoeba进行结合,修改了部分ecshop的insert语句,因为不符合amoeba的要求,但是在做查询时,出现路由错误,如下异常:2016-01-07 08:36:04,941 ERROR route.AbstractQueryRouter - SEL


amoebamysql

问题:最近将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的人事帮忙看一下

文档

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

mysql-amoeba路由报错,但信息能正常查询:amoebamysql 问题:最近将ecshop与amoeba进行结合,修改了部分ecshop的insert语句,因为不符合amoeba的要求,但是在做查询时,出现路由错误,如下异常:2016-01-07 08:36:04,941 ERROR route.AbstractQueryRouter - SEL
推荐度:
  • 热门焦点

最新推荐

猜你喜欢

热门推荐

专题
Top