question Re: Unable to connect to CDP phoenix from Spring Boot in Support Questions

Unable to connect to CDP phoenix from Spring Boot

Sindhu6 — Tue, 18 Apr 2023 05:07:36 GMT

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

Re: Unable to connect to CDP phoenix from Spring Boot

VidyaSargur — Tue, 18 Apr 2023 08:26:20 GMT

@Sindhu6, Welcome to our community! To help you get the best possible answer, I have tagged in our CDP/Phoenix experts @smdas @aps @willx @rki_ who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Re: Unable to connect to CDP phoenix from Spring Boot

Sindhu6 — Tue, 18 Apr 2023 09:19:16 GMT

HI Vidya,

Thanks for the reply.

I ma trying multiple ways to establish the connectivity from Java to CDP Phoenix.

Am getting the same error from all approaches.

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.RpcRetryingCallerImpl.callWithRetries(RpcRetryingCallerImpl.java:145)

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.HTable.get(HTable.java:384)

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.HTable.get(HTable.java:358)

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.MetaTableAccessor.getTableState(MetaTableAccessor.java:1118)

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.MetaTableAccessor.tableExists(MetaTableAccessor.java:440)

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.HBaseAdmin$6.rpcCall(HBaseAdmin.java:469)

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.HBaseAdmin$6.rpcCall(HBaseAdmin.java:466)

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.RpcRetryingCallable.call(RpcRetryingCallable.java:58)

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.RpcRetryingCallerImpl.callWithRetries(RpcRetryingCallerImpl.java:107)

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] ... 154 more

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] Caused by: 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-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.IPCUtil.wrapException(IPCUtil.java:201)

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.AbstractRpcClient.onCallFinished(AbstractRpcClient.java:378)

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.AbstractRpcClient.access$100(AbstractRpcClient.java:91)

2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.AbstractRpcClient$3.run(AbstractRpcClient.java:409)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.AbstractRpcClient$3.run(AbstractRpcClient.java:405)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.Call.callComplete(Call.java:117)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.Call.setException(Call.java:132)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.NettyRpcDuplexHandler.cleanupCalls(NettyRpcDuplexHandler.java:203)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.NettyRpcDuplexHandler.channelInactive(NettyRpcDuplexHandler.java:211)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:262)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:248)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.fireChannelInactive(AbstractChannelHandlerContext.java:241)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.handler.codec.ByteToMessageDecoder.channelInputClosed(ByteToMessageDecoder.java:386)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.handler.codec.ByteToMessageDecoder.channelInactive(ByteToMessageDecoder.java:351)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:262)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:248)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.fireChannelInactive(AbstractChannelHandlerContext.java:241)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.ChannelInboundHandlerAdapter.channelInactive(ChannelInboundHandlerAdapter.java:81)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.handler.timeout.IdleStateHandler.channelInactive(IdleStateHandler.java:277)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:262)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:248)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.fireChannelInactive(AbstractChannelHandlerContext.java:241)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.DefaultChannelPipeline$HeadContext.channelInactive(DefaultChannelPipeline.java:1405)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:262)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:248)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.DefaultChannelPipeline.fireChannelInactive(DefaultChannelPipeline.java:901)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannel$AbstractUnsafe$8.run(AbstractChannel.java:818)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:164)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:472)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:497)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)

2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] ... 1 more

Re: Unable to connect to CDP phoenix from Spring Boot

willx — Wed, 19 Apr 2023 05:36:40 GMT

Hi @Sindhu6,

Please make sure phoenix and hbase are functional by accessing phoenix-sqlline and creating a test table then select data from it prior to using jdbc.

Then please refer to the below doc for phoenix jdbc usage in cdp:

https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/phoenix-access-data/topics/phoenix-orchestrating-sql.html

Re: Unable to connect to CDP phoenix from Spring Boot

Sindhu6 — Wed, 19 Apr 2023 07:47:17 GMT

Hi willx, I have validated from sqlline script. It is connecting successfully.

From my application am using the phoenix jdbc url in below formats:

1. jdbc:phoenix:[***zookeeper_quorum***]:[***zookeeper_port***]:[***zookeeper_hbase_path***]

2. jdbc:phoenix:thin:url=http://queryserver.domain:8765;serialization=PROTOBUF;authentication=SPENGO;principal=phoenix@EXAMPLE.COM;keytab=/etc/security/keytabs/phoenix.keytab

I am not clear as to what is the right phoenix url to be used from the java application

Re: Unable to connect to CDP phoenix from Spring Boot

Sindhu6 — Wed, 19 Apr 2023 07:48:12 GMT

Hi willx, please let me know if we an option to setup a call and understand or clarify my doubts

Re: Unable to connect to CDP phoenix from Spring Boot

willx — Wed, 19 Apr 2023 08:29:49 GMT

Please check if your principal and keytab are set correctly.

Here is another example:

thick client:

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/phoenix_using.html

thin client:

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/phoenix_thin_client_pqs.html

Re: Unable to connect to CDP phoenix from Spring Boot

Sindhu6 — Wed, 19 Apr 2023 08:41:54 GMT

Hi willx, am using the thick client and it is the same format as in the documentation you have just shared am using in my code.

To informm you i donot have a keytab but i have kerberos cache which ma pointing to.

And for the thin client:

jdbc:phoenix:thin:url=http://localhost:8765;serialization=PROTOBUF; authentication=SPNEGO;principal=pqs@EXAMPLE.COM;keytab=/etc/security/keytabs/phoenix.keytab

what should be the value for url , here it is 8765 port, which is that server with 8765 port.

Also from my logs i see that ,

"Trying to connect to a secure cluster as a024563@EXCHAD.JPMCHASE.NET with keytab /app/jpmc_bsid/ccache/ccache_a024563.crd"}
2023-04-18T07:43:00.509+05:30 [APP/PROC/WEB/0] [OUT] {"TIMESTAMP":"2023-04-17 22:13:00.509/EDT","LEVEL":"INFO ","POOL":"na-3z","ENV":"dev","THREAD":"[http-nio-8080-exec-3]", application-id: slot-web-gaia, "SERV":"100.127.13.51:61010","CF_INSTANCE_INDEX":"0,,"CF_INSTANCE_GUID":"e7bc4234-666b-4cb3-7ef9-12fa,"MESSAGE":"Successful login to secure cluster"}

By this is it that the login to CDP is success and then is the issue with query now or authentication am getting.

Re: Unable to connect to CDP phoenix from Spring Boot

Sindhu6 — Wed, 19 Apr 2023 08:46:30 GMT

From the documentation you shared for thin client it seems we need to use a avatica certificate and username , password onboarded on to Avatica.

In that case i need to go with thick client only.

Can you please support me on my issue.

Re: Unable to connect to CDP phoenix from Spring Boot

willx — Thu, 20 Apr 2023 12:01:58 GMT

@Sindhu6 Please refer to this phoenix doc for java example and url syntax:

https://phoenix.apache.org/faq.html#What_is_the_Phoenix_JDBC_URL_syntax

An example URL is

jdbc:phoenix:thin:url=http://hostname:8765;serialization=PROTOBUF;authentication=SPNEGO;

principal=hbase/hostname@EXAMPLE;

keytab=/var/run/cloudera-scm-agent/process/xx-hbase-REGIONSERVER/hbase.keytab

(due to system will hide long text, devide into multiple lines, but you need write url into single line.)

Jar is /opt/cloudera/parcels/CDH-7.1.x/jars/phoenix-queryserver-client-xxx.jar

Driver Class is "org.apache.phoenix.queryserver.client.Driver"

You should replace keytab, principle, jar with your own and start to test single java class instead of complex projects.

Re: Unable to connect to CDP phoenix from Spring Boot

Sindhu6 — Sat, 22 Apr 2023 08:41:01 GMT

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.

Re: Unable to connect to CDP phoenix from Spring Boot

Sindhu6 — Sat, 22 Apr 2023 08:42:08 GMT

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

Re: Unable to connect to CDP phoenix from Spring Boot

Sindhu6 — Thu, 04 May 2023 09:45:08 GMT

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

Re: Unable to connect to CDP phoenix from Spring Boot

Sindhu6 — Fri, 14 Jul 2023 08:17:47 GMT

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