[ https://issues.apache.org/jira/browse/DRILL-4430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15166769#comment-15166769 ]
abhishek agrawal commented on DRILL-4430: ----------------------------------------- 20:30:25,430 INFO [org.apache.drill.common.config.DrillConfig] (http--0.0.0.0-8080-1) Configuration and plugin file(s) identified in 78ms. Base Configuration: - vfs:/content/Services.war/WEB-INF/lib/drill-common-1.5.0.jar/drill-default.conf Intermediate Configuration and Plugin files, in order of precedence: - vfs:/content/Services.war/WEB-INF/lib/drill-common-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-memory-base-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-logical-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-java-exec-1.5.0.jar/drill-module.conf 20:30:25,452 INFO [org.apache.drill.common.config.DrillConfig] (http--0.0.0.0-8080-1) Configuration and plugin file(s) identified in 9ms. Base Configuration: - vfs:/content/Services.war/WEB-INF/lib/drill-common-1.5.0.jar/drill-default.conf Intermediate Configuration and Plugin files, in order of precedence: - vfs:/content/Services.war/WEB-INF/lib/drill-common-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-memory-base-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-logical-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-java-exec-1.5.0.jar/drill-module.conf 20:30:25,585 INFO [org.apache.drill.common.config.DrillConfig] (http--0.0.0.0-8080-1) Configuration and plugin file(s) identified in 13ms. Base Configuration: - vfs:/content/Services.war/WEB-INF/lib/drill-common-1.5.0.jar/drill-default.conf Intermediate Configuration and Plugin files, in order of precedence: - vfs:/content/Services.war/WEB-INF/lib/drill-common-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-memory-base-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-logical-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-java-exec-1.5.0.jar/drill-module.conf 20:30:25,633 INFO [org.apache.curator.framework.imps.CuratorFrameworkImpl] (http--0.0.0.0-8080-1) Starting 20:30:25,641 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:zookeeper.version=3.4.6-1569965, built on 02/20/2014 09:09 GMT 20:30:25,641 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:host.name=INBBRDSSVM265 20:30:25,641 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:java.version=1.7.0_91 20:30:25,642 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:java.vendor=Oracle Corporation 20:30:25,642 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:java.home=/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.91.x86_64/jre 20:30:25,643 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:java.class.path=/u01/CIIRetail/retailuser/installedSoftware/jboss-as-7.1.1.Final/jboss-modules.jar 20:30:25,643 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib 20:30:25,644 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:java.io.tmpdir=/tmp 20:30:25,644 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:java.compiler=<NA> 20:30:25,644 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:os.name=Linux 20:30:25,645 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:os.arch=amd64 20:30:25,645 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:os.version=2.6.32-573.8.1.el6.x86_64 20:30:25,645 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:user.name=retailuser 20:30:25,646 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:user.home=/u01/CIIRetail/retailuser 20:30:25,647 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Client environment:user.dir=/u01/CIIRetail/retailuser/installedSoftware/jboss-as-7.1.1.Final/bin 20:30:25,648 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Initiating client connection, connectString=172.18.129.2:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@42d1a0c9 20:30:25,690 WARN [org.apache.zookeeper.client.ZooKeeperSaslClient] (http--0.0.0.0-8080-1-SendThread(172.18.129.2:2181)) Could not login: the client is being asked for a password, but the Zookeeper client code does not currently support obtaining a password from the user. Make sure that the client is configured to use a ticket cache (using the JAAS configuration setting 'useTicketCache=true)' and restart the client. If you still get this message after that, the TGT in the ticket cache has expired and must be manually refreshed. To do so, first determine if you are using a password or a keytab. If the former, run kinit in a Unix shell in the environment of the user who is running this Zookeeper client using the command 'kinit <princ>' (where <princ> is the name of the client's Kerberos principal). If the latter, do 'kinit -k -t <keytab> <princ>' (where <princ> is the name of the Kerberos principal, and <keytab> is the location of the keytab file). After manually refreshing your cache, restart this client. If you continue to see this message after manually refreshing your cache, ensure that your KDC host's clock is in sync with this host's clock. 20:30:25,694 WARN [org.apache.zookeeper.ClientCnxn] (http--0.0.0.0-8080-1-SendThread(172.18.129.2:2181)) SASL configuration failed: javax.security.auth.login.LoginException: java.lang.NullPointerException at org.jboss.as.security.RealmUsersRolesLoginModule.createPasswordHash(RealmUsersRolesLoginModule.java:42) at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:247) at org.jboss.security.auth.spi.UsersRolesLoginModule.login(UsersRolesLoginModule.java:155) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at javax.security.auth.login.LoginContext.invoke(LoginContext.java:762) at javax.security.auth.login.LoginContext.access$000(LoginContext.java:203) at javax.security.auth.login.LoginContext$4.run(LoginContext.java:690) at javax.security.auth.login.LoginContext$4.run(LoginContext.java:688) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:687) at javax.security.auth.login.LoginContext.login(LoginContext.java:595) at org.apache.zookeeper.Login.login(Login.java:292) at org.apache.zookeeper.Login.<init>(Login.java:93) at org.apache.zookeeper.client.ZooKeeperSaslClient.createSaslClient(ZooKeeperSaslClient.java:226) at org.apache.zookeeper.client.ZooKeeperSaslClient.<init>(ZooKeeperSaslClient.java:131) at org.apache.zookeeper.ClientCnxn$SendThread.startConnect(ClientCnxn.java:949) at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1003) Will continue connection to Zookeeper server without SASL authentication, if Zookeeper server allows it. 20:30:25,700 INFO [org.apache.zookeeper.ClientCnxn] (http--0.0.0.0-8080-1-SendThread(172.18.129.2:2181)) Opening socket connection to server 172.18.129.2/172.18.129.2:2181 20:30:25,703 ERROR [org.apache.curator.ConnectionState] (http--0.0.0.0-8080-1-EventThread) Authentication failed 20:30:25,709 INFO [org.apache.zookeeper.ClientCnxn] (http--0.0.0.0-8080-1-SendThread(172.18.129.2:2181)) Socket connection established to 172.18.129.2/172.18.129.2:2181, initiating session 20:30:25,728 INFO [org.apache.zookeeper.ClientCnxn] (http--0.0.0.0-8080-1-SendThread(172.18.129.2:2181)) Session establishment complete on server 172.18.129.2/172.18.129.2:2181, sessionid = 0x152f9e814750021, negotiated timeout = 40000 20:30:25,731 INFO [org.apache.curator.framework.state.ConnectionStateManager] (http--0.0.0.0-8080-1-EventThread) State change: CONNECTED 20:30:26,997 ERROR [org.apache.drill.exec.rpc.RpcExceptionHandler] (Client-1) Exception in RPC communication. Connection: /172.18.129.2:39671 <--> INBBRDSSVM265/172.18.129.2:31010 (user client). Closing connection. 20:30:26,998 INFO [org.apache.drill.exec.rpc.user.UserClient] (Client-1) Channel closed /172.18.129.2:39671 <--> INBBRDSSVM265/172.18.129.2:31010. 20:30:27,004 INFO [org.apache.drill.exec.rpc.user.QueryResultHandler] (Client-1) User Error Occurred: org.apache.drill.common.exceptions.UserException: CONNECTION ERROR: Connection /172.18.129.2:39671 <--> INBBRDSSVM265/172.18.129.2:31010 (user client) closed unexpectedly. [Error Id: 13ff97ca-0def-4833-8f6d-ec7386edee31 ] at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:543) [drill-common-1.5.0.jar:1.5.0] at org.apache.drill.exec.rpc.user.QueryResultHandler$SubmissionListener$ChannelClosedListener.operationComplete(QueryResultHandler.java:299) [drill-java-exec-1.5.0.jar:1.5.0] at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.util.concurrent.DefaultPromise.trySuccess(DefaultPromise.java:406) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.DefaultChannelPromise.trySuccess(DefaultChannelPromise.java:82) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannel$CloseFuture.setClosed(AbstractChannel.java:956) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannel$AbstractUnsafe.doClose0(AbstractChannel.java:608) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannel$AbstractUnsafe.close(AbstractChannel.java:586) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.DefaultChannelPipeline$HeadContext.close(DefaultChannelPipeline.java:1107) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:543) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:528) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.ChannelOutboundHandlerAdapter.close(ChannelOutboundHandlerAdapter.java:71) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:543) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:528) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.ChannelDuplexHandler.close(ChannelDuplexHandler.java:73) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:543) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:528) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:394) [netty-all-4.0.29.Final.jar:4.0.29.Final] at org.apache.drill.exec.rpc.RpcExceptionHandler.exceptionCaught(RpcExceptionHandler.java:39) [drill-rpc-1.5.0.jar:1.5.0] at io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:246) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.fireExceptionCaught(AbstractChannelHandlerContext.java:224) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.ChannelInboundHandlerAdapter.exceptionCaught(ChannelInboundHandlerAdapter.java:131) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:246) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.notifyHandlerException(AbstractChannelHandlerContext.java:737) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:310) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:266) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:244) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:846) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) [netty-all-4.0.29.Final.jar:4.0.29.Final] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_91] 20:30:27,027 INFO [org.apache.drill.jdbc.impl.DrillResultSetImpl$ResultsListener] (Client-1) [#1] Query failed: 20:30:27,028 ERROR [stderr] (http--0.0.0.0-8080-1) java.sql.SQLException: exception while executing query: CONNECTION ERROR: Connection /172.18.129.2:39671 <--> INBBRDSSVM265/172.18.129.2:31010 (user client) closed unexpectedly. 20:30:27,029 ERROR [stderr] (http--0.0.0.0-8080-1) 20:30:27,029 ERROR [stderr] (http--0.0.0.0-8080-1) 20:30:27,029 ERROR [stderr] (http--0.0.0.0-8080-1) [Error Id: 13ff97ca-0def-4833-8f6d-ec7386edee31 ] 20:30:27,031 ERROR [stderr] (http--0.0.0.0-8080-1) at net.hydromatic.avatica.Helper.createException(Helper.java:40) 20:30:27,031 ERROR [stderr] (http--0.0.0.0-8080-1) at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:406) 20:30:27,032 ERROR [stderr] (http--0.0.0.0-8080-1) at net.hydromatic.avatica.AvaticaPreparedStatement.executeQuery(AvaticaPreparedStatement.java:77) 20:30:27,032 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.jdbc.impl.DrillPreparedStatementImpl.executeQuery(DrillPreparedStatementImpl.java:488) 20:30:27,033 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.util.DrillDataReader.fireExternalQuery(DrillDataReader.java:62) 20:30:27,036 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.util.DrillDataReader$$FastClassBySpringCGLIB$$70794315.invoke(<generated>) 20:30:27,037 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) 20:30:27,037 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) 20:30:27,038 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 20:30:27,038 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) 20:30:27,039 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,039 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) 20:30:27,040 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) 20:30:27,040 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) 20:30:27,041 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:27,041 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:27,042 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) 20:30:27,042 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) 20:30:27,043 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) 20:30:27,043 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,044 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) 20:30:27,044 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,045 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) 20:30:27,045 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,046 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) 20:30:27,046 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.util.DrillDataReader$$EnhancerBySpringCGLIB$$cd4667ba.fireExternalQuery(<generated>) 20:30:27,047 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.dao.DrillAdhocDaoImpl.queryForAdhocData(DrillAdhocDaoImpl.java:27) 20:30:27,047 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 20:30:27,048 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 20:30:27,048 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:27,049 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:27,049 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 20:30:27,050 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) 20:30:27,050 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 20:30:27,051 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) 20:30:27,051 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,052 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) 20:30:27,052 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) 20:30:27,053 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) 20:30:27,062 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:27,063 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:27,065 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) 20:30:27,066 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) 20:30:27,067 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) 20:30:27,067 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,068 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) 20:30:27,068 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,069 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) 20:30:27,073 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,073 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) 20:30:27,076 ERROR [stderr] (http--0.0.0.0-8080-1) at com.sun.proxy.$Proxy60.queryForAdhocData(Unknown Source) 20:30:27,076 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 20:30:27,076 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 20:30:27,077 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:27,078 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:27,078 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.AdhocFileSender.getAdhocResultSet(AdhocFileSender.java:157) 20:30:27,078 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.AdhocFileSender$$FastClassBySpringCGLIB$$dde03b98.invoke(<generated>) 20:30:27,079 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) 20:30:27,079 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) 20:30:27,080 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 20:30:27,081 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) 20:30:27,084 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,085 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) 20:30:27,086 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) 20:30:27,086 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) 20:30:27,086 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:27,087 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:27,087 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) 20:30:27,088 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) 20:30:27,088 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) 20:30:27,089 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,089 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) 20:30:27,090 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,090 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) 20:30:27,091 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,091 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) 20:30:27,092 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.AdhocFileSender$$EnhancerBySpringCGLIB$$4c4d8add.getAdhocResultSet(<generated>) 20:30:27,093 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.Adhocservice.getDesiredOutput(Adhocservice.java:123) 20:30:27,093 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.Adhocservice.getResult(Adhocservice.java:78) 20:30:27,094 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.Adhocservice.getAdhocResult(Adhocservice.java:53) 20:30:27,094 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.Adhocservice$$FastClassBySpringCGLIB$$14f1a7c4.invoke(<generated>) 20:30:27,095 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) 20:30:27,095 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) 20:30:27,096 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 20:30:27,096 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) 20:30:27,097 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,097 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) 20:30:27,098 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) 20:30:27,098 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) 20:30:27,099 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:27,099 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:27,099 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) 20:30:27,100 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) 20:30:27,100 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) 20:30:27,101 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,101 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) 20:30:27,102 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,102 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) 20:30:27,103 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,103 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) 20:30:27,104 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.Adhocservice$$EnhancerBySpringCGLIB$$e3e57d89.getAdhocResult(<generated>) 20:30:27,105 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.AdhocBaseFacade.executeAdhocServiceInput(AdhocBaseFacade.java:90) 20:30:27,105 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.facade.Adhoc.getAdhocResults(Adhoc.java:62) 20:30:27,105 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.facade.Adhoc$$FastClassBySpringCGLIB$$807611e.invoke(<generated>) 20:30:27,106 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) 20:30:27,106 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) 20:30:27,107 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 20:30:27,107 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) 20:30:27,108 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,108 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) 20:30:27,109 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) 20:30:27,109 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) 20:30:27,110 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:27,110 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:27,110 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) 20:30:27,111 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) 20:30:27,111 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) 20:30:27,112 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,113 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) 20:30:27,113 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,114 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) 20:30:27,114 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:266) 20:30:27,115 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) 20:30:27,115 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,116 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) 20:30:27,116 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:27,117 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) 20:30:27,117 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.facade.Adhoc$$EnhancerBySpringCGLIB$$18297250.getAdhocResults(<generated>) 20:30:27,118 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 20:30:27,118 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 20:30:27,118 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:27,119 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:27,119 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) 20:30:27,120 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) 20:30:27,120 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) 20:30:27,121 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:781) 20:30:27,121 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:721) 20:30:27,122 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83) 20:30:27,122 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943) 20:30:27,123 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877) 20:30:27,124 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961) 20:30:27,124 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863) 20:30:27,124 ERROR [stderr] (http--0.0.0.0-8080-1) at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) 20:30:27,125 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837) 20:30:27,125 ERROR [stderr] (http--0.0.0.0-8080-1) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) 20:30:27,126 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) 20:30:27,126 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 20:30:27,127 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.filters.CorsFilter.handleSimpleCORS(CorsFilter.java:302) 20:30:27,127 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:170) 20:30:27,127 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) 20:30:27,128 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 20:30:27,128 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.core.audit.util.AuditFilter.doFilterInternal(AuditFilter.java:55) 20:30:27,129 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 20:30:27,129 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) 20:30:27,130 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) 20:30:27,130 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) 20:30:27,131 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 20:30:27,131 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) 20:30:27,132 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) 20:30:27,132 ERROR [stderr] (http--0.0.0.0-8080-1) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) 20:30:27,133 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) 20:30:27,133 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 20:30:27,134 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 20:30:27,134 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) 20:30:27,135 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) 20:30:27,135 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) 20:30:27,135 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) 20:30:27,136 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.Thread.run(Thread.java:745) 20:30:27,137 ERROR [stderr] (http--0.0.0.0-8080-1) Caused by: java.sql.SQLException: CONNECTION ERROR: Connection /172.18.129.2:39671 <--> INBBRDSSVM265/172.18.129.2:31010 (user client) closed unexpectedly. 20:30:27,137 ERROR [stderr] (http--0.0.0.0-8080-1) 20:30:27,138 ERROR [stderr] (http--0.0.0.0-8080-1) 20:30:27,138 ERROR [stderr] (http--0.0.0.0-8080-1) [Error Id: 13ff97ca-0def-4833-8f6d-ec7386edee31 ] 20:30:27,138 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:247) 20:30:27,138 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:290) 20:30:27,139 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1923) 20:30:27,139 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:73) 20:30:27,140 ERROR [stderr] (http--0.0.0.0-8080-1) at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404) 20:30:27,140 ERROR [stderr] (http--0.0.0.0-8080-1) ... 166 more 20:30:27,141 ERROR [stderr] (http--0.0.0.0-8080-1) Caused by: org.apache.drill.common.exceptions.UserException: CONNECTION ERROR: Connection /172.18.129.2:39671 <--> INBBRDSSVM265/172.18.129.2:31010 (user client) closed unexpectedly. 20:30:27,142 ERROR [stderr] (http--0.0.0.0-8080-1) 20:30:27,142 ERROR [stderr] (http--0.0.0.0-8080-1) 20:30:27,142 ERROR [stderr] (http--0.0.0.0-8080-1) [Error Id: 13ff97ca-0def-4833-8f6d-ec7386edee31 ] 20:30:27,142 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:543) 20:30:27,143 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.exec.rpc.user.QueryResultHandler$SubmissionListener$ChannelClosedListener.operationComplete(QueryResultHandler.java:299) 20:30:27,143 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680) 20:30:27,144 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603) 20:30:27,144 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563) 20:30:27,145 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.util.concurrent.DefaultPromise.trySuccess(DefaultPromise.java:406) 20:30:27,145 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.DefaultChannelPromise.trySuccess(DefaultChannelPromise.java:82) 20:30:27,145 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannel$CloseFuture.setClosed(AbstractChannel.java:956) 20:30:27,146 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannel$AbstractUnsafe.doClose0(AbstractChannel.java:608) 20:30:27,146 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannel$AbstractUnsafe.close(AbstractChannel.java:586) 20:30:27,147 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.DefaultChannelPipeline$HeadContext.close(DefaultChannelPipeline.java:1107) 20:30:27,147 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:543) 20:30:27,148 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:528) 20:30:27,148 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.ChannelOutboundHandlerAdapter.close(ChannelOutboundHandlerAdapter.java:71) 20:30:27,149 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:543) 20:30:27,149 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:528) 20:30:27,150 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.ChannelDuplexHandler.close(ChannelDuplexHandler.java:73) 20:30:27,150 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:543) 20:30:27,151 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:528) 20:30:27,151 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:394) 20:30:27,152 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.exec.rpc.RpcExceptionHandler.exceptionCaught(RpcExceptionHandler.java:39) 20:30:27,152 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:246) 20:30:27,153 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.fireExceptionCaught(AbstractChannelHandlerContext.java:224) 20:30:27,153 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.ChannelInboundHandlerAdapter.exceptionCaught(ChannelInboundHandlerAdapter.java:131) 20:30:27,154 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:246) 20:30:27,155 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.notifyHandlerException(AbstractChannelHandlerContext.java:737) 20:30:27,155 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:310) 20:30:27,156 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) 20:30:27,156 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:266) 20:30:27,156 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) 20:30:27,157 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) 20:30:27,157 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) 20:30:27,158 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) 20:30:27,158 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) 20:30:27,159 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:244) 20:30:27,159 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) 20:30:27,160 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) 20:30:27,160 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) 20:30:27,161 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) 20:30:27,161 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) 20:30:27,162 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:846) 20:30:27,162 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) 20:30:27,163 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511) 20:30:27,163 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468) 20:30:27,164 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382) 20:30:27,164 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354) 20:30:27,165 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) 20:30:27,165 ERROR [stderr] (http--0.0.0.0-8080-1) ... 1 more 20:30:27,166 ERROR [com.abc.xyz.service.adhoc.util.DrillDataReader] (http--0.0.0.0-8080-1) java.sql.SQLException: exception while executing query: CONNECTION ERROR: Connection /172.18.129.2:39671 <--> INBBRDSSVM265/172.18.129.2:31010 (user client) closed unexpectedly. [Error Id: 13ff97ca-0def-4833-8f6d-ec7386edee31 ] 20:30:27,175 WARN [org.apache.drill.jdbc.DrillConnection] (http--0.0.0.0-8080-1) Exception while closing client.: java.lang.RuntimeException: Exception while closing at org.apache.drill.common.DrillAutoCloseables.closeNoChecked(DrillAutoCloseables.java:46) [drill-common-1.5.0.jar:1.5.0] at org.apache.drill.exec.client.DrillClient.close(DrillClient.java:284) [drill-java-exec-1.5.0.jar:1.5.0] at org.apache.drill.jdbc.impl.DrillConnectionImpl.closeOrWarn(DrillConnectionImpl.java:781) [drill-jdbc-1.5.0.jar:1.5.0] at org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(DrillConnectionImpl.java:794) [drill-jdbc-1.5.0.jar:1.5.0] at org.apache.drill.jdbc.impl.DrillHandler.onConnectionClose(DrillHandler.java:36) [drill-jdbc-1.5.0.jar:1.5.0] at net.hydromatic.avatica.AvaticaConnection.close(AvaticaConnection.java:135) [Metadata-ExtDS-IUX-1.0.jar:] at com.abc.xyz.service.adhoc.util.DrillDataReader.fireExternalQuery(DrillDataReader.java:88) [classes:] at com.abc.xyz.service.adhoc.util.DrillDataReader$$FastClassBySpringCGLIB$$70794315.invoke(<generated>) [spring-core-4.1.0.RELEASE.jar:] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [spring-core-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) [classes:] at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) [:1.7.0_91] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_91] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_91] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at com.abc.xyz.service.adhoc.util.DrillDataReader$$EnhancerBySpringCGLIB$$cd4667ba.fireExternalQuery(<generated>) [spring-core-4.1.0.RELEASE.jar:] at com.abc.xyz.service.adhoc.dao.DrillAdhocDaoImpl.queryForAdhocData(DrillAdhocDaoImpl.java:27) [classes:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_91] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_91] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_91] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_91] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) [classes:] at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) [:1.7.0_91] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_91] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_91] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at com.sun.proxy.$Proxy60.queryForAdhocData(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_91] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_91] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_91] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_91] at com.abc.xyz.service.adhoc.service.AdhocFileSender.getAdhocResultSet(AdhocFileSender.java:157) [classes:] at com.abc.xyz.service.adhoc.service.AdhocFileSender$$FastClassBySpringCGLIB$$dde03b98.invoke(<generated>) [spring-core-4.1.0.RELEASE.jar:] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [spring-core-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) [classes:] at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) [:1.7.0_91] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_91] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_91] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at com.abc.xyz.service.adhoc.service.AdhocFileSender$$EnhancerBySpringCGLIB$$4c4d8add.getAdhocResultSet(<generated>) [spring-core-4.1.0.RELEASE.jar:] at com.abc.xyz.service.adhoc.service.Adhocservice.getDesiredOutput(Adhocservice.java:123) [classes:] at com.abc.xyz.service.adhoc.service.Adhocservice.getResult(Adhocservice.java:78) [classes:] at com.abc.xyz.service.adhoc.service.Adhocservice.getAdhocResult(Adhocservice.java:53) [classes:] at com.abc.xyz.service.adhoc.service.Adhocservice$$FastClassBySpringCGLIB$$14f1a7c4.invoke(<generated>) [spring-core-4.1.0.RELEASE.jar:] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [spring-core-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) [classes:] at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) [:1.7.0_91] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_91] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_91] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at com.abc.xyz.service.adhoc.service.Adhocservice$$EnhancerBySpringCGLIB$$e3e57d89.getAdhocResult(<generated>) [spring-core-4.1.0.RELEASE.jar:] at com.abc.xyz.service.adhoc.AdhocBaseFacade.executeAdhocServiceInput(AdhocBaseFacade.java:90) [classes:] at com.abc.xyz.service.adhoc.facade.Adhoc.getAdhocResults(Adhoc.java:62) [classes:] at com.abc.xyz.service.adhoc.facade.Adhoc$$FastClassBySpringCGLIB$$807611e.invoke(<generated>) [spring-core-4.1.0.RELEASE.jar:] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [spring-core-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) [classes:] at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) [:1.7.0_91] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_91] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_91] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) [spring-tx-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:266) [spring-tx-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) [spring-tx-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) [spring-aop-4.1.0.RELEASE.jar:4.1.0.RELEASE] at com.abc.xyz.service.adhoc.facade.Adhoc$$EnhancerBySpringCGLIB$$18297250.getAdhocResults(<generated>) [spring-core-4.1.0.RELEASE.jar:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_91] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_91] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_91] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_91] at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) [spring-web-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) [spring-web-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) [spring-webmvc-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:781) [spring-webmvc-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:721) [spring-webmvc-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83) [spring-webmvc-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943) [spring-webmvc-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877) [spring-webmvc-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961) [spring-webmvc-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863) [spring-webmvc-4.1.0.RELEASE.jar:4.1.0.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837) [spring-webmvc-4.1.0.RELEASE.jar:4.1.0.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.filters.CorsFilter.handleSimpleCORS(CorsFilter.java:302) [tomcat-catalina-7.0.55.jar:7.0.55] at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:170) [tomcat-catalina-7.0.55.jar:7.0.55] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:] at com.abc.xyz.service.core.audit.util.AuditFilter.doFilterInternal(AuditFilter.java:55) [classes:] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) [spring-web-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) [spring-web-4.1.0.RELEASE.jar:4.1.0.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:] at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_91] Caused by: java.lang.IllegalStateException: Memory was leaked by query. Memory leaked: (32) Allocator(ROOT) 0/32/4096/477102080 (res/actual/peak/limit) at org.apache.drill.exec.memory.BaseAllocator.close(BaseAllocator.java:492) [drill-memory-base-1.5.0.jar:1.5.0] at org.apache.drill.common.DrillAutoCloseables.closeNoChecked(DrillAutoCloseables.java:44) [drill-common-1.5.0.jar:1.5.0] ... 169 more 20:30:27,258 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAround() com.abc.xyz.service.adhoc.util.DrillDataReader.fireExternalQuery ##Timetaken## : 1939 20:30:27,259 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAfter() : com.abc.xyz.service.adhoc.util.DrillDataReader.fireExternalQuery 20:30:27,259 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAround() com.abc.xyz.service.adhoc.dao.AdhocDao.queryForAdhocData ##Timetaken## : 1941 20:30:27,260 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAfter() : com.abc.xyz.service.adhoc.dao.AdhocDao.queryForAdhocData 20:30:27,260 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAround() com.abc.xyz.service.adhoc.service.AdhocFileSender.getAdhocResultSet ##Timetaken## : 1948 20:30:27,261 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAfter() : com.abc.xyz.service.adhoc.service.AdhocFileSender.getAdhocResultSet 20:30:27,262 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAround() com.abc.xyz.service.adhoc.service.Adhocservice.getAdhocResult ##Timetaken## : 1973 20:30:27,262 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAfter() : com.abc.xyz.service.adhoc.service.Adhocservice.getAdhocResult 20:30:27,275 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAround() com.abc.xyz.service.adhoc.facade.Adhoc.getAdhocResults ##Timetaken## : 2218 20:30:27,276 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAfter() : com.abc.xyz.service.adhoc.facade.Adhoc.getAdhocResults 20:30:27,299 INFO [com.abc.xyz.service.core.util.LogAdvice] (SimpleAsyncTaskExecutor-1) logBefore() : com.abc.xyz.service.core.service.BaseService.saveAuditInfo 20:30:27,301 INFO [com.abc.xyz.service.core.util.LogAdvice] (SimpleAsyncTaskExecutor-1) logBefore() : com.abc.xyz.service.core.dao.OlapBaseDao.save 20:30:27,344 INFO [com.abc.xyz.service.core.util.LogAdvice] (SimpleAsyncTaskExecutor-1) logAround() com.abc.xyz.service.core.dao.OlapBaseDao.save ##Timetaken## : 44 20:30:27,344 INFO [com.abc.xyz.service.core.util.LogAdvice] (SimpleAsyncTaskExecutor-1) logAfter() : com.abc.xyz.service.core.dao.OlapBaseDao.save 20:30:27,345 INFO [com.abc.xyz.service.core.util.LogAdvice] (SimpleAsyncTaskExecutor-1) logAround() com.abc.xyz.service.core.service.BaseService.saveAuditInfo ##Timetaken## : 46 20:30:27,345 INFO [com.abc.xyz.service.core.util.LogAdvice] (SimpleAsyncTaskExecutor-1) logAfter() : com.abc.xyz.service.core.service.BaseService.saveAuditInfo 20:30:46,454 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logBefore() : com.abc.xyz.service.adhoc.facade.Adhoc.getAdhocResults 20:30:46,456 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logBefore() : com.abc.xyz.service.core.util.AdhocInitialQueryGenerator.getQueryOutOfAdhocInput 20:30:46,457 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAround() com.abc.xyz.service.core.util.AdhocInitialQueryGenerator.getQueryOutOfAdhocInput ##Timetaken## : 1 20:30:46,458 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAfter() : com.abc.xyz.service.core.util.AdhocInitialQueryGenerator.getQueryOutOfAdhocInput 20:30:46,459 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logBefore() : com.abc.xyz.service.core.util.AdhocInputValidator.validateAdhocInput 20:30:46,460 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logBefore() : com.abc.xyz.service.core.util.AdhocInputParser.createAliasEntityMap 20:30:46,461 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAround() com.abc.xyz.service.core.util.AdhocInputParser.createAliasEntityMap ##Timetaken## : 1 20:30:46,462 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAfter() : com.abc.xyz.service.core.util.AdhocInputParser.createAliasEntityMap 20:30:46,462 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAround() com.abc.xyz.service.core.util.AdhocInputValidator.validateAdhocInput ##Timetaken## : 3 20:30:46,463 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAfter() : com.abc.xyz.service.core.util.AdhocInputValidator.validateAdhocInput 20:30:46,464 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logBefore() : com.abc.xyz.service.adhoc.service.Adhocservice.getAdhocResult 20:30:46,464 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logBefore() : com.abc.xyz.service.core.util.AdhocInputParser.parseAdhocInput 20:30:46,465 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAround() com.abc.xyz.service.core.util.AdhocInputParser.parseAdhocInput ##Timetaken## : 1 20:30:46,466 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAfter() : com.abc.xyz.service.core.util.AdhocInputParser.parseAdhocInput 20:30:46,467 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logBefore() : com.abc.xyz.service.core.util.AdhocServiceQueryGenerator.getProcessingData 20:30:46,467 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAround() com.abc.xyz.service.core.util.AdhocServiceQueryGenerator.getProcessingData ##Timetaken## : 1 20:30:46,468 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logAfter() : com.abc.xyz.service.core.util.AdhocServiceQueryGenerator.getProcessingData 20:30:46,468 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logBefore() : com.abc.xyz.service.adhoc.service.AdhocFileSender.getAdhocResultSet 20:30:46,469 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logBefore() : com.abc.xyz.service.adhoc.dao.AdhocDao.queryForAdhocData 20:30:46,469 INFO [stdout] (http--0.0.0.0-8080-1) #####################################################SELECT T001.rev_amt , T001.trip_cd , T001.veh_nm , T001.rev_uom FROM hive.`d3_revenue` AS T001 LIMIT 5000 20:30:46,470 INFO [com.abc.xyz.service.core.util.LogAdvice] (http--0.0.0.0-8080-1) logBefore() : com.abc.xyz.service.adhoc.util.DrillDataReader.fireExternalQuery 20:30:46,482 INFO [org.apache.drill.common.config.DrillConfig] (http--0.0.0.0-8080-1) Configuration and plugin file(s) identified in 11ms. Base Configuration: - vfs:/content/Services.war/WEB-INF/lib/drill-common-1.5.0.jar/drill-default.conf Intermediate Configuration and Plugin files, in order of precedence: - vfs:/content/Services.war/WEB-INF/lib/drill-common-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-memory-base-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-logical-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-java-exec-1.5.0.jar/drill-module.conf 20:30:46,492 INFO [org.apache.drill.common.config.DrillConfig] (http--0.0.0.0-8080-1) Configuration and plugin file(s) identified in 5ms. Base Configuration: - vfs:/content/Services.war/WEB-INF/lib/drill-common-1.5.0.jar/drill-default.conf Intermediate Configuration and Plugin files, in order of precedence: - vfs:/content/Services.war/WEB-INF/lib/drill-common-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-memory-base-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-logical-1.5.0.jar/drill-module.conf - vfs:/content/Services.war/WEB-INF/lib/drill-java-exec-1.5.0.jar/drill-module.conf 20:30:46,501 INFO [org.apache.curator.framework.imps.CuratorFrameworkImpl] (http--0.0.0.0-8080-1) Starting 20:30:46,508 INFO [org.apache.zookeeper.ZooKeeper] (http--0.0.0.0-8080-1) Initiating client connection, connectString=172.18.129.2:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@220345f2 20:30:46,515 WARN [org.apache.zookeeper.client.ZooKeeperSaslClient] (http--0.0.0.0-8080-1-SendThread(172.18.129.2:2181)) Could not login: the client is being asked for a password, but the Zookeeper client code does not currently support obtaining a password from the user. Make sure that the client is configured to use a ticket cache (using the JAAS configuration setting 'useTicketCache=true)' and restart the client. If you still get this message after that, the TGT in the ticket cache has expired and must be manually refreshed. To do so, first determine if you are using a password or a keytab. If the former, run kinit in a Unix shell in the environment of the user who is running this Zookeeper client using the command 'kinit <princ>' (where <princ> is the name of the client's Kerberos principal). If the latter, do 'kinit -k -t <keytab> <princ>' (where <princ> is the name of the Kerberos principal, and <keytab> is the location of the keytab file). After manually refreshing your cache, restart this client. If you continue to see this message after manually refreshing your cache, ensure that your KDC host's clock is in sync with this host's clock. 20:30:46,519 WARN [org.apache.zookeeper.ClientCnxn] (http--0.0.0.0-8080-1-SendThread(172.18.129.2:2181)) SASL configuration failed: javax.security.auth.login.LoginException: java.lang.NullPointerException at org.jboss.as.security.RealmUsersRolesLoginModule.createPasswordHash(RealmUsersRolesLoginModule.java:42) at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:247) at org.jboss.security.auth.spi.UsersRolesLoginModule.login(UsersRolesLoginModule.java:155) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at javax.security.auth.login.LoginContext.invoke(LoginContext.java:762) at javax.security.auth.login.LoginContext.access$000(LoginContext.java:203) at javax.security.auth.login.LoginContext$4.run(LoginContext.java:690) at javax.security.auth.login.LoginContext$4.run(LoginContext.java:688) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:687) at javax.security.auth.login.LoginContext.login(LoginContext.java:595) at org.apache.zookeeper.Login.login(Login.java:292) at org.apache.zookeeper.Login.<init>(Login.java:93) at org.apache.zookeeper.client.ZooKeeperSaslClient.createSaslClient(ZooKeeperSaslClient.java:226) at org.apache.zookeeper.client.ZooKeeperSaslClient.<init>(ZooKeeperSaslClient.java:131) at org.apache.zookeeper.ClientCnxn$SendThread.startConnect(ClientCnxn.java:949) at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1003) Will continue connection to Zookeeper server without SASL authentication, if Zookeeper server allows it. 20:30:46,524 INFO [org.apache.zookeeper.ClientCnxn] (http--0.0.0.0-8080-1-SendThread(172.18.129.2:2181)) Opening socket connection to server 172.18.129.2/172.18.129.2:2181 20:30:46,524 ERROR [org.apache.curator.ConnectionState] (http--0.0.0.0-8080-1-EventThread) Authentication failed 20:30:46,525 INFO [org.apache.zookeeper.ClientCnxn] (http--0.0.0.0-8080-1-SendThread(172.18.129.2:2181)) Socket connection established to 172.18.129.2/172.18.129.2:2181, initiating session 20:30:46,542 INFO [org.apache.zookeeper.ClientCnxn] (http--0.0.0.0-8080-1-SendThread(172.18.129.2:2181)) Session establishment complete on server 172.18.129.2/172.18.129.2:2181, sessionid = 0x152f9e814750022, negotiated timeout = 40000 20:30:46,543 INFO [org.apache.curator.framework.state.ConnectionStateManager] (http--0.0.0.0-8080-1-EventThread) State change: CONNECTED 20:30:47,609 ERROR [org.apache.drill.exec.rpc.RpcExceptionHandler] (Client-1) Exception in RPC communication. Connection: /172.18.129.2:39687 <--> INBBRDSSVM265/172.18.129.2:31010 (user client). Closing connection. 20:30:47,614 INFO [org.apache.drill.exec.rpc.user.UserClient] (Client-1) Channel closed /172.18.129.2:39687 <--> INBBRDSSVM265/172.18.129.2:31010. 20:30:47,614 INFO [org.apache.drill.exec.rpc.user.QueryResultHandler] (Client-1) User Error Occurred: org.apache.drill.common.exceptions.UserException: CONNECTION ERROR: Connection /172.18.129.2:39687 <--> INBBRDSSVM265/172.18.129.2:31010 (user client) closed unexpectedly. [Error Id: 9bf8c48c-75b1-4967-8de3-8d69406f9730 ] at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:543) [drill-common-1.5.0.jar:1.5.0] at org.apache.drill.exec.rpc.user.QueryResultHandler$SubmissionListener$ChannelClosedListener.operationComplete(QueryResultHandler.java:299) [drill-java-exec-1.5.0.jar:1.5.0] at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.util.concurrent.DefaultPromise.trySuccess(DefaultPromise.java:406) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.DefaultChannelPromise.trySuccess(DefaultChannelPromise.java:82) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannel$CloseFuture.setClosed(AbstractChannel.java:956) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannel$AbstractUnsafe.doClose0(AbstractChannel.java:608) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannel$AbstractUnsafe.close(AbstractChannel.java:586) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.DefaultChannelPipeline$HeadContext.close(DefaultChannelPipeline.java:1107) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:543) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:528) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.ChannelOutboundHandlerAdapter.close(ChannelOutboundHandlerAdapter.java:71) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:543) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:528) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.ChannelDuplexHandler.close(ChannelDuplexHandler.java:73) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:543) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:528) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:394) [netty-all-4.0.29.Final.jar:4.0.29.Final] at org.apache.drill.exec.rpc.RpcExceptionHandler.exceptionCaught(RpcExceptionHandler.java:39) [drill-rpc-1.5.0.jar:1.5.0] at io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:246) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.fireExceptionCaught(AbstractChannelHandlerContext.java:224) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.ChannelInboundHandlerAdapter.exceptionCaught(ChannelInboundHandlerAdapter.java:131) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:246) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.notifyHandlerException(AbstractChannelHandlerContext.java:737) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:310) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:266) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:244) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:846) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354) [netty-all-4.0.29.Final.jar:4.0.29.Final] at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) [netty-all-4.0.29.Final.jar:4.0.29.Final] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_91] 20:30:47,638 INFO [org.apache.drill.jdbc.impl.DrillResultSetImpl$ResultsListener] (Client-1) [#2] Query failed: 20:30:47,638 ERROR [stderr] (http--0.0.0.0-8080-1) java.sql.SQLException: exception while executing query: CONNECTION ERROR: Connection /172.18.129.2:39687 <--> INBBRDSSVM265/172.18.129.2:31010 (user client) closed unexpectedly. 20:30:47,639 ERROR [stderr] (http--0.0.0.0-8080-1) 20:30:47,639 ERROR [stderr] (http--0.0.0.0-8080-1) 20:30:47,639 ERROR [stderr] (http--0.0.0.0-8080-1) [Error Id: 9bf8c48c-75b1-4967-8de3-8d69406f9730 ] 20:30:47,640 ERROR [stderr] (http--0.0.0.0-8080-1) at net.hydromatic.avatica.Helper.createException(Helper.java:40) 20:30:47,640 ERROR [stderr] (http--0.0.0.0-8080-1) at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:406) 20:30:47,641 ERROR [stderr] (http--0.0.0.0-8080-1) at net.hydromatic.avatica.AvaticaPreparedStatement.executeQuery(AvaticaPreparedStatement.java:77) 20:30:47,641 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.jdbc.impl.DrillPreparedStatementImpl.executeQuery(DrillPreparedStatementImpl.java:488) 20:30:47,642 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.util.DrillDataReader.fireExternalQuery(DrillDataReader.java:62) 20:30:47,642 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.util.DrillDataReader$$FastClassBySpringCGLIB$$70794315.invoke(<generated>) 20:30:47,643 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) 20:30:47,643 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) 20:30:47,645 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 20:30:47,646 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) 20:30:47,646 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,647 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) 20:30:47,647 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) 20:30:47,648 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) 20:30:47,649 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:47,649 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:47,649 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) 20:30:47,650 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) 20:30:47,650 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) 20:30:47,651 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,651 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) 20:30:47,652 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,652 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) 20:30:47,653 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,653 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) 20:30:47,654 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.util.DrillDataReader$$EnhancerBySpringCGLIB$$cd4667ba.fireExternalQuery(<generated>) 20:30:47,655 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.dao.DrillAdhocDaoImpl.queryForAdhocData(DrillAdhocDaoImpl.java:27) 20:30:47,656 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 20:30:47,657 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 20:30:47,658 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:47,658 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:47,659 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 20:30:47,659 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) 20:30:47,660 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 20:30:47,660 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) 20:30:47,661 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,661 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) 20:30:47,662 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) 20:30:47,662 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) 20:30:47,663 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:47,663 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:47,663 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) 20:30:47,664 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) 20:30:47,664 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) 20:30:47,665 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,665 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) 20:30:47,666 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,666 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) 20:30:47,667 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,667 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) 20:30:47,668 ERROR [stderr] (http--0.0.0.0-8080-1) at com.sun.proxy.$Proxy60.queryForAdhocData(Unknown Source) 20:30:47,668 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 20:30:47,668 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 20:30:47,669 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:47,669 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:47,670 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.AdhocFileSender.getAdhocResultSet(AdhocFileSender.java:157) 20:30:47,670 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.AdhocFileSender$$FastClassBySpringCGLIB$$dde03b98.invoke(<generated>) 20:30:47,671 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) 20:30:47,671 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) 20:30:47,671 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 20:30:47,672 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) 20:30:47,672 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,673 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) 20:30:47,673 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) 20:30:47,674 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) 20:30:47,674 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:47,675 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:47,675 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) 20:30:47,676 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) 20:30:47,676 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) 20:30:47,676 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,677 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) 20:30:47,677 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,678 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) 20:30:47,678 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,679 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) 20:30:47,679 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.AdhocFileSender$$EnhancerBySpringCGLIB$$4c4d8add.getAdhocResultSet(<generated>) 20:30:47,680 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.Adhocservice.getDesiredOutput(Adhocservice.java:123) 20:30:47,680 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.Adhocservice.getResult(Adhocservice.java:78) 20:30:47,681 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.Adhocservice.getAdhocResult(Adhocservice.java:53) 20:30:47,681 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.Adhocservice$$FastClassBySpringCGLIB$$14f1a7c4.invoke(<generated>) 20:30:47,682 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) 20:30:47,682 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) 20:30:47,683 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 20:30:47,683 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) 20:30:47,684 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,684 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) 20:30:47,685 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) 20:30:47,685 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) 20:30:47,685 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:47,686 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:47,686 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) 20:30:47,687 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) 20:30:47,687 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) 20:30:47,688 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,688 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) 20:30:47,689 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,689 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) 20:30:47,690 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,690 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) 20:30:47,691 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.service.Adhocservice$$EnhancerBySpringCGLIB$$e3e57d89.getAdhocResult(<generated>) 20:30:47,691 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.AdhocBaseFacade.executeAdhocServiceInput(AdhocBaseFacade.java:90) 20:30:47,692 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.facade.Adhoc.getAdhocResults(Adhoc.java:62) 20:30:47,692 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.facade.Adhoc$$FastClassBySpringCGLIB$$807611e.invoke(<generated>) 20:30:47,693 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) 20:30:47,693 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) 20:30:47,693 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 20:30:47,694 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) 20:30:47,694 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,695 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) 20:30:47,695 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.core.util.LogAdvice.logAround(LogAdvice.java:21) 20:30:47,696 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) 20:30:47,696 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:47,697 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:47,697 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) 20:30:47,698 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) 20:30:47,698 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) 20:30:47,699 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,699 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43) 20:30:47,699 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,700 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) 20:30:47,701 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:266) 20:30:47,701 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) 20:30:47,702 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,702 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) 20:30:47,703 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 20:30:47,703 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) 20:30:47,704 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.adhoc.facade.Adhoc$$EnhancerBySpringCGLIB$$18297250.getAdhocResults(<generated>) 20:30:47,704 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 20:30:47,704 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 20:30:47,705 ERROR [stderr] (http--0.0.0.0-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 20:30:47,705 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.reflect.Method.invoke(Method.java:606) 20:30:47,706 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) 20:30:47,706 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) 20:30:47,707 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) 20:30:47,707 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:781) 20:30:47,708 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:721) 20:30:47,708 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83) 20:30:47,709 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943) 20:30:47,709 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877) 20:30:47,710 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961) 20:30:47,710 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863) 20:30:47,711 ERROR [stderr] (http--0.0.0.0-8080-1) at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) 20:30:47,711 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837) 20:30:47,711 ERROR [stderr] (http--0.0.0.0-8080-1) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) 20:30:47,712 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) 20:30:47,712 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 20:30:47,713 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.filters.CorsFilter.handleSimpleCORS(CorsFilter.java:302) 20:30:47,713 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:170) 20:30:47,713 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) 20:30:47,714 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 20:30:47,714 ERROR [stderr] (http--0.0.0.0-8080-1) at com.abc.xyz.service.core.audit.util.AuditFilter.doFilterInternal(AuditFilter.java:55) 20:30:47,715 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 20:30:47,715 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) 20:30:47,716 ERROR [stderr] (http--0.0.0.0-8080-1) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) 20:30:47,716 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) 20:30:47,717 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 20:30:47,717 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) 20:30:47,718 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) 20:30:47,718 ERROR [stderr] (http--0.0.0.0-8080-1) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) 20:30:47,719 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) 20:30:47,719 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 20:30:47,719 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 20:30:47,720 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) 20:30:47,720 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) 20:30:47,721 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) 20:30:47,721 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) 20:30:47,721 ERROR [stderr] (http--0.0.0.0-8080-1) at java.lang.Thread.run(Thread.java:745) 20:30:47,722 ERROR [stderr] (http--0.0.0.0-8080-1) Caused by: java.sql.SQLException: CONNECTION ERROR: Connection /172.18.129.2:39687 <--> INBBRDSSVM265/172.18.129.2:31010 (user client) closed unexpectedly. 20:30:47,723 ERROR [stderr] (http--0.0.0.0-8080-1) 20:30:47,723 ERROR [stderr] (http--0.0.0.0-8080-1) 20:30:47,723 ERROR [stderr] (http--0.0.0.0-8080-1) [Error Id: 9bf8c48c-75b1-4967-8de3-8d69406f9730 ] 20:30:47,724 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:247) 20:30:47,724 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:290) 20:30:47,724 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1923) 20:30:47,725 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:73) 20:30:47,725 ERROR [stderr] (http--0.0.0.0-8080-1) at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404) 20:30:47,726 ERROR [stderr] (http--0.0.0.0-8080-1) ... 166 more 20:30:47,726 ERROR [stderr] (http--0.0.0.0-8080-1) Caused by: org.apache.drill.common.exceptions.UserException: CONNECTION ERROR: Connection /172.18.129.2:39687 <--> INBBRDSSVM265/172.18.129.2:31010 (user client) closed unexpectedly. 20:30:47,727 ERROR [stderr] (http--0.0.0.0-8080-1) 20:30:47,727 ERROR [stderr] (http--0.0.0.0-8080-1) 20:30:47,727 ERROR [stderr] (http--0.0.0.0-8080-1) [Error Id: 9bf8c48c-75b1-4967-8de3-8d69406f9730 ] 20:30:47,728 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:543) 20:30:47,728 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.exec.rpc.user.QueryResultHandler$SubmissionListener$ChannelClosedListener.operationComplete(QueryResultHandler.java:299) 20:30:47,729 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680) 20:30:47,729 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603) 20:30:47,729 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563) 20:30:47,730 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.util.concurrent.DefaultPromise.trySuccess(DefaultPromise.java:406) 20:30:47,730 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.DefaultChannelPromise.trySuccess(DefaultChannelPromise.java:82) 20:30:47,731 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannel$CloseFuture.setClosed(AbstractChannel.java:956) 20:30:47,731 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannel$AbstractUnsafe.doClose0(AbstractChannel.java:608) 20:30:47,731 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannel$AbstractUnsafe.close(AbstractChannel.java:586) 20:30:47,732 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.DefaultChannelPipeline$HeadContext.close(DefaultChannelPipeline.java:1107) 20:30:47,732 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:543) 20:30:47,733 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:528) 20:30:47,733 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.ChannelOutboundHandlerAdapter.close(ChannelOutboundHandlerAdapter.java:71) 20:30:47,734 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:543) 20:30:47,734 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:528) 20:30:47,735 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.ChannelDuplexHandler.close(ChannelDuplexHandler.java:73) 20:30:47,735 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:543) 20:30:47,735 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:528) 20:30:47,736 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:394) 20:30:47,736 ERROR [stderr] (http--0.0.0.0-8080-1) at org.apache.drill.exec.rpc.RpcExceptionHandler.exceptionCaught(RpcExceptionHandler.java:39) 20:30:47,737 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:246) 20:30:47,737 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.fireExceptionCaught(AbstractChannelHandlerContext.java:224) 20:30:47,738 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.ChannelInboundHandlerAdapter.exceptionCaught(ChannelInboundHandlerAdapter.java:131) 20:30:47,739 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:246) 20:30:47,739 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.notifyHandlerException(AbstractChannelHandlerContext.java:737) 20:30:47,740 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:310) 20:30:47,740 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) 20:30:47,741 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:266) 20:30:47,741 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) 20:30:47,741 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) 20:30:47,742 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) 20:30:47,742 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) 20:30:47,743 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) 20:30:47,743 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:244) 20:30:47,744 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) 20:30:47,744 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) 20:30:47,745 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) 20:30:47,745 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308) 20:30:47,746 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294) 20:30:47,746 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:846) 20:30:47,747 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) 20:30:47,747 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511) 20:30:47,748 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468) 20:30:47,748 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382) 20:30:47,749 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354) 20:30:47,749 ERROR [stderr] (http--0.0.0.0-8080-1) at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) 20:30:47,750 ERROR [stderr] (http--0.0.0.0-8080-1) ... 1 more 20:30:47,750 ERROR [com.abc.xyz.service.adhoc.util.DrillDataReader] (http--0.0.0.0-8080-1) java.sql.SQLException: exception while executing query: CONNECTION ERROR: Connection /172.18.129.2:39687 <--> INBBRDSSVM265/172.18.129.2:31010 (user client) closed unexpectedly. > Unable to execute drill jdbc from jboss container > ------------------------------------------------- > > Key: DRILL-4430 > URL: https://issues.apache.org/jira/browse/DRILL-4430 > Project: Apache Drill > Issue Type: Bug > Components: Client - JDBC > Affects Versions: 1.5.0 > Environment: Linux > Windows 7 > Jboss 7.1 > Reporter: abhishek agrawal > > Unable to execute jdbc query from jboss application server. Its closing the > connection with an error: > 20:30:46,543 INFO > [org.apache.curator.framework.state.ConnectionStateManager] > (http--0.0.0.0-8080-1-EventThread) State change: CONNECTED > 20:30:47,609 ERROR [org.apache.drill.exec.rpc.RpcExceptionHandler] (Client-1) > Exception in RPC communication. Connection: /172.18.129.2:39687 <--> > INBBRDSSVM265/172.18.129.2:31010 (user client). Closing connection. > 20:30:47,614 INFO [org.apache.drill.exec.rpc.user.UserClient] (Client-1) > Channel closed /172.18.129.2:39687 <--> INBBRDSSVM265/172.18.129.2:31010. > 20:30:47,614 INFO [org.apache.drill.exec.rpc.user.QueryResultHandler] > (Client-1) User Error Occurred: > org.apache.drill.common.exceptions.UserException: CONNECTION ERROR: > Connection /172.18.129.2:39687 <--> INBBRDSSVM265/172.18.129.2:31010 (user > client) closed unexpectedly. > Note: the same code with right dependency works fine with standalone java > code. -- This message was sent by Atlassian JIRA (v6.3.4#6332)