Skip to main content
Sindhu6
Sindhu6
Silver ⭐️⭐️⭐️
April 18, 2023
Question

Unable to connect to CDP phoenix from Spring Boot

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

 

13 replies

VidyaSargur
Community Manager
VidyaSargur
Community Manager
April 18, 2023

@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.

Translate
Regards, Vidya Sargur, Community Manager Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
Sindhu6
Sindhu6Author
Silver ⭐️⭐️⭐️
April 18, 2023

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

 

 

 

Translate
willx
Gold ⭐️⭐️⭐️
willx
Gold ⭐️⭐️⭐️
April 19, 2023

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

Translate
Sindhu6
Sindhu6Author
Silver ⭐️⭐️⭐️
April 19, 2023

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

Translate
Sindhu6
Sindhu6Author
Silver ⭐️⭐️⭐️
April 19, 2023

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

Translate
willx
Gold ⭐️⭐️⭐️
willx
Gold ⭐️⭐️⭐️
April 19, 2023

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

 

 

Translate
Sindhu6
Sindhu6Author
Silver ⭐️⭐️⭐️
April 19, 2023

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.

Translate
Sindhu6
Sindhu6Author
Silver ⭐️⭐️⭐️
April 19, 2023

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.

Translate
willx
Gold ⭐️⭐️⭐️
willx
Gold ⭐️⭐️⭐️
April 20, 2023

@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.

Translate
Sindhu6
Sindhu6Author
Silver ⭐️⭐️⭐️
April 22, 2023

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.

Translate
Sindhu6
Sindhu6Author
Silver ⭐️⭐️⭐️
April 22, 2023

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

Translate
Sindhu6
Sindhu6Author
Silver ⭐️⭐️⭐️
May 4, 2023

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

Translate
Terms & ConditionsAccessibility statement