请问,ssm整合phoenix,在多数据源的情况下,首次调用会有这个问题,这可能存在的问题是什么?

来源:6-6 通过mybatis操作Phoenix

强jay强

2018-05-29

[INFO][2018-05-29 19:52:22,642][org.apache.phoenix.query.ConnectionQueryServicesImpl]An instance of ConnectionQueryServices was created.

[INFO][2018-05-29 19:52:22,829][org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper]Process identifier=hconnection-0x2aa9fd0c connecting to ZooKeeper ensemble=192.168.0.114:2181

[INFO][2018-05-29 19:52:22,829][org.apache.zookeeper.ZooKeeper]Initiating client connection, connectString=192.168.0.114:2181 sessionTimeout=90000 watcher=org.apache.hadoop.hbase.zookeeper.PendingWatcher@2800f875

[INFO][2018-05-29 19:52:22,832][org.apache.zookeeper.ClientCnxn]Opening socket connection to server 192.168.0.114/192.168.0.114:2181. Will not attempt to authenticate using SASL (unknown error)

[INFO][2018-05-29 19:52:22,838][org.apache.zookeeper.ClientCnxn]Socket connection established to 192.168.0.114/192.168.0.114:2181, initiating session

[INFO][2018-05-29 19:52:22,843][org.apache.zookeeper.ClientCnxn]Session establishment complete on server 192.168.0.114/192.168.0.114:2181, sessionid = 0x16390b376b00041, negotiated timeout = 40000

[INFO][2018-05-29 19:52:23,121][org.apache.phoenix.query.ConnectionQueryServicesImpl]HConnection established. Stacktrace for informational purposes: hconnection-0x2aa9fd0c java.lang.Thread.getStackTrace(Unknown Source)

org.apache.phoenix.util.LogUtil.getCallerStackTrace(LogUtil.java:55)

org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:410)

org.apache.phoenix.query.ConnectionQueryServicesImpl.access$400(ConnectionQueryServicesImpl.java:256)

org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2408)

org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2384)

org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)

org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2384)

org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255)

org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:150)

org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221)

com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:148)

com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:220)

com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142)

com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1463)

com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525)

com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:734)

com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1060)

com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1056)

com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:104)

hry.core.datasource.MyAbstractRoutingDataSource.getConnection(MyAbstractRoutingDataSource.java:140)

org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)

org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:391)

org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)

org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:481)

org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:521)

hry.admin.hbase.controller.PersonController.test(PersonController.java:35)

hry.admin.hbase.controller.PersonController$$FastClassBySpringCGLIB$$21119ab0.invoke(<generated>)

org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:718)

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:52)

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)

org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)

org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)

hry.admin.hbase.controller.PersonController$$EnhancerBySpringCGLIB$$9b525d7f.test(<generated>)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

java.lang.reflect.Method.invoke(Unknown Source)

org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222)

org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)

org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)

org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:775)

org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705)

org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)

org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)

org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)

org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:965)

org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:856)

javax.servlet.http.HttpServlet.service(HttpServlet.java:622)

org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:841)

javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:198)

net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:176)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)

org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)

org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)

org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)

org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)

org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)

org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)

org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)

org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)

org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)

org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)

org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)

org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)

org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)

org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)

org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:617)

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)

org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)

org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668)

org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1527)

org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1484)

java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

java.lang.Thread.run(Unknown Source)


写回答

2回答

jinglun

2019-02-11

org.apache.phoenix.query.ConnectionQueryServicesImpl - HConnection established. Stacktrace for informational purposes: hconnection-0x9635fa java.lang.Thread.getStackTrace(Thread.java:1559)

org.apache.phoenix.util.LogUtil.getCallerStackTrace(LogUtil.java:55)

org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:427)

org.apache.phoenix.query.ConnectionQueryServicesImpl.access$400(ConnectionQueryServicesImpl.java:267)

org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2515)

org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2491)

org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)

org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2491)

org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255)

org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:150)

org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221)

java.sql.DriverManager.getConnection(DriverManager.java:664)

java.sql.DriverManager.getConnection(DriverManager.java:247)

com.yaokoudai.dao.config.phoenix.PhoenixUtil.dropView(PhoenixUtil.java:75)

com.yaokoudai.dao.config.phoenix.PhoenixUtil.testDropOrderView(PhoenixUtil.java:120)

com.yaokoudai.dao.config.phoenix.PhoenixUtil.main(PhoenixUtil.java:299)


0
0

叁金

2018-05-29

[INFO][2018-05-29 19:52:22,832][org.apache.zookeeper.ClientCnxn]Opening socket connection to server 192.168.0.114/192.168.0.114:2181. Will not attempt to authenticate using SASL (unknown error)

怀疑是这个的问题。  你看一下你的hosts配置与你zk的配置。  如果用hosts就都用hosts 用ip就都用ip

0
4
叁金
回复
强jay强
我是说代码和配置的区别。看错误是链接zk时的问题
2018-05-30
共4条回复

HBase+Spring Boot实战分布式文件存储(OpenTSDB实战升级)

深入浅出讲解HBase,让你轻松处理海量数据

493 学习 · 167 问题

查看课程