Unable to connect to CDP phoenix from Spring Boot

[#1]

HI Team,

I am trying to connect to Hbase via phoenix from Java SpringBoot Application.

This is to fetch data from Hbase from my Microservice Application.

I ma using the Phoenix connection URL : 

jdbc:phoenix:${zk-node}:${port}:/hbase:${principal}@${realm}:${keytab-path}

I am connecting from java jdbctemplate and using the SQL Drivermanager.

Am getting below error:

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.apache.phoenix.exception.PhoenixIOException: callTimeout=1200000, callDuration=1330750: Failed after attempts=16, exceptions:

[ERR] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:646)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:744)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:810)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at com.chase.ccb.digital.nucleus.slot.hbasephoenix.SampleDAO.getUserByRowKey(SampleDAO.java:38)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at com.chase.ccb.digital.nucleus.slot.hbasephoenix.SampleDAO$$FastClassBySpringCGLIB$$964f6016.invoke(<generated>)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at com.chase.ccb.digital.nucleus.slot.hbasephoenix.SampleDAO$$EnhancerBySpringCGLIB$$688c56a9.getUserByRowKey(<generated>)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at com.chase.ccb.digital.nucleus.slot.controller.PingController.healthCheckUsingGET(PingController.java:50)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at java.base/java.lang.reflect.Method.invoke(Method.java:566)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.335+05:30 [APP/PROC/WEB/0] [ERR] at com.jpmorgan.moneta.boot.logging.RequestLoggingFilter.doFilter(RequestLoggingFilter.java:141)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at com.jpmorgan.moneta.boot.logging.PerfLoggingFilter.doFilter(PerfLoggingFilter.java:50)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at net.chase.ccb.photon.core.context.filter.ContextFilter.doFilter(ContextFilter.java:53)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at com.jpmorgan.moneta.boot.logging.MDCFilter.doFilter(MDCFilter.java:31)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.cloud.sleuth.instrument.web.servlet.TracingFilter.doFilter(TracingFilter.java:68)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.cloud.sleuth.autoconfig.instrument.web.TraceWebServletConfiguration$LazyTracingFilter.doFilter(TraceWebServletConfiguration.java:131)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.cloudfoundry.router.ClientCertificateMapper.doFilter(ClientCertificateMapper.java:79)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at com.jpmorgan.moneta.boot.web.ExcludeFontVaryHeadersFilter.doFilterInternal(ExcludeFontVaryHeadersFilter.java:58)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

2023-04-18T09:43:15.336+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.cloud.sleuth.instrument.web.tomcat.TraceValve.invoke(TraceValve.java:90)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at java.base/java.lang.Thread.run(Thread.java:834)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] Caused by: org.apache.phoenix.exception.PhoenixIOException: callTimeout=1200000, callDuration=1330750: Failed after attempts=16, exceptions:

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:11:05.207Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:11:05.331Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:11:05.573Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:11:05.907Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:11:06.436Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:11:07.475Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:11:09.502Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:11:13.548Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, java.io.IOException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: java.io.IOException: Connection reset by peer

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:11:23.600Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, java.io.IOException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: java.io.IOException: Connection reset by peer

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:11:33.654Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:11:43.760Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:11:53.793Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:12:13.904Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:12:33.986Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, java.io.IOException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: java.io.IOException: Connection reset by peer

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:12:54.165Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] 2023-04-18T04:13:14.308Z, RpcRetryingCaller{globalStartTime=1681791065181, pause=100, maxAttempts=16}, org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR]

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:138)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1205)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1502)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2756)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:1117)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.compile.CreateTableCompiler$1.execute(CreateTableCompiler.java:199)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:408)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:391)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:390)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:378)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1806)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2570)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2533)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2533)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:150)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:121)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)

2023-04-18T09:43:15.337+05:30 [APP/PROC/WEB/0] [ERR] ... 131 more

[#2]

Hi Willx,

I want to connect to phoenix via thick client and can you please suggest the jars required for thick client and phoenix connection url.

For authentication i am using kerberos ticket cache, can you please suggest the right phoenix url for the same.

[#3]

Can you please provide the list of configurations to be set for phoenix connection.

[#4]

Hi Team, i have added Hbase client and phoenix core jar which has hbase client jar within it.

I have the hbase and core site xmls.

i get the Hconnection established message. But then i get 

"MESSAGE":"Reading reply sessionid:0x200239e26e51663, packet:: clientPath:/hbase serverPath:/hbase finished:false header:: 16,8 replyHeader:: 16,313534022349,0 request:: '/hbase,F response:: v{'meta-region-server,'rs,'splitWAL,'backup-masters,'flush-table-proc,'master-maintenance,'online-snapshot,'switch,'master,'running,'tokenauth,'draining,'namespace,'hbaseid,'table

I get this message repatedly.

 I am doubting if my hbase.site.xml is getting loaded properly. How can i verify if it is loaded properly.

What could be the issue

[#5]

Hi All,

 I have developed Spring boot application to read data from hbase via phoenix. the application creats new phoenix connection all the time and due to which high memory usage results in app crash. Please suggest