请稍等 ...
×

采纳答案成功！

向帮助你的同学说点啥吧！感谢那些助人为乐的人

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

[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)
强jay强 2018-05-29 19:57:49
源自：6-6  通过mybatis操作Phoenix
4328
收起

正在回答 回答被采纳积分+3

2回答

jinglun 2019-02-11 10:23:26

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 回复 有任何疑惑可以回复我~
收起回答
取消 回复
叁金 2018-05-29 20:21:09 
[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 回复 有任何疑惑可以回复我~
收起回答
  • 提问者 强jay强 #1 
    我这个是装在虚拟机上，hostname和ip地址是一样的，虽然报这个错，但数据可以正常的查询出来  ，采用这种方式就不会报这个问题：Class.forName("org.apache.phoenix.jdbc.PhoenixDriver");
		Connection conn = DriverManager.getConnection("jdbc:phoenix:192.168.0.114:2181");
		PreparedStatement ps = conn.prepareStatement("select * from PERSON");
		ResultSet rs = ps.executeQuery();
    回复 有任何疑惑可以回复我~ 2018-05-29 20:28:36
  • 叁金 回复 提问者 强jay强 #2 
    你报错和不报错的区别在哪。。。IP地址？
    回复 有任何疑惑可以回复我~ 2018-05-29 23:17:39
  • 提问者 强jay强 回复 叁金 #3 
    没什么区别，都能获取到数据
    回复 有任何疑惑可以回复我~ 2018-05-30 08:56:25
点开查看后面1条评论
取消 回复

相似问题

文章扩展——累计浏览次数的数据绑定问题
1070 2 2
本节相关两个问题
870 0 2
资源加载合并章节为什么没有提到http2？
948 2 1
幂等性校验问题请教
1898 0 8
老师你好，我看你讲解通过版本号实现乐观锁的时候，你说如果真实系统中简单这么做的话是有问题的，这个具体是什么问题呢？我感觉使用版本号匹配的话，没有问题啊
891 3 5

登录后可查看更多问答，登录/注册

问题已解决，确定采纳
还有疑问，暂不采纳
HBase+Spring Boot实战分布式文件存储（OpenTSDB实战升级）
  • 参与学习       493    人
  • 解答问题       167    个

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

了解课程

本课精华内容

问答

hbase里面建表的统一语句github上找不到

1.0k 17

zookeeper启动失败

1.4k 16

老师，Phoenix 无法连接虚拟机中（系统ubuntu）的HBase，这个需要在Phoenix配置什么吗

1.5k 11

请问老师 hbase能存多少数据，如果一张表上TB了，用phoenix做查询会不会很慢？

1.1k 9

java API部分启动报错虽然测试通过但是感觉好不舒服

1.2k 7

查看更多本课问答
微信客服

购课补贴
联系客服咨询优惠详情

 帮助反馈 APP下载

慕课网APP
您的移动学习伙伴

 公众号

扫描二维码
关注慕课网微信公众号