sql单独执行没有问题， 在多条并发执行的query后，会爆出来下面的异常
我的java代码：
public JSONArray findApiStatistic(ApiRequest request) {
JSONArray jsonArray = null;
try {
KylinRepoDO kylinRepoDO = makeKylinRepoDO();
driver = kylinRepoDO.getDriver();
conn = driver.connect(aresDataSourceConfig.getUrl(),
kylinRepoDO.getProperties());
state = kylinRepoDO.getState();
logger.info(request.getSql());
rs = state.executeQuery(request.getSql());
String[] itemsArr = request.getItems().split(",");
jsonArray = new JSONArray();
while (rs.next()) {
JSONObject jsonObject = new JSONObject();
for (int i = 0; i < itemsArr.length; i++) {
jsonObject.put(itemsArr[i], rs.getString(i + 1));
}
jsonArray.add(jsonObject);
}
logger.info("project:" + request.getProject() + ", cube:" +
request.getCube() + ", items:" + jsonArray.size());
} catch (Exception e) {
logger.error("ApiKylinRepository.findApiStatistic meet
exception!", e);
} finally {
destroy(conn, state, rs);
}
if (null == jsonArray) {
logger.warn("query result is null!");
return null;
}
return jsonArray;
}
log:Ares 2017-03-07 09:06:09.023 ERROR 1 [2-51005-exec-12]
c.y.b.a.r.k.ApiKylinRepository : []
ApiKylinRepository.findApiStatistic meet exception!
log:
log:java.sql.SQLException: Statement did not return a result set
log: at
org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:60)
log: at
org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:210)
log: at
com.yiran.bigdata.ares.repository.kylin.ApiKylinRepository.findApiStatistic(ApiKylinRepository.java:37)
log: at
com.yiran.bigdata.ares.repository.kylin.ApiKylinRepository$$FastClassBySpringCGLIB$$cb58c343.invoke(<generated>)
log: at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
log: at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
log: at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
log: at
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
log: at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
log: at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
log: at
com.yiran.bigdata.ares.repository.kylin.ApiKylinRepository$$EnhancerBySpringCGLIB$$ed35dbdc.findApiStatistic(<generated>)
log: at
com.yiran.bigdata.ares.biz.api.impl.ApiStatisticServiceImpl.queryApiStatistic(ApiStatisticServiceImpl.java:23)
log: at
com.yiran.bigdata.ares.api.controller.ApiController.queryItemList(ApiController.java:46)
log: at
com.yiran.bigdata.ares.api.controller.ApiController$$FastClassBySpringCGLIB$$87241bd7.invoke(<generated>)
log: at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
log: at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
log: at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
log: at
org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
log: at
com.yiran.bigdata.ares.api.aop.SignAspect.validate(SignAspect.java:43)
log: at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
log: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
log: at java.lang.reflect.Method.invoke(Method.java:498)
log: at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
log: at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
log: at
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)
log: at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
log: at
com.yiran.bigdata.ares.api.aop.LoggerAspect.invoke(LoggerAspect.java:70)
log: at
com.yiran.bigdata.ares.api.aop.LoggerAspect.logerOut(LoggerAspect.java:58)
log: at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
log: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
log: at java.lang.reflect.Method.invoke(Method.java:498)
log: at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
log: at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
log: at
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)
log: at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
log: at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
log: at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
log: at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
log: at
com.yiran.bigdata.ares.api.controller.ApiController$$EnhancerBySpringCGLIB$$a5ee472.queryItemList(<generated>)
log: at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source)
log: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
log: at java.lang.reflect.Method.invoke(Method.java:498)
log: at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222)
log: at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
log: at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
log: at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:814)
log: at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:737)
log: at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
log: at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
log: at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
log: at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969)
log: at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:871)
log: at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
log: at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
log: at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
log: at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
log: at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
log: at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
log: at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
log: at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
log: at
com.dianping.cat.servlet.CatFilter$Context.handle(CatFilter.java:404)
log: at
com.dianping.cat.servlet.CatFilter$CatHandler$3.handle(CatFilter.java:219)
log: at
com.dianping.cat.servlet.CatFilter$Context.handle(CatFilter.java:402)
log: at
com.dianping.cat.servlet.CatFilter$CatHandler$4.handle(CatFilter.java:314)
log: at
com.dianping.cat.servlet.CatFilter$Context.handle(CatFilter.java:402)
log: at
com.dianping.cat.servlet.CatFilter$CatHandler$2.handle(CatFilter.java:202)
log: at
com.dianping.cat.servlet.CatFilter$Context.handle(CatFilter.java:402)
log: at
com.dianping.cat.servlet.CatFilter$CatHandler$1.handle(CatFilter.java:110)
log: at
com.dianping.cat.servlet.CatFilter$Context.handle(CatFilter.java:402)
log: at com.dianping.cat.servlet.CatFilter.doFilter(CatFilter.java:48)
log: at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
log: at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
log: at
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
log: at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
log: at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
log: at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
log: at
org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:87)
log: at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
log: at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
log: at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
log: at
org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
log: at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
log: at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
log: at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
log: at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
log: at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
log: at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
log: at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
log: at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
log: at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
log: at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
log: at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
log: at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
log: at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
log: at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:521)
log: at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)
log: at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)
log: at
org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1074)
log: at
org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.run(Nio2Endpoint.java:1033)
log: at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
log: at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
log: at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
log: at java.lang.Thread.run(Thread.java:745)
--
View this message in context:
http://apache-kylin.74782.x6.nabble.com/kylin-jdbc-meet-exception-tp7368.html
Sent from the Apache Kylin mailing list archive at Nabble.com.
