amoeba 执行sql语句报错1064

半路出家当和尚 2017-07-31 04:20:09
环境:1台amoeba3.0.4(读写分离) 两个mysql5.6(主从)
问题1:客户端navicat用sql语句查询, 或者项目运行调用sql语句查询,(执行结果是正确的)出现错误
navicat报错信息:
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/*100,3), '%') AS `Percentage` FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=' at line 1
查看logs/router.log
2017-07-31 16:12:10,679 ERROR route.AbstractQueryRouter - SELECT STATE AS `Status`, ROUND(SUM(DURATION),7) AS `Duration`, CONCAT(ROUND(SUM(DURATION)/*100,3), '%') AS `Percentage` FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID= GROUP BY STATE ORDER BY SEQ;
com.meidusa.amoeba.parser.ParseException: com.meidusa.amoeba.mysql.parser.sql.ParseException: Encountered "*" at line 1, column 92.
Was expecting one of:
"CASE" ...
"CAST" ...
"NULL" ...
"TRUE" ...
"FALSE" ...
"INTERVAL" ...
<INTEGER_LITERAL> ...
<FLOATING_POINT_LITERAL> ...
<IDENTIFIER> ...
<STRING_LITERAL> ...
<S_QUOTED_IDENTIFIER> ...
<S_COMMA_IDENTIFIER> ...
<S_PARAMETER_MARKER> ...
"(" ...
"`" ...
"+" ...
"-" ...
<IDENTIFIER> ...
"`" ...
<S_QUOTED_IDENTIFIER> ...
<S_COMMA_IDENTIFIER> ...
<IDENTIFIER> ...

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.route.SqlBaseQueryRouter.evaluateTable(SqlBaseQueryRouter.java:50)
at com.meidusa.amoeba.route.SqlBaseQueryRouter.evaluateTable(SqlBaseQueryRouter.java:1)
at com.meidusa.amoeba.route.AbstractQueryRouter.evaluate(AbstractQueryRouter.java:136)
at com.meidusa.amoeba.route.AbstractQueryRouter.selectPool(AbstractQueryRouter.java:411)
at com.meidusa.amoeba.mysql.parser.MysqlQueryRouter.selectPool(MysqlQueryRouter.java:59)
at com.meidusa.amoeba.mysql.parser.MysqlQueryRouter.selectPool(MysqlQueryRouter.java:1)
at com.meidusa.amoeba.route.AbstractQueryRouter.doRoute(AbstractQueryRouter.java:111)
at com.meidusa.amoeba.mysql.handler.MySqlCommandDispatcher.handleQueryCommandMessage(MySqlCommandDispatcher.java:98)
at com.meidusa.amoeba.mysql.handler.MySqlCommandDispatcher$1.run(MySqlCommandDispatcher.java:242)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.meidusa.amoeba.mysql.parser.sql.ParseException: Encountered "*" at line 1, column 92.
Was expecting one of:
"CASE" ...
"CAST" ...
"NULL" ...
"TRUE" ...
"FALSE" ...
"INTERVAL" ...
<INTEGER_LITERAL> ...
<FLOATING_POINT_LITERAL> ...
<IDENTIFIER> ...
<STRING_LITERAL> ...
<S_QUOTED_IDENTIFIER> ...
<S_COMMA_IDENTIFIER> ...
<S_PARAMETER_MARKER> ...
"(" ...
"`" ...
"+" ...
"-" ...
<IDENTIFIER> ...
"`" ...
<S_QUOTED_IDENTIFIER> ...
<S_COMMA_IDENTIFIER> ...
<IDENTIFIER> ...

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.SQLPrimaryExpression(MysqlParser.java:3305)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLUnaryExpression(MysqlParser.java:3106)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLMultiplicativeExpression(MysqlParser.java:3061)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLAddSubtractExpression(MysqlParser.java:2964)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLSimpleExpression(MysqlParser.java:2953)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLExpressionList(MysqlParser.java:2746)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.FunctionCall(MysqlParser.java:3359)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLPrimaryExpression(MysqlParser.java:3291)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLUnaryExpression(MysqlParser.java:3106)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLMultiplicativeExpression(MysqlParser.java:3025)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLAddSubtractExpression(MysqlParser.java:2964)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLSimpleExpression(MysqlParser.java:2953)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.OverloadedFunctionCall(MysqlParser.java:3452)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLPrimaryExpression(MysqlParser.java:3276)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLUnaryExpression(MysqlParser.java:3106)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLMultiplicativeExpression(MysqlParser.java:3025)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLAddSubtractExpression(MysqlParser.java:2964)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLSimpleExpression(MysqlParser.java:2953)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SelectItem(MysqlParser.java:2002)
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)
... 13 more



问题2:事件无法回滚

分析:在dos命令下做,查询等操作,无此报错信息!!!难道是跟Navicat不兼容?跟我的项目不兼容?

请大神请求支援!!
...全文
479 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

1,092

社区成员

发帖
与我相关
我的任务
社区描述
云计算服务器、网络、虚拟化相关讨论
社区管理员
  • 服务器
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧