Cloudera Community

Support Questions

Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search

Unable to connect to CDP phoenix from Spring Boot

Labels:
avatar
author-rank Sindhu6
Explorer

Created ‎04-17-2023 10:07 PM

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

 

4,196 Views
0 Kudos
13 REPLIES 13

avatar
author-rank VidyaSargur author-rank
Community Manager

Created on ‎04-18-2023 01:25 AM - edited ‎04-18-2023 01:26 AM

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


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.
Learn more about the Cloudera Community:
3,445 Views
0 Kudos

avatar
author-rank Sindhu6
Explorer

Created ‎04-18-2023 02:19 AM

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

 

 

 

3,424 Views
0 Kudos

avatar
author-rank willx author-rank
Master Collaborator

Created ‎04-18-2023 10:36 PM

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

3,387 Views
0 Kudos

avatar
author-rank Sindhu6
Explorer

Created ‎04-19-2023 12:47 AM

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

 

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

3,371 Views
0 Kudos

avatar
author-rank Sindhu6
Explorer

Created ‎04-19-2023 12:48 AM

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

3,371 Views
0 Kudos

avatar
author-rank willx author-rank
Master Collaborator

Created ‎04-19-2023 01:29 AM

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

 

 

3,335 Views
0 Kudos

avatar
author-rank Sindhu6
Explorer

Created ‎04-19-2023 01:41 AM

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.

3,334 Views
0 Kudos

avatar
author-rank Sindhu6
Explorer

Created ‎04-19-2023 01:46 AM

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.

3,332 Views
0 Kudos

avatar
author-rank willx author-rank
Master Collaborator

Created on ‎04-20-2023 04:57 AM - edited ‎04-20-2023 05:01 AM

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

3,270 Views
0 Kudos
Announcements
What's New @ Cloudera
Cloudera DataFlow 2.9 now supports building GenAI pipelines ...
What's New @ Cloudera
Accelerate Data Scientist Productivity with Cloudera Copilot...
What's New @ Cloudera
[RELEASED] Cloudera Streaming Analytics - Kubernetes Operato...
Community Announcements
October 2024 Community Highlights
What's New @ Cloudera
Accelerate Your AI with the Cloudera AI Inference Service wi...
View More Announcements