Druid 监控 报错

_帅的被人砍 发布于 2013/02/07 11:27
阅读 1K+
收藏 0

@wenshao  你好~

点击SQL List 其中一个 报错 ,请问怎么处理 谢谢~

com.alibaba.druid.sql.parser.SQLParseException: syntax error, expect RPAREN, actual ORDER order
	com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:121)
	com.alibaba.druid.sql.dialect.oracle.parser.OracleSelectParser.select(OracleSelectParser.java:102)
	com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parseStatementList(OracleStatementParser.java:197)
	com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parseStatementList(OracleStatementParser.java:134)
	com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:68)
	com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:223)
	com.alibaba.druid.stat.DruidStatService.getSqlStat(DruidStatService.java:271)
	com.alibaba.druid.stat.DruidStatService.service(DruidStatService.java:126)
	com.alibaba.druid.support.http.StatViewServlet.service(StatViewServlet.java:245)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:94)

加载中
0
wenshao
wenshao
我测试了,0.2.11也存在此问题,问题已经修正,将会在下个版本中发布解决,下个版本大约在下周发布。
_帅的被人砍
_帅的被人砍
非常感谢!
0
_帅的被人砍
_帅的被人砍
@红薯  帮忙看一下~谢谢 挺急的~
_帅的被人砍
_帅的被人砍
回复 @红薯 : 哦~谢谢 新年快乐~
红薯
红薯
我没用过它的监控功能,现在放假期间,耐心等待
0
wenshao
wenshao

请提供以下信息:

1) druid版本号

2) 产生错误的SQL

3) 数据库类型,比如说是mysql/oracle/postgres等

0
_帅的被人砍
_帅的被人砍
@wenshao druid 版本号0.2.6, 数据库类型:oracle 11g, 产生错误的SQL :WITH a AS (SELECT TO_CHAR(csl.create_time,'yyyyMMdd') create_time, cwl.client_key ck, csl.src_id src_id FROM xxxx csl, xxxx cwl WHERE 1 =1 AND csl.src_id = cwl.src_id AND csl.curr_url = cwl.curr_url AND TO_CHAR(csl.create_time,'yyyyMMdd') BETWEEN ? AND ? AND cwl.day = TO_CHAR(csl.create_time,'yyyyMMdd') GROUP BY cwl.client_key, csl.src_id, csl.create_time ORDER BY csl.src_id ), b AS (SELECT itn.buyerpaytime, itn.esc_orderid, itn.oldck, MAX(con.PAYED_AMOUNT) gmv, MAX(con.buyer_onlyid) buyer FROM xxxx itn, xxxx don, xxxx con WHERE don.esc_orderid = itn.esc_orderid AND con.esc_orderid = itn.esc_orderid AND don.order_status IN (4,5,6,7,8) AND itn.buyerpaytime BETWEEN ? AND ? GROUP BY itn.esc_orderid, itn.oldck, itn.buyerpaytime ) SELECT MAX(cos.location) AS position , a.src_id AS srcid , COUNT(DISTINCT b.esc_orderid) AS orders , SUM(b.gmv) AS uvGmv, COUNT(DISTINCT buyer) AS buyers FROM a, b, cp_operate_statistics cos WHERE a.ck = b.oldck(+) AND TO_CHAR(cos.day,'yyyyMMdd') = a.create_time AND a.create_time = b.buyerpaytime AND a.src_id = cos.src_id GROUP BY a.src_id ORDER BY a.src_id
返回顶部
顶部