2018-09-12 14:39:24.435 DEBUG [jx-data-analysis,,,] 10628 --- [9005-Acceptor-0] o.apache.tomcat.util.threads.LimitLatch : Counting up[http-nio-9005-Acceptor-0] latch=1 Counting up[http-nio-9005-Acceptor-0] latch=1 2018-09-12 14:39:24.436 DEBUG [jx-data-analysis,,,] 10628 --- [9005-Acceptor-0] o.apache.tomcat.util.threads.LimitLatch : Counting up[http-nio-9005-Acceptor-0] latch=2 Counting up[http-nio-9005-Acceptor-0] latch=2 2018-09-12 14:39:24.468 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] org.apache.tomcat.util.modeler.Registry : Managed= Tomcat:type=RequestProcessor,worker="http-nio-9005",name=HttpRequest1 Managed= Tomcat:type=RequestProcessor,worker="http-nio-9005",name=HttpRequest1 2018-09-12 14:39:24.468 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] org.apache.tomcat.util.modeler.Registry : Looking for descriptor Looking for descriptor 2018-09-12 14:39:24.469 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] org.apache.tomcat.util.modeler.Registry : Introspecting Introspecting 2018-09-12 14:39:24.470 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute virtualHost public java.lang.String org.apache.coyote.RequestInfo.getVirtualHost() null Introspected attribute virtualHost public java.lang.String org.apache.coyote.RequestInfo.getVirtualHost() null 2018-09-12 14:39:24.470 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute bytesSent public long org.apache.coyote.RequestInfo.getBytesSent() public void org.apache.coyote.RequestInfo.setBytesSent(long) Introspected attribute bytesSent public long org.apache.coyote.RequestInfo.getBytesSent() public void org.apache.coyote.RequestInfo.setBytesSent(long) 2018-09-12 14:39:24.470 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute method public java.lang.String org.apache.coyote.RequestInfo.getMethod() null Introspected attribute method public java.lang.String org.apache.coyote.RequestInfo.getMethod() null 2018-09-12 14:39:24.470 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute remoteAddr public java.lang.String org.apache.coyote.RequestInfo.getRemoteAddr() null Introspected attribute remoteAddr public java.lang.String org.apache.coyote.RequestInfo.getRemoteAddr() null 2018-09-12 14:39:24.470 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute requestBytesSent public long org.apache.coyote.RequestInfo.getRequestBytesSent() null Introspected attribute requestBytesSent public long org.apache.coyote.RequestInfo.getRequestBytesSent() null 2018-09-12 14:39:24.470 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute rpName public javax.management.ObjectName org.apache.coyote.RequestInfo.getRpName() public void org.apache.coyote.RequestInfo.setRpName(javax.management.ObjectName) Introspected attribute rpName public javax.management.ObjectName org.apache.coyote.RequestInfo.getRpName() public void org.apache.coyote.RequestInfo.setRpName(javax.management.ObjectName) 2018-09-12 14:39:24.470 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute contentLength public int org.apache.coyote.RequestInfo.getContentLength() null Introspected attribute contentLength public int org.apache.coyote.RequestInfo.getContentLength() null 2018-09-12 14:39:24.470 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute workerThreadName public java.lang.String org.apache.coyote.RequestInfo.getWorkerThreadName() public void org.apache.coyote.RequestInfo.setWorkerThreadName(java.lang.String) Introspected attribute workerThreadName public java.lang.String org.apache.coyote.RequestInfo.getWorkerThreadName() public void org.apache.coyote.RequestInfo.setWorkerThreadName(java.lang.String) 2018-09-12 14:39:24.470 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute bytesReceived public long org.apache.coyote.RequestInfo.getBytesReceived() public void org.apache.coyote.RequestInfo.setBytesReceived(long) Introspected attribute bytesReceived public long org.apache.coyote.RequestInfo.getBytesReceived() public void org.apache.coyote.RequestInfo.setBytesReceived(long) 2018-09-12 14:39:24.470 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute requestProcessingTime public long org.apache.coyote.RequestInfo.getRequestProcessingTime() null Introspected attribute requestProcessingTime public long org.apache.coyote.RequestInfo.getRequestProcessingTime() null 2018-09-12 14:39:24.471 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute remoteAddrForwarded public java.lang.String org.apache.coyote.RequestInfo.getRemoteAddrForwarded() null Introspected attribute remoteAddrForwarded public java.lang.String org.apache.coyote.RequestInfo.getRemoteAddrForwarded() null 2018-09-12 14:39:24.471 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute globalProcessor public org.apache.coyote.RequestGroupInfo org.apache.coyote.RequestInfo.getGlobalProcessor() public void org.apache.coyote.RequestInfo.setGlobalProcessor(org.apache.coyote.RequestGroupInfo) Introspected attribute globalProcessor public org.apache.coyote.RequestGroupInfo org.apache.coyote.RequestInfo.getGlobalProcessor() public void org.apache.coyote.RequestInfo.setGlobalProcessor(org.apache.coyote.RequestGroupInfo) 2018-09-12 14:39:24.471 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute currentQueryString public java.lang.String org.apache.coyote.RequestInfo.getCurrentQueryString() null Introspected attribute currentQueryString public java.lang.String org.apache.coyote.RequestInfo.getCurrentQueryString() null 2018-09-12 14:39:24.471 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute protocol public java.lang.String org.apache.coyote.RequestInfo.getProtocol() null Introspected attribute protocol public java.lang.String org.apache.coyote.RequestInfo.getProtocol() null 2018-09-12 14:39:24.471 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute maxRequestUri public java.lang.String org.apache.coyote.RequestInfo.getMaxRequestUri() public void org.apache.coyote.RequestInfo.setMaxRequestUri(java.lang.String) Introspected attribute maxRequestUri public java.lang.String org.apache.coyote.RequestInfo.getMaxRequestUri() public void org.apache.coyote.RequestInfo.setMaxRequestUri(java.lang.String) 2018-09-12 14:39:24.471 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute requestBytesReceived public long org.apache.coyote.RequestInfo.getRequestBytesReceived() null Introspected attribute requestBytesReceived public long org.apache.coyote.RequestInfo.getRequestBytesReceived() null 2018-09-12 14:39:24.471 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute serverPort public int org.apache.coyote.RequestInfo.getServerPort() null Introspected attribute serverPort public int org.apache.coyote.RequestInfo.getServerPort() null 2018-09-12 14:39:24.471 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute stage public int org.apache.coyote.RequestInfo.getStage() public void org.apache.coyote.RequestInfo.setStage(int) Introspected attribute stage public int org.apache.coyote.RequestInfo.getStage() public void org.apache.coyote.RequestInfo.setStage(int) 2018-09-12 14:39:24.471 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute requestCount public int org.apache.coyote.RequestInfo.getRequestCount() public void org.apache.coyote.RequestInfo.setRequestCount(int) Introspected attribute requestCount public int org.apache.coyote.RequestInfo.getRequestCount() public void org.apache.coyote.RequestInfo.setRequestCount(int) 2018-09-12 14:39:24.471 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute maxTime public long org.apache.coyote.RequestInfo.getMaxTime() public void org.apache.coyote.RequestInfo.setMaxTime(long) Introspected attribute maxTime public long org.apache.coyote.RequestInfo.getMaxTime() public void org.apache.coyote.RequestInfo.setMaxTime(long) 2018-09-12 14:39:24.471 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute processingTime public long org.apache.coyote.RequestInfo.getProcessingTime() public void org.apache.coyote.RequestInfo.setProcessingTime(long) Introspected attribute processingTime public long org.apache.coyote.RequestInfo.getProcessingTime() public void org.apache.coyote.RequestInfo.setProcessingTime(long) 2018-09-12 14:39:24.471 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute currentUri public java.lang.String org.apache.coyote.RequestInfo.getCurrentUri() null Introspected attribute currentUri public java.lang.String org.apache.coyote.RequestInfo.getCurrentUri() null 2018-09-12 14:39:24.472 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute lastRequestProcessingTime public long org.apache.coyote.RequestInfo.getLastRequestProcessingTime() public void org.apache.coyote.RequestInfo.setLastRequestProcessingTime(long) Introspected attribute lastRequestProcessingTime public long org.apache.coyote.RequestInfo.getLastRequestProcessingTime() public void org.apache.coyote.RequestInfo.setLastRequestProcessingTime(long) 2018-09-12 14:39:24.472 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Introspected attribute errorCount public int org.apache.coyote.RequestInfo.getErrorCount() public void org.apache.coyote.RequestInfo.setErrorCount(int) Introspected attribute errorCount public int org.apache.coyote.RequestInfo.getErrorCount() public void org.apache.coyote.RequestInfo.setErrorCount(int) 2018-09-12 14:39:24.472 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.MbeansDescriptorsIntrospectionSource : Setting name: org.apache.coyote.RequestInfo Setting name: org.apache.coyote.RequestInfo 2018-09-12 14:39:24.472 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.util.modeler.BaseModelMBean : preRegister org.apache.coyote.RequestInfo@624f63aa Tomcat:type=RequestProcessor,worker="http-nio-9005",name=HttpRequest1 preRegister org.apache.coyote.RequestInfo@624f63aa Tomcat:type=RequestProcessor,worker="http-nio-9005",name=HttpRequest1 2018-09-12 14:39:24.474 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.util.net.SocketWrapperBase : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@a25c617:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:54851]], Read from buffer: [0] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@a25c617:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:54851]], Read from buffer: [0] 2018-09-12 14:39:24.475 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.coyote.http11.Http11InputBuffer : Received [GET /jx-data/joyxuan_mall/distribution/show?q_type=BUBAJRGWC000001001_COUNT&dt1=2018-09-1&dt2=2018-09-11 HTTP/1.1 Host: 127.0.0.1:9005 Connection: keep-alive Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Accept-Encoding: gzip, deflate, br Accept-Language: zh-CN,zh;q=0.9 ] Received [GET /jx-data/joyxuan_mall/distribution/show?q_type=BUBAJRGWC000001001_COUNT&dt1=2018-09-1&dt2=2018-09-11 HTTP/1.1 Host: 127.0.0.1:9005 Connection: keep-alive Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Accept-Encoding: gzip, deflate, br Accept-Language: zh-CN,zh;q=0.9 ] 2018-09-12 14:39:24.500 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] org.apache.tomcat.util.http.Parameters : Set query string encoding to UTF-8 Set query string encoding to UTF-8 2018-09-12 14:39:24.504 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.authenticator.AuthenticatorBase : Security checking request GET /jx-data/joyxuan_mall/distribution/show Security checking request GET /jx-data/joyxuan_mall/distribution/show 2018-09-12 14:39:24.504 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] org.apache.catalina.realm.RealmBase : No applicable constraints defined No applicable constraints defined 2018-09-12 14:39:24.510 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.a.jaspic.AuthConfigFactoryImpl : Loading persistent provider registrations from [C:\Users\Administrator\AppData\Local\Temp\tomcat.6706552140480160635.9005\conf\jaspic-providers.xml] Loading persistent provider registrations from [C:\Users\Administrator\AppData\Local\Temp\tomcat.6706552140480160635.9005\conf\jaspic-providers.xml] 2018-09-12 14:39:24.511 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.authenticator.AuthenticatorBase : Not subject to any constraint Not subject to any constraint 2018-09-12 14:39:24.512 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : Initializing servlet 'dispatcherServlet' Initializing servlet 'dispatcherServlet' 2018-09-12 14:39:24.513 INFO [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.c.C.[.[localhost].[/jx-data] : Initializing Spring FrameworkServlet 'dispatcherServlet' Initializing Spring FrameworkServlet 'dispatcherServlet' 2018-09-12 14:39:24.513 INFO [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : FrameworkServlet 'dispatcherServlet': initialization started FrameworkServlet 'dispatcherServlet': initialization started 2018-09-12 14:39:24.513 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'multipartResolver' Returning cached instance of singleton bean 'multipartResolver' 2018-09-12 14:39:24.514 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : Using MultipartResolver [org.springframework.web.multipart.support.StandardServletMultipartResolver@582052b6] Using MultipartResolver [org.springframework.web.multipart.support.StandardServletMultipartResolver@582052b6] 2018-09-12 14:39:24.514 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolver' Creating instance of bean 'org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolver' 2018-09-12 14:39:24.515 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(java.lang.ObjectCustomizer) findClass(java.lang.ObjectCustomizer) 2018-09-12 14:39:24.516 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.517 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolverCustomizer) findClass(org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolverCustomizer) 2018-09-12 14:39:24.517 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.519 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(org.springframework.web.servlet.LocaleResolverCustomizer) findClass(org.springframework.web.servlet.LocaleResolverCustomizer) 2018-09-12 14:39:24.519 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.519 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'org.springframework.transaction.config.internalTransactionAdvisor' Returning cached instance of singleton bean 'org.springframework.transaction.config.internalTransactionAdvisor' 2018-09-12 14:39:24.520 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolver' Finished creating instance of bean 'org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolver' 2018-09-12 14:39:24.520 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : Unable to locate LocaleResolver with name 'localeResolver': using default [org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolver@1c8c9153] Unable to locate LocaleResolver with name 'localeResolver': using default [org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolver@1c8c9153] 2018-09-12 14:39:24.521 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'org.springframework.web.servlet.theme.FixedThemeResolver' Creating instance of bean 'org.springframework.web.servlet.theme.FixedThemeResolver' 2018-09-12 14:39:24.522 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(java.lang.ObjectCustomizer) findClass(java.lang.ObjectCustomizer) 2018-09-12 14:39:24.523 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.526 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(org.springframework.web.servlet.theme.AbstractThemeResolverCustomizer) findClass(org.springframework.web.servlet.theme.AbstractThemeResolverCustomizer) 2018-09-12 14:39:24.526 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.528 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(org.springframework.web.servlet.theme.FixedThemeResolverCustomizer) findClass(org.springframework.web.servlet.theme.FixedThemeResolverCustomizer) 2018-09-12 14:39:24.528 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.530 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(org.springframework.web.servlet.ThemeResolverCustomizer) findClass(org.springframework.web.servlet.ThemeResolverCustomizer) 2018-09-12 14:39:24.530 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.531 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'org.springframework.transaction.config.internalTransactionAdvisor' Returning cached instance of singleton bean 'org.springframework.transaction.config.internalTransactionAdvisor' 2018-09-12 14:39:24.531 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'org.springframework.web.servlet.theme.FixedThemeResolver' Finished creating instance of bean 'org.springframework.web.servlet.theme.FixedThemeResolver' 2018-09-12 14:39:24.531 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : Unable to locate ThemeResolver with name 'themeResolver': using default [org.springframework.web.servlet.theme.FixedThemeResolver@7f35906c] Unable to locate ThemeResolver with name 'themeResolver': using default [org.springframework.web.servlet.theme.FixedThemeResolver@7f35906c] 2018-09-12 14:39:24.532 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'requestMappingHandlerMapping' Returning cached instance of singleton bean 'requestMappingHandlerMapping' 2018-09-12 14:39:24.532 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'viewControllerHandlerMapping' Returning cached instance of singleton bean 'viewControllerHandlerMapping' 2018-09-12 14:39:24.532 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'beanNameHandlerMapping' Returning cached instance of singleton bean 'beanNameHandlerMapping' 2018-09-12 14:39:24.532 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'resourceHandlerMapping' Returning cached instance of singleton bean 'resourceHandlerMapping' 2018-09-12 14:39:24.532 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'defaultServletHandlerMapping' Returning cached instance of singleton bean 'defaultServletHandlerMapping' 2018-09-12 14:39:24.532 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'faviconHandlerMapping' Returning cached instance of singleton bean 'faviconHandlerMapping' 2018-09-12 14:39:24.532 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'welcomePageHandlerMapping' Returning cached instance of singleton bean 'welcomePageHandlerMapping' 2018-09-12 14:39:24.532 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'endpointHandlerMapping' Returning cached instance of singleton bean 'endpointHandlerMapping' 2018-09-12 14:39:24.533 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'requestMappingHandlerAdapter' Returning cached instance of singleton bean 'requestMappingHandlerAdapter' 2018-09-12 14:39:24.533 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'httpRequestHandlerAdapter' Returning cached instance of singleton bean 'httpRequestHandlerAdapter' 2018-09-12 14:39:24.533 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'simpleControllerHandlerAdapter' Returning cached instance of singleton bean 'simpleControllerHandlerAdapter' 2018-09-12 14:39:24.534 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'errorAttributes' Returning cached instance of singleton bean 'errorAttributes' 2018-09-12 14:39:24.534 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'handlerExceptionResolver' Returning cached instance of singleton bean 'handlerExceptionResolver' 2018-09-12 14:39:24.535 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'org.springframework.web.servlet.view.DefaultRequestToViewNameTranslator' Creating instance of bean 'org.springframework.web.servlet.view.DefaultRequestToViewNameTranslator' 2018-09-12 14:39:24.536 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(java.lang.ObjectCustomizer) findClass(java.lang.ObjectCustomizer) 2018-09-12 14:39:24.536 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.537 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(org.springframework.web.servlet.view.DefaultRequestToViewNameTranslatorCustomizer) findClass(org.springframework.web.servlet.view.DefaultRequestToViewNameTranslatorCustomizer) 2018-09-12 14:39:24.537 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.538 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(org.springframework.web.servlet.RequestToViewNameTranslatorCustomizer) findClass(org.springframework.web.servlet.RequestToViewNameTranslatorCustomizer) 2018-09-12 14:39:24.539 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.540 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'org.springframework.transaction.config.internalTransactionAdvisor' Returning cached instance of singleton bean 'org.springframework.transaction.config.internalTransactionAdvisor' 2018-09-12 14:39:24.540 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'org.springframework.web.servlet.view.DefaultRequestToViewNameTranslator' Finished creating instance of bean 'org.springframework.web.servlet.view.DefaultRequestToViewNameTranslator' 2018-09-12 14:39:24.540 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : Unable to locate RequestToViewNameTranslator with name 'viewNameTranslator': using default [org.springframework.web.servlet.view.DefaultRequestToViewNameTranslator@6cdf5071] Unable to locate RequestToViewNameTranslator with name 'viewNameTranslator': using default [org.springframework.web.servlet.view.DefaultRequestToViewNameTranslator@6cdf5071] 2018-09-12 14:39:24.541 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'beanNameViewResolver' Returning cached instance of singleton bean 'beanNameViewResolver' 2018-09-12 14:39:24.541 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'mvcViewResolver' Returning cached instance of singleton bean 'mvcViewResolver' 2018-09-12 14:39:24.542 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'defaultViewResolver' Returning cached instance of singleton bean 'defaultViewResolver' 2018-09-12 14:39:24.542 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'viewResolver' Returning cached instance of singleton bean 'viewResolver' 2018-09-12 14:39:24.547 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'org.springframework.web.servlet.support.SessionFlashMapManager' Creating instance of bean 'org.springframework.web.servlet.support.SessionFlashMapManager' 2018-09-12 14:39:24.549 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(java.lang.ObjectCustomizer) findClass(java.lang.ObjectCustomizer) 2018-09-12 14:39:24.549 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.550 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(org.springframework.web.servlet.support.AbstractFlashMapManagerCustomizer) findClass(org.springframework.web.servlet.support.AbstractFlashMapManagerCustomizer) 2018-09-12 14:39:24.551 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.552 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(org.springframework.web.servlet.support.SessionFlashMapManagerCustomizer) findClass(org.springframework.web.servlet.support.SessionFlashMapManagerCustomizer) 2018-09-12 14:39:24.552 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.554 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(org.springframework.web.servlet.FlashMapManagerCustomizer) findClass(org.springframework.web.servlet.FlashMapManagerCustomizer) 2018-09-12 14:39:24.554 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.554 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'org.springframework.transaction.config.internalTransactionAdvisor' Returning cached instance of singleton bean 'org.springframework.transaction.config.internalTransactionAdvisor' 2018-09-12 14:39:24.555 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'org.springframework.web.servlet.support.SessionFlashMapManager' Finished creating instance of bean 'org.springframework.web.servlet.support.SessionFlashMapManager' 2018-09-12 14:39:24.555 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : Unable to locate FlashMapManager with name 'flashMapManager': using default [org.springframework.web.servlet.support.SessionFlashMapManager@4cc5fb39] Unable to locate FlashMapManager with name 'flashMapManager': using default [org.springframework.web.servlet.support.SessionFlashMapManager@4cc5fb39] 2018-09-12 14:39:24.555 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : Published WebApplicationContext of servlet 'dispatcherServlet' as ServletContext attribute with name [org.springframework.web.servlet.FrameworkServlet.CONTEXT.dispatcherServlet] Published WebApplicationContext of servlet 'dispatcherServlet' as ServletContext attribute with name [org.springframework.web.servlet.FrameworkServlet.CONTEXT.dispatcherServlet] 2018-09-12 14:39:24.555 INFO [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : FrameworkServlet 'dispatcherServlet': initialization completed in 42 ms FrameworkServlet 'dispatcherServlet': initialization completed in 42 ms 2018-09-12 14:39:24.555 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : Servlet 'dispatcherServlet' configured successfully Servlet 'dispatcherServlet' configured successfully 2018-09-12 14:39:24.568 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.w.f.OrderedRequestContextFilter : Bound request context to thread: org.apache.catalina.connector.RequestFacade@75b3b13 Bound request context to thread: org.apache.catalina.connector.RequestFacade@75b3b13 2018-09-12 14:39:24.570 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : DispatcherServlet with name 'dispatcherServlet' processing GET request for [/jx-data/joyxuan_mall/distribution/show] DispatcherServlet with name 'dispatcherServlet' processing GET request for [/jx-data/joyxuan_mall/distribution/show] 2018-09-12 14:39:24.573 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.a.e.mvc.EndpointHandlerMapping : Looking up handler method for path /joyxuan_mall/distribution/show Looking up handler method for path /joyxuan_mall/distribution/show 2018-09-12 14:39:24.583 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.a.e.mvc.EndpointHandlerMapping : Did not find handler method for [/joyxuan_mall/distribution/show] Did not find handler method for [/joyxuan_mall/distribution/show] 2018-09-12 14:39:24.583 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] s.w.s.m.m.a.RequestMappingHandlerMapping : Looking up handler method for path /joyxuan_mall/distribution/show Looking up handler method for path /joyxuan_mall/distribution/show 2018-09-12 14:39:24.585 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] s.w.s.m.m.a.RequestMappingHandlerMapping : Returning handler method [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)] Returning handler method [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)] 2018-09-12 14:39:24.585 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'distributionAnalysisController' Returning cached instance of singleton bean 'distributionAnalysisController' 2018-09-12 14:39:24.586 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : Last-Modified value for [/jx-data/joyxuan_mall/distribution/show] is: -1 Last-Modified value for [/jx-data/joyxuan_mall/distribution/show] is: -1 2018-09-12 14:39:24.599 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] org.apache.tomcat.util.http.Parameters : Set encoding to UTF-8 Set encoding to UTF-8 2018-09-12 14:39:24.599 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] org.apache.tomcat.util.http.Parameters : Decoding query null UTF-8 Decoding query null UTF-8 2018-09-12 14:39:24.600 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] org.apache.tomcat.util.http.Parameters : Start processing with input [q_type=BUBAJRGWC000001001_COUNT&dt1=2018-09-1&dt2=2018-09-11] Start processing with input [q_type=BUBAJRGWC000001001_COUNT&dt1=2018-09-1&dt2=2018-09-11] 2018-09-12 14:39:24.602 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(java.lang.ObjectCustomizer) findClass(java.lang.ObjectCustomizer) 2018-09-12 14:39:24.603 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.604 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(com.jx.data.biz.bean.QueryBeanCustomizer) findClass(com.jx.data.biz.bean.QueryBeanCustomizer) 2018-09-12 14:39:24.605 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.608 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(com.jx.data.biz.distribution.bean.DistributionAnalysisBeanCustomizer) findClass(com.jx.data.biz.distribution.bean.DistributionAnalysisBeanCustomizer) 2018-09-12 14:39:24.608 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.610 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(java.lang.CloneableCustomizer) findClass(java.lang.CloneableCustomizer) 2018-09-12 14:39:24.611 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.611 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.beans.CachedIntrospectionResults : Not strongly caching class [com.jx.data.biz.distribution.bean.DistributionAnalysisBean] because it is not cache-safe Not strongly caching class [com.jx.data.biz.distribution.bean.DistributionAnalysisBean] because it is not cache-safe 2018-09-12 14:39:24.620 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(java.lang.ObjectCustomizer) findClass(java.lang.ObjectCustomizer) 2018-09-12 14:39:24.620 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.622 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findClass(com.jx.data.sys.comm.bean.DataDictBeanCustomizer) findClass(com.jx.data.sys.comm.bean.DataDictBeanCustomizer) 2018-09-12 14:39:24.623 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:39:24.623 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.beans.CachedIntrospectionResults : Not strongly caching class [com.jx.data.sys.comm.bean.DataDictBean] because it is not cache-safe Not strongly caching class [com.jx.data.sys.comm.bean.DataDictBean] because it is not cache-safe 2018-09-12 14:39:24.624 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.jdbc.core.JdbcTemplate : Executing SQL query [select dict_type,dict_key,dict_value from data_dict where status=0 and dict_type='distr_analysis_ranges_count' order by dict_order asc ] Executing SQL query [select dict_type,dict_key,dict_value from data_dict where status=0 and dict_type='distr_analysis_ranges_count' order by dict_order asc ] 2018-09-12 14:39:24.630 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.jdbc.datasource.DataSourceUtils : Fetching JDBC Connection from DataSource Fetching JDBC Connection from DataSource 2018-09-12 14:39:24.640 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] 2018-09-12 14:39:24.641 WARN [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Not loading a JDBC driver as driverClassName property is null. Not loading a JDBC driver as driverClassName property is null. 2018-09-12 14:39:24.643 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findResources(META-INF/services/java.sql.Driver) findResources(META-INF/services/java.sql.Driver) 2018-09-12 14:39:24.980 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] 2018-09-12 14:39:24.980 WARN [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Not loading a JDBC driver as driverClassName property is null. Not loading a JDBC driver as driverClassName property is null. 2018-09-12 14:39:25.041 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] 2018-09-12 14:39:25.041 WARN [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Not loading a JDBC driver as driverClassName property is null. Not loading a JDBC driver as driverClassName property is null. 2018-09-12 14:39:25.101 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] 2018-09-12 14:39:25.101 WARN [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Not loading a JDBC driver as driverClassName property is null. Not loading a JDBC driver as driverClassName property is null. 2018-09-12 14:39:25.168 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] 2018-09-12 14:39:25.168 WARN [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Not loading a JDBC driver as driverClassName property is null. Not loading a JDBC driver as driverClassName property is null. 2018-09-12 14:39:25.230 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] 2018-09-12 14:39:25.230 WARN [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Not loading a JDBC driver as driverClassName property is null. Not loading a JDBC driver as driverClassName property is null. 2018-09-12 14:39:25.304 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] 2018-09-12 14:39:25.304 WARN [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Not loading a JDBC driver as driverClassName property is null. Not loading a JDBC driver as driverClassName property is null. 2018-09-12 14:39:25.374 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] 2018-09-12 14:39:25.375 WARN [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Not loading a JDBC driver as driverClassName property is null. Not loading a JDBC driver as driverClassName property is null. 2018-09-12 14:39:25.447 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] 2018-09-12 14:39:25.447 WARN [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Not loading a JDBC driver as driverClassName property is null. Not loading a JDBC driver as driverClassName property is null. 2018-09-12 14:39:25.508 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] Instantiating driver using class: null [url=jdbc:mysql://rm-wz949vh604k3v85rhho.mysql.rds.aliyuncs.com:3306/test_xxl_job?useUnicode=true&characterEncoding=utf-8] 2018-09-12 14:39:25.508 WARN [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Not loading a JDBC driver as driverClassName property is null. Not loading a JDBC driver as driverClassName property is null. 2018-09-12 14:39:25.598 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.jdbc.core.BeanPropertyRowMapper : Mapping column 'dict_type' to property 'dict_type' of type 'java.lang.String' Mapping column 'dict_type' to property 'dict_type' of type 'java.lang.String' 2018-09-12 14:39:25.598 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.jdbc.core.BeanPropertyRowMapper : Mapping column 'dict_key' to property 'dict_key' of type 'java.lang.String' Mapping column 'dict_key' to property 'dict_key' of type 'java.lang.String' 2018-09-12 14:39:25.598 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.jdbc.core.BeanPropertyRowMapper : Mapping column 'dict_value' to property 'dict_value' of type 'java.lang.String' Mapping column 'dict_value' to property 'dict_value' of type 'java.lang.String' 2018-09-12 14:39:25.614 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.jdbc.datasource.DataSourceUtils : Returning JDBC Connection to DataSource Returning JDBC Connection to DataSource 2018-09-12 14:39:25.615 INFO [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] c.j.d.biz.deal.service.DealDataService : sql:>>> select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc param=[] sql:>>> select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc param=[] 2018-09-12 14:39:25.618 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL query Executing prepared SQL query 2018-09-12 14:39:25.619 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL statement [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ] Executing prepared SQL statement [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ] 2018-09-12 14:39:25.619 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.jdbc.datasource.DataSourceUtils : Fetching JDBC Connection from DataSource Fetching JDBC Connection from DataSource 2018-09-12 14:39:25.619 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] 2018-09-12 14:39:25.620 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.ClassLoaderUtil : Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 2018-09-12 14:39:27.327 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] 2018-09-12 14:39:27.327 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.ClassLoaderUtil : Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 2018-09-12 14:39:29.047 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] 2018-09-12 14:39:29.047 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.ClassLoaderUtil : Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 2018-09-12 14:39:30.789 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] 2018-09-12 14:39:30.789 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.ClassLoaderUtil : Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 2018-09-12 14:39:32.197 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] 2018-09-12 14:39:32.197 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.ClassLoaderUtil : Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 2018-09-12 14:39:33.820 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] 2018-09-12 14:39:33.821 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.ClassLoaderUtil : Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 2018-09-12 14:39:35.615 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] 2018-09-12 14:39:35.615 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.ClassLoaderUtil : Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 2018-09-12 14:39:36.624 DEBUG [jx-data-analysis,,,] 10628 --- [io-9005-exec-10] org.apache.tomcat.util.modeler.Registry : Managed= Tomcat:type=RequestProcessor,worker="http-nio-9005",name=HttpRequest2 Managed= Tomcat:type=RequestProcessor,worker="http-nio-9005",name=HttpRequest2 2018-09-12 14:39:36.624 DEBUG [jx-data-analysis,,,] 10628 --- [io-9005-exec-10] o.a.tomcat.util.modeler.BaseModelMBean : preRegister org.apache.coyote.RequestInfo@66429893 Tomcat:type=RequestProcessor,worker="http-nio-9005",name=HttpRequest2 preRegister org.apache.coyote.RequestInfo@66429893 Tomcat:type=RequestProcessor,worker="http-nio-9005",name=HttpRequest2 2018-09-12 14:39:36.624 DEBUG [jx-data-analysis,,,] 10628 --- [io-9005-exec-10] o.a.tomcat.util.net.SocketWrapperBase : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@627d0083:org.apache.tomcat.util.net.NioChannel@68856bf3:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:54852]], Read from buffer: [0] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@627d0083:org.apache.tomcat.util.net.NioChannel@68856bf3:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:54852]], Read from buffer: [0] 2018-09-12 14:39:36.629 DEBUG [jx-data-analysis,,,] 10628 --- [io-9005-exec-10] o.apache.coyote.http11.Http11Processor : Error parsing HTTP request header Error parsing HTTP request header java.io.EOFException: null at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.fillReadBuffer(NioEndpoint.java:1250) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.read(NioEndpoint.java:1190) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11InputBuffer.fill(Http11InputBuffer.java:717) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11InputBuffer.parseRequestLine(Http11InputBuffer.java:366) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:687) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_172] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_172] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172] 2018-09-12 14:39:36.629 DEBUG [jx-data-analysis,,,] 10628 --- [io-9005-exec-10] o.apache.coyote.http11.Http11Processor : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@627d0083:org.apache.tomcat.util.net.NioChannel@68856bf3:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:54852]], Status in: [OPEN_READ], State out: [CLOSED] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@627d0083:org.apache.tomcat.util.net.NioChannel@68856bf3:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:54852]], Status in: [OPEN_READ], State out: [CLOSED] 2018-09-12 14:39:36.630 DEBUG [jx-data-analysis,,,] 10628 --- [io-9005-exec-10] o.apache.tomcat.util.threads.LimitLatch : Counting down[http-nio-9005-exec-10] latch=2 Counting down[http-nio-9005-exec-10] latch=2 2018-09-12 14:39:37.324 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] 2018-09-12 14:39:37.324 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.ClassLoaderUtil : Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 2018-09-12 14:39:39.051 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] 2018-09-12 14:39:39.051 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.ClassLoaderUtil : Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 2018-09-12 14:39:40.974 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.PooledConnection : Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] Instantiating driver using class: com.cloudera.impala.jdbc41.Driver [url=jdbc:impala://119.23.111.80:21050/ADM_DB;AuthMech=0;LogLevel=5;LogPath=d:\temp;] 2018-09-12 14:39:40.974 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.jdbc.pool.ClassLoaderUtil : Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 Attempting to load class[com.cloudera.impala.jdbc41.Driver] from sun.misc.Launcher$AppClassLoader@18b4aac2 2018-09-12 14:39:43.704 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.jdbc.datasource.DataSourceUtils : Returning JDBC Connection to DataSource Returning JDBC Connection to DataSource 2018-09-12 14:39:43.718 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : getResourceAsStream(fastjson.properties) getResourceAsStream(fastjson.properties) 2018-09-12 14:39:43.718 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : Delegating to parent classloader org.springframework.boot.devtools.restart.classloader.RestartClassLoader@3177f0b8 Delegating to parent classloader org.springframework.boot.devtools.restart.classloader.RestartClassLoader@3177f0b8 2018-09-12 14:39:43.718 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : Searching local repositories Searching local repositories 2018-09-12 14:39:43.719 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : --> Resource not found, returning null --> Resource not found, returning null 2018-09-12 14:39:43.767 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findResources(META-INF/services/com.alibaba.fastjson.serializer.AutowiredObjectSerializer) findResources(META-INF/services/com.alibaba.fastjson.serializer.AutowiredObjectSerializer) 2018-09-12 14:39:43.794 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findResources(META-INF/services/com.alibaba.fastjson.serializer.AutowiredObjectSerializer) findResources(META-INF/services/com.alibaba.fastjson.serializer.AutowiredObjectSerializer) 2018-09-12 14:39:43.795 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.c.loader.WebappClassLoaderBase : findResources(META-INF/services/com.alibaba.fastjson.serializer.AutowiredObjectSerializer) findResources(META-INF/services/com.alibaba.fastjson.serializer.AutowiredObjectSerializer) 2018-09-12 14:39:43.798 INFO [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] c.j.d.biz.utils.charset.bean.ChartData : chartData:{"aisxName":["2018-09-01","2018-09-02","2018-09-03","2018-09-04","2018-09-05","2018-09-06","2018-09-07","2018-09-08","2018-09-09","2018-09-10","2018-09-11"],"seriesCommon":[{"data":[0,0,0,0,0,0,0,0,0,0,2],"name":"1-3","type":"bar"},{"data":[0,0,0,0,0,0,0,0,0,0,2],"name":"4-8","type":"bar"},{"data":[0,0,0,0,0,0,0,0,0,0,0],"name":"9-以上","type":"bar"}]} chartData:{"aisxName":["2018-09-01","2018-09-02","2018-09-03","2018-09-04","2018-09-05","2018-09-06","2018-09-07","2018-09-08","2018-09-09","2018-09-10","2018-09-11"],"seriesCommon":[{"data":[0,0,0,0,0,0,0,0,0,0,2],"name":"1-3","type":"bar"},{"data":[0,0,0,0,0,0,0,0,0,0,2],"name":"4-8","type":"bar"},{"data":[0,0,0,0,0,0,0,0,0,0,0],"name":"9-以上","type":"bar"}]} 2018-09-12 14:39:43.848 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] m.m.a.RequestResponseBodyMethodProcessor : Written [com.jx.data.biz.bean.ResultBean@287f5e03] as "application/json" using [org.springframework.http.converter.json.MappingJackson2HttpMessageConverter@22fa7afc] Written [com.jx.data.biz.bean.ResultBean@287f5e03] as "application/json" using [org.springframework.http.converter.json.MappingJackson2HttpMessageConverter@22fa7afc] 2018-09-12 14:39:43.848 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : Null ModelAndView returned to DispatcherServlet with name 'dispatcherServlet': assuming HandlerAdapter completed request handling Null ModelAndView returned to DispatcherServlet with name 'dispatcherServlet': assuming HandlerAdapter completed request handling 2018-09-12 14:39:43.848 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.web.servlet.DispatcherServlet : Successfully completed request Successfully completed request 2018-09-12 14:39:43.850 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.s.b.w.f.OrderedRequestContextFilter : Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@75b3b13 Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@75b3b13 2018-09-12 14:39:43.853 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.a.tomcat.util.net.SocketWrapperBase : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@a25c617:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:54851]], Read from buffer: [0] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@a25c617:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:54851]], Read from buffer: [0] 2018-09-12 14:39:43.853 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-1] o.apache.coyote.http11.Http11Processor : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@a25c617:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:54851]], Status in: [OPEN_READ], State out: [OPEN] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@a25c617:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:54851]], Status in: [OPEN_READ], State out: [OPEN] 2018-09-12 14:40:43.856 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-6] o.apache.tomcat.util.threads.LimitLatch : Counting down[http-nio-9005-exec-6] latch=1 Counting down[http-nio-9005-exec-6] latch=1 2018-09-12 14:42:07.181 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1536734527181 sessioncount 0 Start expire sessions StandardManager at 1536734527181 sessioncount 0 2018-09-12 14:42:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 1 expired sessions: 0 End expire sessions StandardManager processingTime 1 expired sessions: 0 2018-09-12 14:45:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1536734707182 sessioncount 0 Start expire sessions StandardManager at 1536734707182 sessioncount 0 2018-09-12 14:45:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 0 expired sessions: 0 End expire sessions StandardManager processingTime 0 expired sessions: 0 2018-09-12 14:48:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1536734887182 sessioncount 0 Start expire sessions StandardManager at 1536734887182 sessioncount 0 2018-09-12 14:48:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 0 expired sessions: 0 End expire sessions StandardManager processingTime 0 expired sessions: 0 2018-09-12 14:51:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1536735067182 sessioncount 0 Start expire sessions StandardManager at 1536735067182 sessioncount 0 2018-09-12 14:51:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 0 expired sessions: 0 End expire sessions StandardManager processingTime 0 expired sessions: 0 2018-09-12 14:54:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1536735247182 sessioncount 0 Start expire sessions StandardManager at 1536735247182 sessioncount 0 2018-09-12 14:54:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 0 expired sessions: 0 End expire sessions StandardManager processingTime 0 expired sessions: 0 2018-09-12 14:57:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1536735427182 sessioncount 0 Start expire sessions StandardManager at 1536735427182 sessioncount 0 2018-09-12 14:57:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 0 expired sessions: 0 End expire sessions StandardManager processingTime 0 expired sessions: 0 2018-09-12 14:59:39.878 DEBUG [jx-data-analysis,,,] 10628 --- [9005-Acceptor-0] o.apache.tomcat.util.threads.LimitLatch : Counting up[http-nio-9005-Acceptor-0] latch=1 Counting up[http-nio-9005-Acceptor-0] latch=1 2018-09-12 14:59:39.879 DEBUG [jx-data-analysis,,,] 10628 --- [9005-Acceptor-0] o.apache.tomcat.util.threads.LimitLatch : Counting up[http-nio-9005-Acceptor-0] latch=2 Counting up[http-nio-9005-Acceptor-0] latch=2 2018-09-12 14:59:39.879 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.a.tomcat.util.net.SocketWrapperBase : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@5e3da76d:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57071]], Read from buffer: [0] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@5e3da76d:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57071]], Read from buffer: [0] 2018-09-12 14:59:39.879 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.a.coyote.http11.Http11InputBuffer : Received [GET /jx-data/joyxuan_mall/distribution/show?q_type=BUBAJRGWC000001001_COUNT&dt1=2018-09-1&dt2=2018-09-11 HTTP/1.1 Host: 127.0.0.1:9005 Connection: keep-alive Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Accept-Encoding: gzip, deflate, br Accept-Language: zh-CN,zh;q=0.9 ] Received [GET /jx-data/joyxuan_mall/distribution/show?q_type=BUBAJRGWC000001001_COUNT&dt1=2018-09-1&dt2=2018-09-11 HTTP/1.1 Host: 127.0.0.1:9005 Connection: keep-alive Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Accept-Encoding: gzip, deflate, br Accept-Language: zh-CN,zh;q=0.9 ] 2018-09-12 14:59:39.888 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.a.c.authenticator.AuthenticatorBase : Security checking request GET /jx-data/joyxuan_mall/distribution/show Security checking request GET /jx-data/joyxuan_mall/distribution/show 2018-09-12 14:59:39.888 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] org.apache.catalina.realm.RealmBase : No applicable constraints defined No applicable constraints defined 2018-09-12 14:59:39.888 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.a.c.authenticator.AuthenticatorBase : Not subject to any constraint Not subject to any constraint 2018-09-12 14:59:39.889 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.w.f.OrderedRequestContextFilter : Bound request context to thread: org.apache.catalina.connector.RequestFacade@75b3b13 Bound request context to thread: org.apache.catalina.connector.RequestFacade@75b3b13 2018-09-12 14:59:39.889 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.web.servlet.DispatcherServlet : DispatcherServlet with name 'dispatcherServlet' processing GET request for [/jx-data/joyxuan_mall/distribution/show] DispatcherServlet with name 'dispatcherServlet' processing GET request for [/jx-data/joyxuan_mall/distribution/show] 2018-09-12 14:59:39.889 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.a.e.mvc.EndpointHandlerMapping : Looking up handler method for path /joyxuan_mall/distribution/show Looking up handler method for path /joyxuan_mall/distribution/show 2018-09-12 14:59:39.893 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.a.e.mvc.EndpointHandlerMapping : Did not find handler method for [/joyxuan_mall/distribution/show] Did not find handler method for [/joyxuan_mall/distribution/show] 2018-09-12 14:59:39.893 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] s.w.s.m.m.a.RequestMappingHandlerMapping : Looking up handler method for path /joyxuan_mall/distribution/show Looking up handler method for path /joyxuan_mall/distribution/show 2018-09-12 14:59:39.893 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] s.w.s.m.m.a.RequestMappingHandlerMapping : Returning handler method [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)] Returning handler method [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)] 2018-09-12 14:59:39.893 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'distributionAnalysisController' Returning cached instance of singleton bean 'distributionAnalysisController' 2018-09-12 14:59:39.893 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.web.servlet.DispatcherServlet : Last-Modified value for [/jx-data/joyxuan_mall/distribution/show] is: -1 Last-Modified value for [/jx-data/joyxuan_mall/distribution/show] is: -1 2018-09-12 14:59:39.894 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] org.apache.tomcat.util.http.Parameters : Set encoding to UTF-8 Set encoding to UTF-8 2018-09-12 14:59:39.894 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] org.apache.tomcat.util.http.Parameters : Decoding query null UTF-8 Decoding query null UTF-8 2018-09-12 14:59:39.894 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] org.apache.tomcat.util.http.Parameters : Start processing with input [q_type=BUBAJRGWC000001001_COUNT&dt1=2018-09-1&dt2=2018-09-11] Start processing with input [q_type=BUBAJRGWC000001001_COUNT&dt1=2018-09-1&dt2=2018-09-11] 2018-09-12 14:59:39.895 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.core.JdbcTemplate : Executing SQL query [select dict_type,dict_key,dict_value from data_dict where status=0 and dict_type='distr_analysis_ranges_count' order by dict_order asc ] Executing SQL query [select dict_type,dict_key,dict_value from data_dict where status=0 and dict_type='distr_analysis_ranges_count' order by dict_order asc ] 2018-09-12 14:59:39.895 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.datasource.DataSourceUtils : Fetching JDBC Connection from DataSource Fetching JDBC Connection from DataSource 2018-09-12 14:59:39.906 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.core.BeanPropertyRowMapper : Mapping column 'dict_type' to property 'dict_type' of type 'java.lang.String' Mapping column 'dict_type' to property 'dict_type' of type 'java.lang.String' 2018-09-12 14:59:39.907 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.core.BeanPropertyRowMapper : Mapping column 'dict_key' to property 'dict_key' of type 'java.lang.String' Mapping column 'dict_key' to property 'dict_key' of type 'java.lang.String' 2018-09-12 14:59:39.907 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.core.BeanPropertyRowMapper : Mapping column 'dict_value' to property 'dict_value' of type 'java.lang.String' Mapping column 'dict_value' to property 'dict_value' of type 'java.lang.String' 2018-09-12 14:59:39.914 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.datasource.DataSourceUtils : Returning JDBC Connection to DataSource Returning JDBC Connection to DataSource 2018-09-12 14:59:39.914 INFO [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] c.j.d.biz.deal.service.DealDataService : sql:>>> select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc param=[] sql:>>> select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc param=[] 2018-09-12 14:59:39.914 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL query Executing prepared SQL query 2018-09-12 14:59:39.914 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL statement [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ] Executing prepared SQL statement [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ] 2018-09-12 14:59:39.914 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.datasource.DataSourceUtils : Fetching JDBC Connection from DataSource Fetching JDBC Connection from DataSource 2018-09-12 14:59:39.927 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.datasource.DataSourceUtils : Returning JDBC Connection to DataSource Returning JDBC Connection to DataSource 2018-09-12 14:59:39.947 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.core.env.StandardEnvironment : Adding PropertySource 'systemProperties' with lowest search precedence Adding PropertySource 'systemProperties' with lowest search precedence 2018-09-12 14:59:39.947 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.core.env.StandardEnvironment : Adding PropertySource 'systemEnvironment' with lowest search precedence Adding PropertySource 'systemEnvironment' with lowest search precedence 2018-09-12 14:59:39.947 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.core.env.StandardEnvironment : Initialized StandardEnvironment with PropertySources [MapPropertySource@1746138068 {name='systemProperties', properties={java.runtime.name=Java(TM) SE Runtime Environment, sun.rmi.transport.tcp.responseTimeout=8000, sun.boot.library.path=D:\soft\package\jdk1.8.0_172\jre\bin, java.vm.version=25.172-b11, java.vm.vendor=Oracle Corporation, java.vendor.url=http://java.oracle.com/, path.separator=;, java.vm.name=Java HotSpot(TM) 64-Bit Server VM, file.encoding.pkg=sun.io, user.country=CN, user.script=, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=Service Pack 1, PID=10628, java.vm.specification.name=Java Virtual Machine Specification, user.dir=D:\gitpro\jx-data-analysis, java.runtime.version=1.8.0_172-b11, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, org.jboss.logging.provider=slf4j, java.endorsed.dirs=D:\soft\package\jdk1.8.0_172\jre\lib\endorsed, os.arch=amd64, java.io.tmpdir=C:\Users\ADMINI~1\AppData\Local\Temp\, line.separator= , java.vm.specification.vendor=Oracle Corporation, user.variant=, os.name=Windows 7, sun.jnu.encoding=GBK, spring.beaninfo.ignore=true, java.library.path=D:\soft\package\jdk1.8.0_172\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;D:/soft/package/jdk1.8.0_172/bin/../jre/bin/server;D:/soft/package/jdk1.8.0_172/bin/../jre/bin;D:/soft/package/jdk1.8.0_172/bin/../jre/lib/amd64;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\soft\package\jdk1.8.0_172\bin;D:\soft\package\apache-maven-3.5.4\bin;D:\soft\package\jdk1.8.0_172\jre\bin;C:\Program Files\Git\cmd;D:\soft\package\hadoop-2.2.0\bin;C:\Users\Administrator\AppData\Local\Programs\Fiddler;D:\soft\package\oxygen-eclipse;;., java.specification.name=Java Platform API Specification, java.class.version=52.0, sun.management.compiler=HotSpot 64-Bit Tiered Compilers, os.version=6.1, LOG_FILE=/webdata/logs/spring.log, user.home=C:\Users\Administrator, catalina.useNaming=false, user.timezone=Asia/Shanghai, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=UTF-8, java.specification.version=1.8, catalina.home=C:\Users\Administrator\AppData\Local\Temp\tomcat.6706552140480160635.9005, java.class.path=D:\soft\package\jdk1.8.0_172\jre\lib\resources.jar;D:\soft\package\jdk1.8.0_172\jre\lib\rt.jar;D:\soft\package\jdk1.8.0_172\jre\lib\jsse.jar;D:\soft\package\jdk1.8.0_172\jre\lib\jce.jar;D:\soft\package\jdk1.8.0_172\jre\lib\charsets.jar;D:\soft\package\jdk1.8.0_172\jre\lib\jfr.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\access-bridge-64.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\cldrdata.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\dnsns.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\jaccess.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\jfxrt.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\localedata.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\nashorn.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\sunec.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\sunjce_provider.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\sunmscapi.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\sunpkcs11.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\zipfs.jar;D:\gitpro\jx-data-analysis\target\classes;D:\soft\package\jdk1.8.0_172\lib\jconsole.jar;D:\soft\package\jdk1.8.0_172\lib\tools.jar;D:\gitpro\jx-data-analysis\lib\ImpalaJDBC41.jar;D:\gitpro\jx-data-analysis\lib\TCLIServiceClient.jar;C:\Users\Administrator\.m2\repository\com\univocity\univocity-parsers\2.7.5\univocity-parsers-2.7.5.jar;C:\Users\Administrator\.m2\repository\org\apache\poi\poi\3.17\poi-3.17.jar;C:\Users\Administrator\.m2\repository\commons-codec\commons-codec\1.10\commons-codec-1.10.jar;C:\Users\Administrator\.m2\repository\org\apache\commons\commons-collections4\4.1\commons-collections4-4.1.jar;C:\Users\Administrator\.m2\repository\org\apache\poi\poi-ooxml\3.17\poi-ooxml-3.17.jar;C:\Users\Administrator\.m2\repository\org\apache\poi\poi-ooxml-schemas\3.17\poi-ooxml-schemas-3.17.jar;C:\Users\Administrator\.m2\repository\org\apache\xmlbeans\xmlbeans\2.6.0\xmlbeans-2.6.0.jar;C:\Users\Administrator\.m2\repository\stax\stax-api\1.0.1\stax-api-1.0.1.jar;C:\Users\Administrator\.m2\repository\com\github\virtuald\curvesapi\1.04\curvesapi-1.04.jar;C:\Users\Administrator\.m2\repository\org\apache\thrift\libfb303\0.9.3\libfb303-0.9.3.jar;C:\Users\Administrator\.m2\repository\org\apache\thrift\libthrift\0.9.3\libthrift-0.9.3.jar;C:\Users\Administrator\.m2\repository\org\apache\httpcomponents\httpcore\4.4.8\httpcore-4.4.8.jar;C:\Users\Administrator\.m2\repository\ch\qos\logback\logback-core\1.1.3\logback-core-1.1.3.jar;C:\Users\Administrator\.m2\repository\ch\qos\logback\logback-classic\1.1.3\logback-classic-1.1.3.jar;C:\Users\Administrator\.m2\repository\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter-web\1.5.8.RELEASE\spring-boot-starter-web-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter\1.5.8.RELEASE\spring-boot-starter-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\yaml\snakeyaml\1.17\snakeyaml-1.17.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\1.5.8.RELEASE\spring-boot-starter-tomcat-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\8.5.23\tomcat-embed-core-8.5.23.jar;C:\Users\Administrator\.m2\repository\org\apache\tomcat\tomcat-annotations-api\8.5.23\tomcat-annotations-api-8.5.23.jar;C:\Users\Administrator\.m2\repository\org\apache\tomcat\embed\tomcat-embed-el\8.5.23\tomcat-embed-el-8.5.23.jar;C:\Users\Administrator\.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.23\tomcat-embed-websocket-8.5.23.jar;C:\Users\Administrator\.m2\repository\org\hibernate\hibernate-validator\5.3.5.Final\hibernate-validator-5.3.5.Final.jar;C:\Users\Administrator\.m2\repository\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;C:\Users\Administrator\.m2\repository\org\jboss\logging\jboss-logging\3.3.1.Final\jboss-logging-3.3.1.Final.jar;C:\Users\Administrator\.m2\repository\com\fasterxml\classmate\1.3.4\classmate-1.3.4.jar;C:\Users\Administrator\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.8.10\jackson-databind-2.8.10.jar;C:\Users\Administrator\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.8.0\jackson-annotations-2.8.0.jar;C:\Users\Administrator\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.8.10\jackson-core-2.8.10.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-web\4.3.12.RELEASE\spring-web-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-aop\4.3.12.RELEASE\spring-aop-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-beans\4.3.12.RELEASE\spring-beans-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-context\4.3.12.RELEASE\spring-context-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-webmvc\4.3.12.RELEASE\spring-webmvc-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-expression\4.3.12.RELEASE\spring-expression-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-devtools\1.5.8.RELEASE\spring-boot-devtools-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot\1.5.8.RELEASE\spring-boot-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-autoconfigure\1.5.8.RELEASE\spring-boot-autoconfigure-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter-actuator\1.5.8.RELEASE\spring-boot-starter-actuator-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-actuator\1.5.8.RELEASE\spring-boot-actuator-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter-data-redis\1.5.8.RELEASE\spring-boot-starter-data-redis-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\data\spring-data-redis\1.8.8.RELEASE\spring-data-redis-1.8.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\data\spring-data-keyvalue\1.2.8.RELEASE\spring-data-keyvalue-1.2.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\data\spring-data-commons\1.13.8.RELEASE\spring-data-commons-1.13.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-tx\4.3.12.RELEASE\spring-tx-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-oxm\4.3.12.RELEASE\spring-oxm-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-context-support\4.3.12.RELEASE\spring-context-support-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\redis\clients\jedis\2.9.0\jedis-2.9.0.jar;C:\Users\Administrator\.m2\repository\org\apache\commons\commons-pool2\2.4.2\commons-pool2-2.4.2.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter-log4j\1.3.8.RELEASE\spring-boot-starter-log4j-1.3.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\slf4j\jcl-over-slf4j\1.7.25\jcl-over-slf4j-1.7.25.jar;C:\Users\Administrator\.m2\repository\org\slf4j\jul-to-slf4j\1.7.25\jul-to-slf4j-1.7.25.jar;C:\Users\Administrator\.m2\repository\org\slf4j\slf4j-log4j12\1.7.25\slf4j-log4j12-1.7.25.jar;C:\Users\Administrator\.m2\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;C:\Users\Administrator\.m2\repository\org\springframework\kafka\spring-kafka\1.1.7.RELEASE\spring-kafka-1.1.7.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-messaging\4.3.12.RELEASE\spring-messaging-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\retry\spring-retry\1.2.1.RELEASE\spring-retry-1.2.1.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\apache\kafka\kafka-clients\0.10.1.1\kafka-clients-0.10.1.1.jar;C:\Users\Administrator\.m2\repository\net\jpountz\lz4\lz4\1.3.0\lz4-1.3.0.jar;C:\Users\Administrator\.m2\repository\org\xerial\snappy\snappy-java\1.1.2.6\snappy-java-1.1.2.6.jar;C:\Users\Administrator\.m2\repository\junit\junit\4.12\junit-4.12.jar;C:\Users\Administrator\.m2\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-core\4.3.12.RELEASE\spring-core-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\com\101tec\zkclient\0.10\zkclient-0.10.jar;C:\Users\Administrator\.m2\repository\org\apache\zookeeper\zookeeper\3.4.11\zookeeper-3.4.11.jar;C:\Users\Administrator\.m2\repository\jline\jline\0.9.94\jline-0.9.94.jar;C:\Users\Administrator\.m2\repository\org\apache\yetus\audience-annotations\0.5.0\audience-annotations-0.5.0.jar;C:\Users\Administrator\.m2\repository\io\netty\netty\3.10.5.Final\netty-3.10.5.Final.jar;D:\gitpro\jx-common-util\target\classes;C:\Users\Administrator\.m2\repository\net\logstash\logback\logstash-logback-encoder\4.7\logstash-logback-encoder-4.7.jar;C:\Users\Administrator\.m2\repository\org\projectlombok\lombok\1.16.18\lombok-1.16.18.jar;C:\Users\Administrator\.m2\repository\com\alibaba\druid\1.0.26\druid-1.0.26.jar;C:\Users\Administrator\.m2\repository\mysql\mysql-connector-java\5.1.44\mysql-connector-java-5.1.44.jar;C:\Users\Administrator\.m2\repository\com\alibaba\fastjson\1.2.29\fastjson-1.2.29.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter-jdbc\1.5.8.RELEASE\spring-boot-starter-jdbc-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\apache\tomcat\tomcat-jdbc\8.5.23\tomcat-jdbc-8.5.23.jar;C:\Users\Administrator\.m2\repository\org\apache\tomcat\tomcat-juli\8.5.23\tomcat-juli-8.5.23.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-jdbc\4.3.12.RELEASE\spring-jdbc-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\apache\commons\commons-lang3\3.1\commons-lang3-3.1.jar;C:\Users\Administrator\.m2\repository\com\github\qiujiayu\autoload-cache\5.1\autoload-cache-5.1.jar;C:\Users\Administrator\.m2\repository\org\ow2\asm\asm-all\5.1\asm-all-5.1.jar;C:\Users\Administrator\.m2\repository\org\apache\httpcomponents\httpclient\4.5.3\httpclient-4.5.3.jar;C:\Users\Administrator\.m2\repository\com\aliyun\aliyun-java-sdk-core\3.0.0\aliyun-java-sdk-core-3.0.0.jar;C:\Users\Administrator\.m2\repository\com\aliyun\aliyun-java-sdk-dm\3.1.0\aliyun-java-sdk-dm-3.1.0.jar;C:\Users\Administrator\.m2\repository\com\caucho\hessian\4.0.51\hessian-4.0.51.jar;C:\Users\Administrator\.m2\repository\com\alibaba\dubbo\2.5.7\dubbo-2.5.7.jar;C:\Users\Administrator\.m2\repository\org\javassist\javassist\3.21.0-GA\javassist-3.21.0-GA.jar;C:\Users\Administrator\.m2\repository\org\jboss\netty\netty\3.2.5.Final\netty-3.2.5.Final.jar;C:\Users\Administrator\.m2\repository\io\zipkin\brave\brave-core\3.11.1\brave-core-3.11.1.jar;C:\Users\Administrator\.m2\repository\io\zipkin\java\zipkin\1.11.1\zipkin-1.11.1.jar;C:\Users\Administrator\.m2\repository\io\zipkin\brave\brave-dubbo\1.0.0-SNAPSHOT\brave-dubbo-1.0.0-SNAPSHOT.jar;C:\Users\Administrator\.m2\repository\io\zipkin\brave\brave-spancollector-http\3.9.0\brave-spancollector-http-3.9.0.jar;C:\Users\Administrator\.m2\repository\com\github\kristofa\brave-core\3.7.0\brave-core-3.7.0.jar, user.name=Administrator, java.vm.specification.version=1.8, sun.java.command=com.jx.data.JxDataAnalysisServer, java.home=D:\soft\package\jdk1.8.0_172\jre, sun.arch.data.model=64, user.language=zh, java.specification.vendor=Oracle Corporation, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.8.0_172, java.ext.dirs=D:\soft\package\jdk1.8.0_172\jre\lib\ext;C:\Windows\Sun\Java\lib\ext, sun.boot.class.path=D:\soft\package\jdk1.8.0_172\jre\lib\resources.jar;D:\soft\package\jdk1.8.0_172\jre\lib\rt.jar;D:\soft\package\jdk1.8.0_172\jre\lib\sunrsasign.jar;D:\soft\package\jdk1.8.0_172\jre\lib\jsse.jar;D:\soft\package\jdk1.8.0_172\jre\lib\jce.jar;D:\soft\package\jdk1.8.0_172\jre\lib\charsets.jar;D:\soft\package\jdk1.8.0_172\jre\lib\jfr.jar;D:\soft\package\jdk1.8.0_172\jre\classes, java.awt.headless=true, java.vendor=Oracle Corporation, catalina.base=C:\Users\Administrator\AppData\Local\Temp\tomcat.6706552140480160635.9005, file.separator=\, java.vendor.url.bug=http://bugreport.sun.com/bugreport/, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, LOG_PATH=/webdata/logs, sun.desktop=windows, sun.cpu.isalist=amd64}}, SystemEnvironmentPropertySource@573740208 {name='systemEnvironment', properties={PATH=D:/soft/package/jdk1.8.0_172/bin/../jre/bin/server;D:/soft/package/jdk1.8.0_172/bin/../jre/bin;D:/soft/package/jdk1.8.0_172/bin/../jre/lib/amd64;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\soft\package\jdk1.8.0_172\bin;D:\soft\package\apache-maven-3.5.4\bin;D:\soft\package\jdk1.8.0_172\jre\bin;C:\Program Files\Git\cmd;D:\soft\package\hadoop-2.2.0\bin;C:\Users\Administrator\AppData\Local\Programs\Fiddler;D:\soft\package\oxygen-eclipse;, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, PROCESSOR_LEVEL=6, SYSTEMDRIVE=C:, COMMONPROGRAMFILES(X86)=C:\Program Files (x86)\Common Files, FP_NO_HOST_CHECK=NO, USERDOMAIN=PC-20180724HMED, LOGONSERVER=\\PC-20180724HMED, JAVA_HOME=D:\soft\package\jdk1.8.0_172, PROMPT=$P$G, SESSIONNAME=Console, ALLUSERSPROFILE=C:\ProgramData, PROGRAMFILES(X86)=C:\Program Files (x86), PROCESSOR_ARCHITECTURE=AMD64, MAVEN_HOME=D:\soft\package\apache-maven-3.5.4, PROGRAMFILES=C:\Program Files, WINDOWS_TRACING_FLAGS=3, APPDATA=C:\Users\Administrator\AppData\Roaming, PSMODULEPATH=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, PROGRAMW6432=C:\Program Files, PROGRAMDATA=C:\ProgramData, SYSTEMROOT=C:\Windows, USERNAME=Administrator, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, OS=Windows_NT, COMMONPROGRAMW6432=C:\Program Files\Common Files, COMPUTERNAME=PC-20180724HMED, COMMONPROGRAMFILES=C:\Program Files\Common Files, COMSPEC=C:\Windows\system32\cmd.exe, _DFX_INSTALL_UNSIGNED_DRIVER=1, PROCESSOR_REVISION=9e09, CLASSPATH=.;D:\soft\package\jdk1.8.0_172\lib;D:\soft\package\jdk1.8.0_172\lib\tools.jar, WINDIR=C:\Windows, HOMEPATH=\Users\Administrator, TEMP=C:\Users\ADMINI~1\AppData\Local\Temp, HOMEDRIVE=C:, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 158 Stepping 9, GenuineIntel, USERPROFILE=C:\Users\Administrator, TMP=C:\Users\ADMINI~1\AppData\Local\Temp, WINDOWS_TRACING_LOGFILE=C:\BVTBin\Tests\installpackage\csilogfile.log, HADOOP_HOME=D:\soft\package\hadoop-2.2.0, PUBLIC=C:\Users\Public, NUMBER_OF_PROCESSORS=4}}] Initialized StandardEnvironment with PropertySources [MapPropertySource@1746138068 {name='systemProperties', properties={java.runtime.name=Java(TM) SE Runtime Environment, sun.rmi.transport.tcp.responseTimeout=8000, sun.boot.library.path=D:\soft\package\jdk1.8.0_172\jre\bin, java.vm.version=25.172-b11, java.vm.vendor=Oracle Corporation, java.vendor.url=http://java.oracle.com/, path.separator=;, java.vm.name=Java HotSpot(TM) 64-Bit Server VM, file.encoding.pkg=sun.io, user.country=CN, user.script=, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=Service Pack 1, PID=10628, java.vm.specification.name=Java Virtual Machine Specification, user.dir=D:\gitpro\jx-data-analysis, java.runtime.version=1.8.0_172-b11, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, org.jboss.logging.provider=slf4j, java.endorsed.dirs=D:\soft\package\jdk1.8.0_172\jre\lib\endorsed, os.arch=amd64, java.io.tmpdir=C:\Users\ADMINI~1\AppData\Local\Temp\, line.separator= , java.vm.specification.vendor=Oracle Corporation, user.variant=, os.name=Windows 7, sun.jnu.encoding=GBK, spring.beaninfo.ignore=true, java.library.path=D:\soft\package\jdk1.8.0_172\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;D:/soft/package/jdk1.8.0_172/bin/../jre/bin/server;D:/soft/package/jdk1.8.0_172/bin/../jre/bin;D:/soft/package/jdk1.8.0_172/bin/../jre/lib/amd64;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\soft\package\jdk1.8.0_172\bin;D:\soft\package\apache-maven-3.5.4\bin;D:\soft\package\jdk1.8.0_172\jre\bin;C:\Program Files\Git\cmd;D:\soft\package\hadoop-2.2.0\bin;C:\Users\Administrator\AppData\Local\Programs\Fiddler;D:\soft\package\oxygen-eclipse;;., java.specification.name=Java Platform API Specification, java.class.version=52.0, sun.management.compiler=HotSpot 64-Bit Tiered Compilers, os.version=6.1, LOG_FILE=/webdata/logs/spring.log, user.home=C:\Users\Administrator, catalina.useNaming=false, user.timezone=Asia/Shanghai, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=UTF-8, java.specification.version=1.8, catalina.home=C:\Users\Administrator\AppData\Local\Temp\tomcat.6706552140480160635.9005, java.class.path=D:\soft\package\jdk1.8.0_172\jre\lib\resources.jar;D:\soft\package\jdk1.8.0_172\jre\lib\rt.jar;D:\soft\package\jdk1.8.0_172\jre\lib\jsse.jar;D:\soft\package\jdk1.8.0_172\jre\lib\jce.jar;D:\soft\package\jdk1.8.0_172\jre\lib\charsets.jar;D:\soft\package\jdk1.8.0_172\jre\lib\jfr.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\access-bridge-64.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\cldrdata.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\dnsns.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\jaccess.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\jfxrt.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\localedata.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\nashorn.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\sunec.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\sunjce_provider.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\sunmscapi.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\sunpkcs11.jar;D:\soft\package\jdk1.8.0_172\jre\lib\ext\zipfs.jar;D:\gitpro\jx-data-analysis\target\classes;D:\soft\package\jdk1.8.0_172\lib\jconsole.jar;D:\soft\package\jdk1.8.0_172\lib\tools.jar;D:\gitpro\jx-data-analysis\lib\ImpalaJDBC41.jar;D:\gitpro\jx-data-analysis\lib\TCLIServiceClient.jar;C:\Users\Administrator\.m2\repository\com\univocity\univocity-parsers\2.7.5\univocity-parsers-2.7.5.jar;C:\Users\Administrator\.m2\repository\org\apache\poi\poi\3.17\poi-3.17.jar;C:\Users\Administrator\.m2\repository\commons-codec\commons-codec\1.10\commons-codec-1.10.jar;C:\Users\Administrator\.m2\repository\org\apache\commons\commons-collections4\4.1\commons-collections4-4.1.jar;C:\Users\Administrator\.m2\repository\org\apache\poi\poi-ooxml\3.17\poi-ooxml-3.17.jar;C:\Users\Administrator\.m2\repository\org\apache\poi\poi-ooxml-schemas\3.17\poi-ooxml-schemas-3.17.jar;C:\Users\Administrator\.m2\repository\org\apache\xmlbeans\xmlbeans\2.6.0\xmlbeans-2.6.0.jar;C:\Users\Administrator\.m2\repository\stax\stax-api\1.0.1\stax-api-1.0.1.jar;C:\Users\Administrator\.m2\repository\com\github\virtuald\curvesapi\1.04\curvesapi-1.04.jar;C:\Users\Administrator\.m2\repository\org\apache\thrift\libfb303\0.9.3\libfb303-0.9.3.jar;C:\Users\Administrator\.m2\repository\org\apache\thrift\libthrift\0.9.3\libthrift-0.9.3.jar;C:\Users\Administrator\.m2\repository\org\apache\httpcomponents\httpcore\4.4.8\httpcore-4.4.8.jar;C:\Users\Administrator\.m2\repository\ch\qos\logback\logback-core\1.1.3\logback-core-1.1.3.jar;C:\Users\Administrator\.m2\repository\ch\qos\logback\logback-classic\1.1.3\logback-classic-1.1.3.jar;C:\Users\Administrator\.m2\repository\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter-web\1.5.8.RELEASE\spring-boot-starter-web-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter\1.5.8.RELEASE\spring-boot-starter-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\yaml\snakeyaml\1.17\snakeyaml-1.17.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\1.5.8.RELEASE\spring-boot-starter-tomcat-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\8.5.23\tomcat-embed-core-8.5.23.jar;C:\Users\Administrator\.m2\repository\org\apache\tomcat\tomcat-annotations-api\8.5.23\tomcat-annotations-api-8.5.23.jar;C:\Users\Administrator\.m2\repository\org\apache\tomcat\embed\tomcat-embed-el\8.5.23\tomcat-embed-el-8.5.23.jar;C:\Users\Administrator\.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.23\tomcat-embed-websocket-8.5.23.jar;C:\Users\Administrator\.m2\repository\org\hibernate\hibernate-validator\5.3.5.Final\hibernate-validator-5.3.5.Final.jar;C:\Users\Administrator\.m2\repository\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;C:\Users\Administrator\.m2\repository\org\jboss\logging\jboss-logging\3.3.1.Final\jboss-logging-3.3.1.Final.jar;C:\Users\Administrator\.m2\repository\com\fasterxml\classmate\1.3.4\classmate-1.3.4.jar;C:\Users\Administrator\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.8.10\jackson-databind-2.8.10.jar;C:\Users\Administrator\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.8.0\jackson-annotations-2.8.0.jar;C:\Users\Administrator\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.8.10\jackson-core-2.8.10.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-web\4.3.12.RELEASE\spring-web-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-aop\4.3.12.RELEASE\spring-aop-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-beans\4.3.12.RELEASE\spring-beans-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-context\4.3.12.RELEASE\spring-context-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-webmvc\4.3.12.RELEASE\spring-webmvc-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-expression\4.3.12.RELEASE\spring-expression-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-devtools\1.5.8.RELEASE\spring-boot-devtools-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot\1.5.8.RELEASE\spring-boot-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-autoconfigure\1.5.8.RELEASE\spring-boot-autoconfigure-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter-actuator\1.5.8.RELEASE\spring-boot-starter-actuator-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-actuator\1.5.8.RELEASE\spring-boot-actuator-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter-data-redis\1.5.8.RELEASE\spring-boot-starter-data-redis-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\data\spring-data-redis\1.8.8.RELEASE\spring-data-redis-1.8.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\data\spring-data-keyvalue\1.2.8.RELEASE\spring-data-keyvalue-1.2.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\data\spring-data-commons\1.13.8.RELEASE\spring-data-commons-1.13.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-tx\4.3.12.RELEASE\spring-tx-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-oxm\4.3.12.RELEASE\spring-oxm-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-context-support\4.3.12.RELEASE\spring-context-support-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\redis\clients\jedis\2.9.0\jedis-2.9.0.jar;C:\Users\Administrator\.m2\repository\org\apache\commons\commons-pool2\2.4.2\commons-pool2-2.4.2.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter-log4j\1.3.8.RELEASE\spring-boot-starter-log4j-1.3.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\slf4j\jcl-over-slf4j\1.7.25\jcl-over-slf4j-1.7.25.jar;C:\Users\Administrator\.m2\repository\org\slf4j\jul-to-slf4j\1.7.25\jul-to-slf4j-1.7.25.jar;C:\Users\Administrator\.m2\repository\org\slf4j\slf4j-log4j12\1.7.25\slf4j-log4j12-1.7.25.jar;C:\Users\Administrator\.m2\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;C:\Users\Administrator\.m2\repository\org\springframework\kafka\spring-kafka\1.1.7.RELEASE\spring-kafka-1.1.7.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-messaging\4.3.12.RELEASE\spring-messaging-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\springframework\retry\spring-retry\1.2.1.RELEASE\spring-retry-1.2.1.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\apache\kafka\kafka-clients\0.10.1.1\kafka-clients-0.10.1.1.jar;C:\Users\Administrator\.m2\repository\net\jpountz\lz4\lz4\1.3.0\lz4-1.3.0.jar;C:\Users\Administrator\.m2\repository\org\xerial\snappy\snappy-java\1.1.2.6\snappy-java-1.1.2.6.jar;C:\Users\Administrator\.m2\repository\junit\junit\4.12\junit-4.12.jar;C:\Users\Administrator\.m2\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-core\4.3.12.RELEASE\spring-core-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\com\101tec\zkclient\0.10\zkclient-0.10.jar;C:\Users\Administrator\.m2\repository\org\apache\zookeeper\zookeeper\3.4.11\zookeeper-3.4.11.jar;C:\Users\Administrator\.m2\repository\jline\jline\0.9.94\jline-0.9.94.jar;C:\Users\Administrator\.m2\repository\org\apache\yetus\audience-annotations\0.5.0\audience-annotations-0.5.0.jar;C:\Users\Administrator\.m2\repository\io\netty\netty\3.10.5.Final\netty-3.10.5.Final.jar;D:\gitpro\jx-common-util\target\classes;C:\Users\Administrator\.m2\repository\net\logstash\logback\logstash-logback-encoder\4.7\logstash-logback-encoder-4.7.jar;C:\Users\Administrator\.m2\repository\org\projectlombok\lombok\1.16.18\lombok-1.16.18.jar;C:\Users\Administrator\.m2\repository\com\alibaba\druid\1.0.26\druid-1.0.26.jar;C:\Users\Administrator\.m2\repository\mysql\mysql-connector-java\5.1.44\mysql-connector-java-5.1.44.jar;C:\Users\Administrator\.m2\repository\com\alibaba\fastjson\1.2.29\fastjson-1.2.29.jar;C:\Users\Administrator\.m2\repository\org\springframework\boot\spring-boot-starter-jdbc\1.5.8.RELEASE\spring-boot-starter-jdbc-1.5.8.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\apache\tomcat\tomcat-jdbc\8.5.23\tomcat-jdbc-8.5.23.jar;C:\Users\Administrator\.m2\repository\org\apache\tomcat\tomcat-juli\8.5.23\tomcat-juli-8.5.23.jar;C:\Users\Administrator\.m2\repository\org\springframework\spring-jdbc\4.3.12.RELEASE\spring-jdbc-4.3.12.RELEASE.jar;C:\Users\Administrator\.m2\repository\org\apache\commons\commons-lang3\3.1\commons-lang3-3.1.jar;C:\Users\Administrator\.m2\repository\com\github\qiujiayu\autoload-cache\5.1\autoload-cache-5.1.jar;C:\Users\Administrator\.m2\repository\org\ow2\asm\asm-all\5.1\asm-all-5.1.jar;C:\Users\Administrator\.m2\repository\org\apache\httpcomponents\httpclient\4.5.3\httpclient-4.5.3.jar;C:\Users\Administrator\.m2\repository\com\aliyun\aliyun-java-sdk-core\3.0.0\aliyun-java-sdk-core-3.0.0.jar;C:\Users\Administrator\.m2\repository\com\aliyun\aliyun-java-sdk-dm\3.1.0\aliyun-java-sdk-dm-3.1.0.jar;C:\Users\Administrator\.m2\repository\com\caucho\hessian\4.0.51\hessian-4.0.51.jar;C:\Users\Administrator\.m2\repository\com\alibaba\dubbo\2.5.7\dubbo-2.5.7.jar;C:\Users\Administrator\.m2\repository\org\javassist\javassist\3.21.0-GA\javassist-3.21.0-GA.jar;C:\Users\Administrator\.m2\repository\org\jboss\netty\netty\3.2.5.Final\netty-3.2.5.Final.jar;C:\Users\Administrator\.m2\repository\io\zipkin\brave\brave-core\3.11.1\brave-core-3.11.1.jar;C:\Users\Administrator\.m2\repository\io\zipkin\java\zipkin\1.11.1\zipkin-1.11.1.jar;C:\Users\Administrator\.m2\repository\io\zipkin\brave\brave-dubbo\1.0.0-SNAPSHOT\brave-dubbo-1.0.0-SNAPSHOT.jar;C:\Users\Administrator\.m2\repository\io\zipkin\brave\brave-spancollector-http\3.9.0\brave-spancollector-http-3.9.0.jar;C:\Users\Administrator\.m2\repository\com\github\kristofa\brave-core\3.7.0\brave-core-3.7.0.jar, user.name=Administrator, java.vm.specification.version=1.8, sun.java.command=com.jx.data.JxDataAnalysisServer, java.home=D:\soft\package\jdk1.8.0_172\jre, sun.arch.data.model=64, user.language=zh, java.specification.vendor=Oracle Corporation, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.8.0_172, java.ext.dirs=D:\soft\package\jdk1.8.0_172\jre\lib\ext;C:\Windows\Sun\Java\lib\ext, sun.boot.class.path=D:\soft\package\jdk1.8.0_172\jre\lib\resources.jar;D:\soft\package\jdk1.8.0_172\jre\lib\rt.jar;D:\soft\package\jdk1.8.0_172\jre\lib\sunrsasign.jar;D:\soft\package\jdk1.8.0_172\jre\lib\jsse.jar;D:\soft\package\jdk1.8.0_172\jre\lib\jce.jar;D:\soft\package\jdk1.8.0_172\jre\lib\charsets.jar;D:\soft\package\jdk1.8.0_172\jre\lib\jfr.jar;D:\soft\package\jdk1.8.0_172\jre\classes, java.awt.headless=true, java.vendor=Oracle Corporation, catalina.base=C:\Users\Administrator\AppData\Local\Temp\tomcat.6706552140480160635.9005, file.separator=\, java.vendor.url.bug=http://bugreport.sun.com/bugreport/, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, LOG_PATH=/webdata/logs, sun.desktop=windows, sun.cpu.isalist=amd64}}, SystemEnvironmentPropertySource@573740208 {name='systemEnvironment', properties={PATH=D:/soft/package/jdk1.8.0_172/bin/../jre/bin/server;D:/soft/package/jdk1.8.0_172/bin/../jre/bin;D:/soft/package/jdk1.8.0_172/bin/../jre/lib/amd64;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\soft\package\jdk1.8.0_172\bin;D:\soft\package\apache-maven-3.5.4\bin;D:\soft\package\jdk1.8.0_172\jre\bin;C:\Program Files\Git\cmd;D:\soft\package\hadoop-2.2.0\bin;C:\Users\Administrator\AppData\Local\Programs\Fiddler;D:\soft\package\oxygen-eclipse;, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, PROCESSOR_LEVEL=6, SYSTEMDRIVE=C:, COMMONPROGRAMFILES(X86)=C:\Program Files (x86)\Common Files, FP_NO_HOST_CHECK=NO, USERDOMAIN=PC-20180724HMED, LOGONSERVER=\\PC-20180724HMED, JAVA_HOME=D:\soft\package\jdk1.8.0_172, PROMPT=$P$G, SESSIONNAME=Console, ALLUSERSPROFILE=C:\ProgramData, PROGRAMFILES(X86)=C:\Program Files (x86), PROCESSOR_ARCHITECTURE=AMD64, MAVEN_HOME=D:\soft\package\apache-maven-3.5.4, PROGRAMFILES=C:\Program Files, WINDOWS_TRACING_FLAGS=3, APPDATA=C:\Users\Administrator\AppData\Roaming, PSMODULEPATH=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, PROGRAMW6432=C:\Program Files, PROGRAMDATA=C:\ProgramData, SYSTEMROOT=C:\Windows, USERNAME=Administrator, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, OS=Windows_NT, COMMONPROGRAMW6432=C:\Program Files\Common Files, COMPUTERNAME=PC-20180724HMED, COMMONPROGRAMFILES=C:\Program Files\Common Files, COMSPEC=C:\Windows\system32\cmd.exe, _DFX_INSTALL_UNSIGNED_DRIVER=1, PROCESSOR_REVISION=9e09, CLASSPATH=.;D:\soft\package\jdk1.8.0_172\lib;D:\soft\package\jdk1.8.0_172\lib\tools.jar, WINDIR=C:\Windows, HOMEPATH=\Users\Administrator, TEMP=C:\Users\ADMINI~1\AppData\Local\Temp, HOMEDRIVE=C:, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 158 Stepping 9, GenuineIntel, USERPROFILE=C:\Users\Administrator, TMP=C:\Users\ADMINI~1\AppData\Local\Temp, WINDOWS_TRACING_LOGFILE=C:\BVTBin\Tests\installpackage\csilogfile.log, HADOOP_HOME=D:\soft\package\hadoop-2.2.0, PUBLIC=C:\Users\Public, NUMBER_OF_PROCESSORS=4}}] 2018-09-12 14:59:39.948 INFO [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.xml.XmlBeanDefinitionReader : Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml] Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml] 2018-09-12 14:59:39.949 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.a.c.loader.WebappClassLoaderBase : findResources(META-INF/services/javax.xml.parsers.DocumentBuilderFactory) findResources(META-INF/services/javax.xml.parsers.DocumentBuilderFactory) 2018-09-12 14:59:39.950 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.factory.xml.DefaultDocumentLoader : Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl] Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl] 2018-09-12 14:59:39.953 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.beans.factory.xml.BeansDtdResolver : Found beans DTD [http://www.springframework.org/dtd/spring-beans-2.0.dtd] in classpath: spring-beans-2.0.dtd Found beans DTD [http://www.springframework.org/dtd/spring-beans-2.0.dtd] in classpath: spring-beans-2.0.dtd 2018-09-12 14:59:39.977 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] .f.x.DefaultBeanDefinitionDocumentReader : Loading bean definitions Loading bean definitions 2018-09-12 14:59:40.006 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'DB2' Creating shared instance of singleton bean 'DB2' 2018-09-12 14:59:40.007 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'DB2' Creating instance of bean 'DB2' 2018-09-12 14:59:40.007 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Eagerly caching bean 'DB2' to allow for resolving potential circular references Eagerly caching bean 'DB2' to allow for resolving potential circular references 2018-09-12 14:59:40.008 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.a.c.loader.WebappClassLoaderBase : findClass(java.lang.ObjectCustomizer) findClass(java.lang.ObjectCustomizer) 2018-09-12 14:59:40.009 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:59:40.010 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.a.c.loader.WebappClassLoaderBase : findClass(org.springframework.jdbc.support.SQLErrorCodesCustomizer) findClass(org.springframework.jdbc.support.SQLErrorCodesCustomizer) 2018-09-12 14:59:40.011 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.a.c.loader.WebappClassLoaderBase : --> Returning ClassNotFoundException --> Returning ClassNotFoundException 2018-09-12 14:59:40.012 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'DB2' Finished creating instance of bean 'DB2' 2018-09-12 14:59:40.012 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'Derby' Creating shared instance of singleton bean 'Derby' 2018-09-12 14:59:40.012 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'Derby' Creating instance of bean 'Derby' 2018-09-12 14:59:40.012 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Eagerly caching bean 'Derby' to allow for resolving potential circular references Eagerly caching bean 'Derby' to allow for resolving potential circular references 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'Derby' Finished creating instance of bean 'Derby' 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'H2' Creating shared instance of singleton bean 'H2' 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'H2' Creating instance of bean 'H2' 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Eagerly caching bean 'H2' to allow for resolving potential circular references Eagerly caching bean 'H2' to allow for resolving potential circular references 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'H2' Finished creating instance of bean 'H2' 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'HSQL' Creating shared instance of singleton bean 'HSQL' 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'HSQL' Creating instance of bean 'HSQL' 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Eagerly caching bean 'HSQL' to allow for resolving potential circular references Eagerly caching bean 'HSQL' to allow for resolving potential circular references 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'HSQL' Finished creating instance of bean 'HSQL' 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'Informix' Creating shared instance of singleton bean 'Informix' 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'Informix' Creating instance of bean 'Informix' 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Eagerly caching bean 'Informix' to allow for resolving potential circular references Eagerly caching bean 'Informix' to allow for resolving potential circular references 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'Informix' Finished creating instance of bean 'Informix' 2018-09-12 14:59:40.013 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'MS-SQL' Creating shared instance of singleton bean 'MS-SQL' 2018-09-12 14:59:40.015 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'MS-SQL' Creating instance of bean 'MS-SQL' 2018-09-12 14:59:40.015 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Eagerly caching bean 'MS-SQL' to allow for resolving potential circular references Eagerly caching bean 'MS-SQL' to allow for resolving potential circular references 2018-09-12 14:59:40.016 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'MS-SQL' Finished creating instance of bean 'MS-SQL' 2018-09-12 14:59:40.016 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'MySQL' Creating shared instance of singleton bean 'MySQL' 2018-09-12 14:59:40.016 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'MySQL' Creating instance of bean 'MySQL' 2018-09-12 14:59:40.016 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Eagerly caching bean 'MySQL' to allow for resolving potential circular references Eagerly caching bean 'MySQL' to allow for resolving potential circular references 2018-09-12 14:59:40.016 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'MySQL' Finished creating instance of bean 'MySQL' 2018-09-12 14:59:40.016 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'Oracle' Creating shared instance of singleton bean 'Oracle' 2018-09-12 14:59:40.016 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'Oracle' Creating instance of bean 'Oracle' 2018-09-12 14:59:40.016 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Eagerly caching bean 'Oracle' to allow for resolving potential circular references Eagerly caching bean 'Oracle' to allow for resolving potential circular references 2018-09-12 14:59:40.016 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'Oracle' Finished creating instance of bean 'Oracle' 2018-09-12 14:59:40.016 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'PostgreSQL' Creating shared instance of singleton bean 'PostgreSQL' 2018-09-12 14:59:40.016 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'PostgreSQL' Creating instance of bean 'PostgreSQL' 2018-09-12 14:59:40.017 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Eagerly caching bean 'PostgreSQL' to allow for resolving potential circular references Eagerly caching bean 'PostgreSQL' to allow for resolving potential circular references 2018-09-12 14:59:40.017 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'PostgreSQL' Finished creating instance of bean 'PostgreSQL' 2018-09-12 14:59:40.017 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'Sybase' Creating shared instance of singleton bean 'Sybase' 2018-09-12 14:59:40.017 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'Sybase' Creating instance of bean 'Sybase' 2018-09-12 14:59:40.017 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Eagerly caching bean 'Sybase' to allow for resolving potential circular references Eagerly caching bean 'Sybase' to allow for resolving potential circular references 2018-09-12 14:59:40.018 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'Sybase' Finished creating instance of bean 'Sybase' 2018-09-12 14:59:40.018 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'Hana' Creating shared instance of singleton bean 'Hana' 2018-09-12 14:59:40.018 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Creating instance of bean 'Hana' Creating instance of bean 'Hana' 2018-09-12 14:59:40.018 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Eagerly caching bean 'Hana' to allow for resolving potential circular references Eagerly caching bean 'Hana' to allow for resolving potential circular references 2018-09-12 14:59:40.018 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Finished creating instance of bean 'Hana' Finished creating instance of bean 'Hana' 2018-09-12 14:59:40.019 INFO [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.support.SQLErrorCodesFactory : SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana] SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana] 2018-09-12 14:59:40.019 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.support.SQLErrorCodesFactory : Looking up default SQLErrorCodes for DataSource [org.apache.tomcat.jdbc.pool.DataSource@329e2274] Looking up default SQLErrorCodes for DataSource [org.apache.tomcat.jdbc.pool.DataSource@329e2274] 2018-09-12 14:59:40.020 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.datasource.DataSourceUtils : Fetching JDBC Connection from DataSource Fetching JDBC Connection from DataSource 2018-09-12 14:59:40.026 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.datasource.DataSourceUtils : Returning JDBC Connection to DataSource Returning JDBC Connection to DataSource 2018-09-12 14:59:40.026 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.support.SQLErrorCodesFactory : SQL error codes for 'Impala' not found SQL error codes for 'Impala' not found 2018-09-12 14:59:40.026 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.jdbc.support.SQLErrorCodesFactory : Caching SQL error codes for DataSource [org.apache.tomcat.jdbc.pool.DataSource@329e2274]: database product name is 'Impala' Caching SQL error codes for DataSource [org.apache.tomcat.jdbc.pool.DataSource@329e2274]: database product name is 'Impala' 2018-09-12 14:59:40.027 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] s.j.s.SQLErrorCodeSQLExceptionTranslator : Unable to translate SQLException with Error code '500593', will now try the fallback translator Unable to translate SQLException with Error code '500593', will now try the fallback translator 2018-09-12 14:59:40.027 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.j.s.SQLStateSQLExceptionTranslator : Extracted SQL state class '08' from value '08S01' Extracted SQL state class '08' from value '08S01' 2018-09-12 14:59:40.027 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] .m.m.a.ExceptionHandlerExceptionResolver : Resolving exception from handler [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)]: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown. Resolving exception from handler [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)]: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown. 2018-09-12 14:59:40.029 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] .w.s.m.a.ResponseStatusExceptionResolver : Resolving exception from handler [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)]: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown. Resolving exception from handler [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)]: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown. 2018-09-12 14:59:40.032 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] .w.s.m.s.DefaultHandlerExceptionResolver : Resolving exception from handler [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)]: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown. Resolving exception from handler [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)]: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown. 2018-09-12 14:59:40.035 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.web.servlet.DispatcherServlet : Could not complete request Could not complete request org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:105) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:776) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at com.jx.data.biz.distribution.service.DistributionAnalysisService.getData(DistributionAnalysisService.java:189) ~[classes/:na] at com.jx.data.biz.distribution.web.DistributionAnalysisController.show(DistributionAnalysisController.java:69) ~[classes/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) [spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) [spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) [spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-embed-websocket-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55) [spring-boot-1.5.8.RELEASE.jar:1.5.8.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110) [spring-boot-actuator-1.5.8.RELEASE.jar:1.5.8.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106) [spring-boot-actuator-1.5.8.RELEASE.jar:1.5.8.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_172] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_172] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172] Caused by: java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown. at com.cloudera.impala.hivecommon.api.HS2Client.executeStatementInternal(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2Client.executeStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.executeQuery(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.prepare(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.common.SPreparedStatement.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.jdbc41.S41PreparedStatement.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.jdbc41.Hive41PreparedStatement.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.impala.jdbc41.ImpalaJDBC41ObjectFactory.createPreparedStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.common.SConnection.prepareStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.common.SConnection.prepareStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172] at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81) ~[tomcat-jdbc-8.5.23.jar:na] at com.sun.proxy.$Proxy94.prepareStatement(Unknown Source) ~[na:na] at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1524) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:627) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] ... 72 common frames omitted Caused by: com.cloudera.impala.support.exceptions.ErrorException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown. ... 95 common frames omitted Caused by: com.cloudera.impala.jdbc41.internal.apache.thrift.transport.TTransportException: null at com.cloudera.impala.jdbc41.internal.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.transport.TTransport.readAll(TTransport.java:84) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:378) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:297) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:204) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$Client.recv_ExecuteStatement(TCLIService.java:229) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2ClientWrapper.recv_ExecuteStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$Client.ExecuteStatement(TCLIService.java:216) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2ClientWrapper.ExecuteStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] ... 95 common frames omitted 2018-09-12 14:59:40.040 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.w.f.OrderedRequestContextFilter : Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@75b3b13 Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@75b3b13 2018-09-12 14:59:40.042 ERROR [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.a.c.c.C.[.[.[.[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [/jx-data] threw exception [Request processing failed; nested exception is org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown.] with root cause Servlet.service() for servlet [dispatcherServlet] in context with path [/jx-data] threw exception [Request processing failed; nested exception is org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: Unknown.] with root cause com.cloudera.impala.jdbc41.internal.apache.thrift.transport.TTransportException: null at com.cloudera.impala.jdbc41.internal.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.transport.TTransport.readAll(TTransport.java:84) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:378) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:297) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:204) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$Client.recv_ExecuteStatement(TCLIService.java:229) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2ClientWrapper.recv_ExecuteStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$Client.ExecuteStatement(TCLIService.java:216) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2ClientWrapper.ExecuteStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2Client.executeStatementInternal(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2Client.executeStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.executeQuery(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.prepare(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.common.SPreparedStatement.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.jdbc41.S41PreparedStatement.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.jdbc41.Hive41PreparedStatement.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.impala.jdbc41.ImpalaJDBC41ObjectFactory.createPreparedStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.common.SConnection.prepareStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.common.SConnection.prepareStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172] at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81) ~[tomcat-jdbc-8.5.23.jar:na] at com.sun.proxy.$Proxy94.prepareStatement(Unknown Source) ~[na:na] at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1524) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:627) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:776) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at com.jx.data.biz.distribution.service.DistributionAnalysisService.getData(DistributionAnalysisService.java:189) ~[classes/:na] at com.jx.data.biz.distribution.web.DistributionAnalysisController.show(DistributionAnalysisController.java:69) ~[classes/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) ~[tomcat-embed-websocket-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55) ~[spring-boot-1.5.8.RELEASE.jar:1.5.8.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110) ~[spring-boot-actuator-1.5.8.RELEASE.jar:1.5.8.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106) ~[spring-boot-actuator-1.5.8.RELEASE.jar:1.5.8.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_172] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_172] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172] 2018-09-12 14:59:40.044 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.a.c.c.C.[Tomcat].[localhost] : Processing ErrorPage[errorCode=0, location=/error] Processing ErrorPage[errorCode=0, location=/error] 2018-09-12 14:59:40.049 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.web.servlet.DispatcherServlet : DispatcherServlet with name 'dispatcherServlet' processing GET request for [/jx-data/error] DispatcherServlet with name 'dispatcherServlet' processing GET request for [/jx-data/error] 2018-09-12 14:59:40.049 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.a.e.mvc.EndpointHandlerMapping : Looking up handler method for path /error Looking up handler method for path /error 2018-09-12 14:59:40.051 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.a.e.mvc.EndpointHandlerMapping : Did not find handler method for [/error] Did not find handler method for [/error] 2018-09-12 14:59:40.051 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] s.w.s.m.m.a.RequestMappingHandlerMapping : Looking up handler method for path /error Looking up handler method for path /error 2018-09-12 14:59:40.052 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] s.w.s.m.m.a.RequestMappingHandlerMapping : Returning handler method [public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)] Returning handler method [public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)] 2018-09-12 14:59:40.053 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'basicErrorController' Returning cached instance of singleton bean 'basicErrorController' 2018-09-12 14:59:40.053 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.web.servlet.DispatcherServlet : Last-Modified value for [/jx-data/error] is: -1 Last-Modified value for [/jx-data/error] is: -1 2018-09-12 14:59:40.055 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.c.e.PropertySourcesPropertyResolver : Found key 'spring.template.provider.cache' in PropertySource 'refresh' with value of type String Found key 'spring.template.provider.cache' in PropertySource 'refresh' with value of type String 2018-09-12 14:59:40.060 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.c.e.PropertySourcesPropertyResolver : Found key 'spring.template.provider.cache' in PropertySource 'refresh' with value of type String Found key 'spring.template.provider.cache' in PropertySource 'refresh' with value of type String 2018-09-12 14:59:40.066 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.w.s.v.ContentNegotiatingViewResolver : Requested media types are [text/html, text/html;q=0.8] based on Accept header types and producible media types [text/html]) Requested media types are [text/html, text/html;q=0.8] based on Accept header types and producible media types [text/html]) 2018-09-12 14:59:40.066 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'error' Returning cached instance of singleton bean 'error' 2018-09-12 14:59:40.068 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.b.f.s.DefaultListableBeanFactory : Invoking afterPropertiesSet() on bean with name 'error' Invoking afterPropertiesSet() on bean with name 'error' 2018-09-12 14:59:40.073 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.w.s.v.ContentNegotiatingViewResolver : Returning [org.springframework.boot.autoconfigure.web.ErrorMvcAutoConfiguration$SpelView@193ce612] based on requested media type 'text/html' Returning [org.springframework.boot.autoconfigure.web.ErrorMvcAutoConfiguration$SpelView@193ce612] based on requested media type 'text/html' 2018-09-12 14:59:40.074 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.web.servlet.DispatcherServlet : Rendering view [org.springframework.boot.autoconfigure.web.ErrorMvcAutoConfiguration$SpelView@193ce612] in DispatcherServlet with name 'dispatcherServlet' Rendering view [org.springframework.boot.autoconfigure.web.ErrorMvcAutoConfiguration$SpelView@193ce612] in DispatcherServlet with name 'dispatcherServlet' 2018-09-12 14:59:40.105 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.s.web.servlet.DispatcherServlet : Successfully completed request Successfully completed request 2018-09-12 14:59:40.105 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.a.c.c.C.[.[.[.[dispatcherServlet] : Disabling the response for further output Disabling the response for further output 2018-09-12 14:59:40.107 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.apache.coyote.http11.Http11Processor : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@5e3da76d:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57071]], Status in: [OPEN_READ], State out: [CLOSED] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@5e3da76d:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57071]], Status in: [OPEN_READ], State out: [CLOSED] 2018-09-12 14:59:40.107 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-2] o.apache.tomcat.util.threads.LimitLatch : Counting down[http-nio-9005-exec-2] latch=2 Counting down[http-nio-9005-exec-2] latch=2 2018-09-12 14:59:51.543 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-7] o.a.tomcat.util.net.SocketWrapperBase : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@7f11c01:org.apache.tomcat.util.net.NioChannel@68856bf3:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57072]], Read from buffer: [0] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@7f11c01:org.apache.tomcat.util.net.NioChannel@68856bf3:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57072]], Read from buffer: [0] 2018-09-12 14:59:51.544 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-7] o.apache.coyote.http11.Http11Processor : Error parsing HTTP request header Error parsing HTTP request header java.io.EOFException: null at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.fillReadBuffer(NioEndpoint.java:1250) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.read(NioEndpoint.java:1190) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11InputBuffer.fill(Http11InputBuffer.java:717) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11InputBuffer.parseRequestLine(Http11InputBuffer.java:366) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:687) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_172] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_172] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172] 2018-09-12 14:59:51.544 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-7] o.apache.coyote.http11.Http11Processor : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@7f11c01:org.apache.tomcat.util.net.NioChannel@68856bf3:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57072]], Status in: [OPEN_READ], State out: [CLOSED] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@7f11c01:org.apache.tomcat.util.net.NioChannel@68856bf3:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57072]], Status in: [OPEN_READ], State out: [CLOSED] 2018-09-12 14:59:51.544 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-7] o.apache.tomcat.util.threads.LimitLatch : Counting down[http-nio-9005-exec-7] latch=1 Counting down[http-nio-9005-exec-7] latch=1 dfdfdf2018-09-12 15:00:03.619 DEBUG [jx-data-analysis,,,] 10628 --- [9005-Acceptor-0] o.apache.tomcat.util.threads.LimitLatch : Counting up[http-nio-9005-Acceptor-0] latch=1 Counting up[http-nio-9005-Acceptor-0] latch=1 2018-09-12 15:00:03.619 DEBUG [jx-data-analysis,,,] 10628 --- [9005-Acceptor-0] o.apache.tomcat.util.threads.LimitLatch : Counting up[http-nio-9005-Acceptor-0] latch=2 Counting up[http-nio-9005-Acceptor-0] latch=2 2018-09-12 15:00:03.620 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.a.tomcat.util.net.SocketWrapperBase : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@2fa6cb13:org.apache.tomcat.util.net.NioChannel@68856bf3:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57110]], Read from buffer: [0] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@2fa6cb13:org.apache.tomcat.util.net.NioChannel@68856bf3:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57110]], Read from buffer: [0] 2018-09-12 15:00:03.620 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.a.coyote.http11.Http11InputBuffer : Received [GET /jx-data/joyxuan_mall/distribution/show?q_type=BUBAJRGWC000001001_COUNT&dt1=2018-09-1&dt2=2018-09-11 HTTP/1.1 Host: 127.0.0.1:9005 Connection: keep-alive Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Accept-Encoding: gzip, deflate, br Accept-Language: zh-CN,zh;q=0.9 ] Received [GET /jx-data/joyxuan_mall/distribution/show?q_type=BUBAJRGWC000001001_COUNT&dt1=2018-09-1&dt2=2018-09-11 HTTP/1.1 Host: 127.0.0.1:9005 Connection: keep-alive Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Accept-Encoding: gzip, deflate, br Accept-Language: zh-CN,zh;q=0.9 ] 2018-09-12 15:00:03.621 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.a.c.authenticator.AuthenticatorBase : Security checking request GET /jx-data/joyxuan_mall/distribution/show Security checking request GET /jx-data/joyxuan_mall/distribution/show 2018-09-12 15:00:03.621 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] org.apache.catalina.realm.RealmBase : No applicable constraints defined No applicable constraints defined 2018-09-12 15:00:03.621 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.a.c.authenticator.AuthenticatorBase : Not subject to any constraint Not subject to any constraint 2018-09-12 15:00:03.622 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.b.w.f.OrderedRequestContextFilter : Bound request context to thread: org.apache.catalina.connector.RequestFacade@75b3b13 Bound request context to thread: org.apache.catalina.connector.RequestFacade@75b3b13 2018-09-12 15:00:03.623 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.web.servlet.DispatcherServlet : DispatcherServlet with name 'dispatcherServlet' processing GET request for [/jx-data/joyxuan_mall/distribution/show] DispatcherServlet with name 'dispatcherServlet' processing GET request for [/jx-data/joyxuan_mall/distribution/show] 2018-09-12 15:00:03.624 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.b.a.e.mvc.EndpointHandlerMapping : Looking up handler method for path /joyxuan_mall/distribution/show Looking up handler method for path /joyxuan_mall/distribution/show 2018-09-12 15:00:03.626 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.b.a.e.mvc.EndpointHandlerMapping : Did not find handler method for [/joyxuan_mall/distribution/show] Did not find handler method for [/joyxuan_mall/distribution/show] 2018-09-12 15:00:03.626 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] s.w.s.m.m.a.RequestMappingHandlerMapping : Looking up handler method for path /joyxuan_mall/distribution/show Looking up handler method for path /joyxuan_mall/distribution/show 2018-09-12 15:00:03.626 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] s.w.s.m.m.a.RequestMappingHandlerMapping : Returning handler method [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)] Returning handler method [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)] 2018-09-12 15:00:03.626 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'distributionAnalysisController' Returning cached instance of singleton bean 'distributionAnalysisController' 2018-09-12 15:00:03.627 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.web.servlet.DispatcherServlet : Last-Modified value for [/jx-data/joyxuan_mall/distribution/show] is: -1 Last-Modified value for [/jx-data/joyxuan_mall/distribution/show] is: -1 2018-09-12 15:00:03.629 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] org.apache.tomcat.util.http.Parameters : Set encoding to UTF-8 Set encoding to UTF-8 2018-09-12 15:00:03.630 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] org.apache.tomcat.util.http.Parameters : Decoding query null UTF-8 Decoding query null UTF-8 2018-09-12 15:00:03.631 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] org.apache.tomcat.util.http.Parameters : Start processing with input [q_type=BUBAJRGWC000001001_COUNT&dt1=2018-09-1&dt2=2018-09-11] Start processing with input [q_type=BUBAJRGWC000001001_COUNT&dt1=2018-09-1&dt2=2018-09-11] 2018-09-12 15:00:03.631 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.jdbc.core.JdbcTemplate : Executing SQL query [select dict_type,dict_key,dict_value from data_dict where status=0 and dict_type='distr_analysis_ranges_count' order by dict_order asc ] Executing SQL query [select dict_type,dict_key,dict_value from data_dict where status=0 and dict_type='distr_analysis_ranges_count' order by dict_order asc ] 2018-09-12 15:00:03.631 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.jdbc.datasource.DataSourceUtils : Fetching JDBC Connection from DataSource Fetching JDBC Connection from DataSource 2018-09-12 15:00:03.640 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.jdbc.core.BeanPropertyRowMapper : Mapping column 'dict_type' to property 'dict_type' of type 'java.lang.String' Mapping column 'dict_type' to property 'dict_type' of type 'java.lang.String' 2018-09-12 15:00:03.640 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.jdbc.core.BeanPropertyRowMapper : Mapping column 'dict_key' to property 'dict_key' of type 'java.lang.String' Mapping column 'dict_key' to property 'dict_key' of type 'java.lang.String' 2018-09-12 15:00:03.640 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.jdbc.core.BeanPropertyRowMapper : Mapping column 'dict_value' to property 'dict_value' of type 'java.lang.String' Mapping column 'dict_value' to property 'dict_value' of type 'java.lang.String' 2018-09-12 15:00:03.648 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.jdbc.datasource.DataSourceUtils : Returning JDBC Connection to DataSource Returning JDBC Connection to DataSource 2018-09-12 15:00:03.648 INFO [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] c.j.d.biz.deal.service.DealDataService : sql:>>> select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc param=[] sql:>>> select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc param=[] 2018-09-12 15:00:03.648 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL query Executing prepared SQL query 2018-09-12 15:00:03.648 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL statement [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ] Executing prepared SQL statement [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ] 2018-09-12 15:00:03.648 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.jdbc.datasource.DataSourceUtils : Fetching JDBC Connection from DataSource Fetching JDBC Connection from DataSource 2018-09-12 15:00:03.652 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.jdbc.datasource.DataSourceUtils : Returning JDBC Connection to DataSource Returning JDBC Connection to DataSource 2018-09-12 15:00:03.653 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] s.j.s.SQLErrorCodeSQLExceptionTranslator : Unable to translate SQLException with Error code '500593', will now try the fallback translator Unable to translate SQLException with Error code '500593', will now try the fallback translator 2018-09-12 15:00:03.653 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.j.s.SQLStateSQLExceptionTranslator : Extracted SQL state class '08' from value '08S01' Extracted SQL state class '08' from value '08S01' 2018-09-12 15:00:03.653 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] .m.m.a.ExceptionHandlerExceptionResolver : Resolving exception from handler [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)]: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error. Resolving exception from handler [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)]: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error. 2018-09-12 15:00:03.653 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] .w.s.m.a.ResponseStatusExceptionResolver : Resolving exception from handler [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)]: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error. Resolving exception from handler [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)]: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error. 2018-09-12 15:00:03.653 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] .w.s.m.s.DefaultHandlerExceptionResolver : Resolving exception from handler [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)]: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error. Resolving exception from handler [public com.jx.data.biz.bean.ResultBean com.jx.data.biz.distribution.web.DistributionAnalysisController.show(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,com.jx.data.biz.distribution.bean.DistributionAnalysisBean)]: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error. 2018-09-12 15:00:03.655 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.web.servlet.DispatcherServlet : Could not complete request Could not complete request org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:105) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:776) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at com.jx.data.biz.distribution.service.DistributionAnalysisService.getData(DistributionAnalysisService.java:189) ~[classes/:na] at com.jx.data.biz.distribution.web.DistributionAnalysisController.show(DistributionAnalysisController.java:69) ~[classes/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) [spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) [spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) [spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-embed-websocket-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55) [spring-boot-1.5.8.RELEASE.jar:1.5.8.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110) [spring-boot-actuator-1.5.8.RELEASE.jar:1.5.8.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106) [spring-boot-actuator-1.5.8.RELEASE.jar:1.5.8.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_172] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_172] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172] Caused by: java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error. at com.cloudera.impala.hivecommon.api.HS2Client.executeStatementInternal(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2Client.executeStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.executeQuery(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.prepare(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.common.SPreparedStatement.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.jdbc41.S41PreparedStatement.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.jdbc41.Hive41PreparedStatement.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.impala.jdbc41.ImpalaJDBC41ObjectFactory.createPreparedStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.common.SConnection.prepareStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.common.SConnection.prepareStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172] at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81) ~[tomcat-jdbc-8.5.23.jar:na] at com.sun.proxy.$Proxy94.prepareStatement(Unknown Source) ~[na:na] at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1524) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:627) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] ... 72 common frames omitted Caused by: com.cloudera.impala.support.exceptions.ErrorException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error. ... 95 common frames omitted Caused by: com.cloudera.impala.jdbc41.internal.apache.thrift.transport.TTransportException: java.net.SocketException: Software caused connection abort: socket write error at com.cloudera.impala.jdbc41.internal.apache.thrift.transport.TIOStreamTransport.write(TIOStreamTransport.java:147) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.protocol.TBinaryProtocol.writeString(TBinaryProtocol.java:187) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TExecuteStatementReq$TExecuteStatementReqStandardScheme.write(TExecuteStatementReq.java:665) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TExecuteStatementReq$TExecuteStatementReqStandardScheme.write(TExecuteStatementReq.java:588) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TExecuteStatementReq.write(TExecuteStatementReq.java:505) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$ExecuteStatement_args$ExecuteStatement_argsStandardScheme.write(TCLIService.java:5125) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$ExecuteStatement_args$ExecuteStatement_argsStandardScheme.write(TCLIService.java:5089) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$ExecuteStatement_args.write(TCLIService.java:5040) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.TServiceClient.sendBase(TServiceClient.java:63) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$Client.send_ExecuteStatement(TCLIService.java:223) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2ClientWrapper.send_ExecuteStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$Client.ExecuteStatement(TCLIService.java:215) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2ClientWrapper.ExecuteStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] ... 95 common frames omitted Caused by: java.net.SocketException: Software caused connection abort: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) ~[na:1.8.0_172] at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111) ~[na:1.8.0_172] at java.net.SocketOutputStream.write(SocketOutputStream.java:155) ~[na:1.8.0_172] at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[na:1.8.0_172] at java.io.BufferedOutputStream.write(BufferedOutputStream.java:126) ~[na:1.8.0_172] at com.cloudera.impala.jdbc41.internal.apache.thrift.transport.TIOStreamTransport.write(TIOStreamTransport.java:145) ~[ImpalaJDBC41.jar:na] ... 107 common frames omitted 2018-09-12 15:00:03.656 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.b.w.f.OrderedRequestContextFilter : Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@75b3b13 Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@75b3b13 2018-09-12 15:00:03.657 ERROR [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.a.c.c.C.[.[.[.[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [/jx-data] threw exception [Request processing failed; nested exception is org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error.] with root cause Servlet.service() for servlet [dispatcherServlet] in context with path [/jx-data] threw exception [Request processing failed; nested exception is org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select BUS_DT dt, sum(CASE WHEN METRIC_VAL >=1 and METRIC_VAL<=3 THEN USER_CNT ELSE 0 END) as '1-3', sum(CASE WHEN METRIC_VAL >=4 and METRIC_VAL<=8 THEN USER_CNT ELSE 0 END) as '4-8', sum(CASE WHEN METRIC_VAL >=9 THEN USER_CNT ELSE 0 END) as '9-x' from A_T_BASE_KPI_USER_CNT_SUM_D where BUS_DT>='2018-09-1' and BUS_DT<='2018-09-11' and METRIC_TYPE_CD='BUBAJRGWC000001001_COUNT' GROUP BY BUS_DT order by BUS_DT asc ]; [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error.; nested exception is java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: java.net.SocketException: Software caused connection abort: socket write error.] with root cause java.net.SocketException: Software caused connection abort: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) ~[na:1.8.0_172] at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111) ~[na:1.8.0_172] at java.net.SocketOutputStream.write(SocketOutputStream.java:155) ~[na:1.8.0_172] at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[na:1.8.0_172] at java.io.BufferedOutputStream.write(BufferedOutputStream.java:126) ~[na:1.8.0_172] at com.cloudera.impala.jdbc41.internal.apache.thrift.transport.TIOStreamTransport.write(TIOStreamTransport.java:145) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.protocol.TBinaryProtocol.writeString(TBinaryProtocol.java:187) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TExecuteStatementReq$TExecuteStatementReqStandardScheme.write(TExecuteStatementReq.java:665) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TExecuteStatementReq$TExecuteStatementReqStandardScheme.write(TExecuteStatementReq.java:588) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TExecuteStatementReq.write(TExecuteStatementReq.java:505) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$ExecuteStatement_args$ExecuteStatement_argsStandardScheme.write(TCLIService.java:5125) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$ExecuteStatement_args$ExecuteStatement_argsStandardScheme.write(TCLIService.java:5089) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$ExecuteStatement_args.write(TCLIService.java:5040) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.thrift.TServiceClient.sendBase(TServiceClient.java:63) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$Client.send_ExecuteStatement(TCLIService.java:223) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2ClientWrapper.send_ExecuteStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc41.internal.apache.hive.service.cli.thrift.TCLIService$Client.ExecuteStatement(TCLIService.java:215) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2ClientWrapper.ExecuteStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2Client.executeStatementInternal(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.api.HS2Client.executeStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.executeQuery(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.prepare(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.common.SPreparedStatement.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.jdbc41.S41PreparedStatement.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.hivecommon.jdbc41.Hive41PreparedStatement.(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.impala.jdbc41.ImpalaJDBC41ObjectFactory.createPreparedStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.common.SConnection.prepareStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at com.cloudera.impala.jdbc.common.SConnection.prepareStatement(Unknown Source) ~[ImpalaJDBC41.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172] at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) ~[tomcat-jdbc-8.5.23.jar:na] at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81) ~[tomcat-jdbc-8.5.23.jar:na] at com.sun.proxy.$Proxy94.prepareStatement(Unknown Source) ~[na:na] at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1524) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:627) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:776) ~[spring-jdbc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at com.jx.data.biz.distribution.service.DistributionAnalysisService.getData(DistributionAnalysisService.java:189) ~[classes/:na] at com.jx.data.biz.distribution.web.DistributionAnalysisController.show(DistributionAnalysisController.java:69) ~[classes/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) ~[spring-webmvc-4.3.12.RELEASE.jar:4.3.12.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) ~[tomcat-embed-websocket-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55) ~[spring-boot-1.5.8.RELEASE.jar:1.5.8.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110) ~[spring-boot-actuator-1.5.8.RELEASE.jar:1.5.8.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106) ~[spring-boot-actuator-1.5.8.RELEASE.jar:1.5.8.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.12.RELEASE.jar:4.3.12.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_172] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_172] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172] 2018-09-12 15:00:03.658 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.a.c.c.C.[Tomcat].[localhost] : Processing ErrorPage[errorCode=0, location=/error] Processing ErrorPage[errorCode=0, location=/error] 2018-09-12 15:00:03.658 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.web.servlet.DispatcherServlet : DispatcherServlet with name 'dispatcherServlet' processing GET request for [/jx-data/error] DispatcherServlet with name 'dispatcherServlet' processing GET request for [/jx-data/error] 2018-09-12 15:00:03.659 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.b.a.e.mvc.EndpointHandlerMapping : Looking up handler method for path /error Looking up handler method for path /error 2018-09-12 15:00:03.660 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.b.a.e.mvc.EndpointHandlerMapping : Did not find handler method for [/error] Did not find handler method for [/error] 2018-09-12 15:00:03.660 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] s.w.s.m.m.a.RequestMappingHandlerMapping : Looking up handler method for path /error Looking up handler method for path /error 2018-09-12 15:00:03.661 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] s.w.s.m.m.a.RequestMappingHandlerMapping : Returning handler method [public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)] Returning handler method [public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)] 2018-09-12 15:00:03.661 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'basicErrorController' Returning cached instance of singleton bean 'basicErrorController' 2018-09-12 15:00:03.661 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.web.servlet.DispatcherServlet : Last-Modified value for [/jx-data/error] is: -1 Last-Modified value for [/jx-data/error] is: -1 2018-09-12 15:00:03.661 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.c.e.PropertySourcesPropertyResolver : Found key 'spring.template.provider.cache' in PropertySource 'refresh' with value of type String Found key 'spring.template.provider.cache' in PropertySource 'refresh' with value of type String 2018-09-12 15:00:03.666 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.c.e.PropertySourcesPropertyResolver : Found key 'spring.template.provider.cache' in PropertySource 'refresh' with value of type String Found key 'spring.template.provider.cache' in PropertySource 'refresh' with value of type String 2018-09-12 15:00:03.670 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.w.s.v.ContentNegotiatingViewResolver : Requested media types are [text/html, text/html;q=0.8] based on Accept header types and producible media types [text/html]) Requested media types are [text/html, text/html;q=0.8] based on Accept header types and producible media types [text/html]) 2018-09-12 15:00:03.670 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.b.f.s.DefaultListableBeanFactory : Returning cached instance of singleton bean 'error' Returning cached instance of singleton bean 'error' 2018-09-12 15:00:03.670 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.w.s.v.ContentNegotiatingViewResolver : Returning [org.springframework.boot.autoconfigure.web.ErrorMvcAutoConfiguration$SpelView@193ce612] based on requested media type 'text/html' Returning [org.springframework.boot.autoconfigure.web.ErrorMvcAutoConfiguration$SpelView@193ce612] based on requested media type 'text/html' 2018-09-12 15:00:03.670 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.web.servlet.DispatcherServlet : Rendering view [org.springframework.boot.autoconfigure.web.ErrorMvcAutoConfiguration$SpelView@193ce612] in DispatcherServlet with name 'dispatcherServlet' Rendering view [org.springframework.boot.autoconfigure.web.ErrorMvcAutoConfiguration$SpelView@193ce612] in DispatcherServlet with name 'dispatcherServlet' 2018-09-12 15:00:03.670 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.s.web.servlet.DispatcherServlet : Successfully completed request Successfully completed request 2018-09-12 15:00:03.670 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.a.c.c.C.[.[.[.[dispatcherServlet] : Disabling the response for further output Disabling the response for further output 2018-09-12 15:00:03.671 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.apache.coyote.http11.Http11Processor : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@2fa6cb13:org.apache.tomcat.util.net.NioChannel@68856bf3:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57110]], Status in: [OPEN_READ], State out: [CLOSED] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@2fa6cb13:org.apache.tomcat.util.net.NioChannel@68856bf3:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57110]], Status in: [OPEN_READ], State out: [CLOSED] 2018-09-12 15:00:03.671 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-3] o.apache.tomcat.util.threads.LimitLatch : Counting down[http-nio-9005-exec-3] latch=2 Counting down[http-nio-9005-exec-3] latch=2 2018-09-12 15:00:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1536735607182 sessioncount 0 Start expire sessions StandardManager at 1536735607182 sessioncount 0 2018-09-12 15:00:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 0 expired sessions: 0 End expire sessions StandardManager processingTime 0 expired sessions: 0 2018-09-12 15:00:16.543 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-8] o.a.tomcat.util.net.SocketWrapperBase : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@54659658:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57111]], Read from buffer: [0] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@54659658:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57111]], Read from buffer: [0] 2018-09-12 15:00:16.543 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-8] o.apache.coyote.http11.Http11Processor : Error parsing HTTP request header Error parsing HTTP request header java.io.EOFException: null at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.fillReadBuffer(NioEndpoint.java:1250) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.read(NioEndpoint.java:1190) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11InputBuffer.fill(Http11InputBuffer.java:717) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11InputBuffer.parseRequestLine(Http11InputBuffer.java:366) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:687) ~[tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-embed-core-8.5.23.jar:8.5.23] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_172] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_172] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.23.jar:8.5.23] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172] 2018-09-12 15:00:16.543 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-8] o.apache.coyote.http11.Http11Processor : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@54659658:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57111]], Status in: [OPEN_READ], State out: [CLOSED] Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@54659658:org.apache.tomcat.util.net.NioChannel@774ca06c:java.nio.channels.SocketChannel[connected local=/127.0.0.1:9005 remote=/127.0.0.1:57111]], Status in: [OPEN_READ], State out: [CLOSED] 2018-09-12 15:00:16.544 DEBUG [jx-data-analysis,,,] 10628 --- [nio-9005-exec-8] o.apache.tomcat.util.threads.LimitLatch : Counting down[http-nio-9005-exec-8] latch=1 Counting down[http-nio-9005-exec-8] latch=1 2018-09-12 15:03:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1536735787182 sessioncount 0 Start expire sessions StandardManager at 1536735787182 sessioncount 0 2018-09-12 15:03:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 0 expired sessions: 0 End expire sessions StandardManager processingTime 0 expired sessions: 0 2018-09-12 15:06:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1536735967182 sessioncount 0 Start expire sessions StandardManager at 1536735967182 sessioncount 0 2018-09-12 15:06:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 0 expired sessions: 0 End expire sessions StandardManager processingTime 0 expired sessions: 0 2018-09-12 15:09:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1536736147182 sessioncount 0 Start expire sessions StandardManager at 1536736147182 sessioncount 0 2018-09-12 15:09:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 0 expired sessions: 0 End expire sessions StandardManager processingTime 0 expired sessions: 0 2018-09-12 15:12:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1536736327182 sessioncount 0 Start expire sessions StandardManager at 1536736327182 sessioncount 0 2018-09-12 15:12:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 0 expired sessions: 0 End expire sessions StandardManager processingTime 0 expired sessions: 0 2018-09-12 15:15:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1536736507182 sessioncount 0 Start expire sessions StandardManager at 1536736507182 sessioncount 0 2018-09-12 15:15:07.182 DEBUG [jx-data-analysis,,,] 10628 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 0 expired sessions: 0 End expire sessions StandardManager processingTime 0 expired sessions: 0