phoenix-5.1.2 Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM

最新推荐文章于 2023-04-11 16:29:39 发布
最新推荐文章于 2023-04-11 16:29:39 发布
阅读量1k 收藏
点赞数
分类专栏： java 文章标签： java hbase 大数据
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_21480329/article/details/120477012
版权

Caused by: java.sql.SQLException: ERROR 726 (43M10): Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled

​ java jdbc连接phoenix5.1.2查询报错,报错信息

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:630)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:805)
	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:824)
	at org.springframework.jdbc.core.JdbcTemplate.queryForLong(JdbcTemplate.java:852)
	at cn.itcast.dao.impl.AppTrafficDaoImpl.getAppRAteSum(AppTrafficDaoImpl.java:137)
	at cn.itcast.service.AppTrafficService.getAppRateRank_pie(AppTrafficService.java:44)
	at cn.itcast.controller.NWQualityController.getDashBoard(NWQualityController.java:106)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:196)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:364)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:624)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1650)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
	at org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:164)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	... 56 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
	... 60 more
Caused by: java.sql.SQLException: ERROR 726 (43M10):  Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled
	at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:494)
	at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1113)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1501)
	at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2721)
	at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:1114)
	at org.apache.phoenix.compile.CreateTableCompiler$1.execute(CreateTableCompiler.java:192)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:408)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:391)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:390)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:378)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1806)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2569)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2532)
	at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2532)
	at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255)
	at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:150)
	at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:161)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

解决方案，如下:
1.hbase-site.xml新增配置

	<!-- 如果使用了 hbase 中的自定义 namespace，不仅仅使用default -->
	<!-- 那么在phoenix中与之对应的是schema的概念，但是默认并没有开启，需要在增加以下配置项 -->
	<property>
	  <name>phoenix.schema.isNamespaceMappingEnabled</name>
	  <value>true</value>
	</property>

但是新增配置后，再次运行代码，日志仍然记录同样错误。

2.项目resource目录下新增hbase-site.xml配置
项目使用hbase-2.4.2及phoenix 5.1.2，resource目录下新增hbase-site.xml配置，再次运行项目，查询正常。
在这里插入图片描述

相关大数据学习demo地址:

https://github.com/carteryh/big-data

qq_21480329
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
关于Phoenix报错：Inconsistent namespace mapping properites的解决方案
tuanererer的博客
10-28 2822
关于Phoenix报错：Inconsistent namespace mapping properites的解决方案 报错信息如下： Exception in thread "main" java.sql.SQLException: ERROR 726 (43M10): Inconsistent namespace mapping properites.. Cannot initiate connection as SYSTEM:CATALOG is found but client does not h
Phoenix 启动报错： Error: ERROR 726 (43M10): Inconsistent namespace mapping properties. Cannot initiate
weixin_43530138的博客
08-07 6967
Phoenix 启动报错： Error: ERROR 726 (43M10): Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnab...
Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but
m0_37759590的博客
11-10 889
Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled 原因：phoenix映射失败
Inconsistent namespace mapping properties. Cannot initiate connection as SYS
lzp12345677的博客
08-21 2776
完整错误 Error: ERROR 726 (43M10): Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled (state=43M10,code=726) 如果你在配置文件中配置了这个 <proper
Phoenix报错：Inconsistent namespace mapping properties，Cannot initiate connection as SYSTEM:CATALOG
孙大迪迪的博客
03-10 2593
Spark API读取Phoenix数据报错： nconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have 在hbase shell修改如下解决： 1）disable 'SYSTEM:CATALOG' 2）snap...
使用DBeaver连接Phoenix异常Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:
硅谷工具人
06-05 548
ERROR 726 (43M10): Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled 在使用DBe...
phoenix-hbase-2.2-5.1.2-bin.tar.gz
05-07
phoenix-hbase-2.2-5.1.2-bin.tar.gz
phoenix-client-hbase-2.2-5.1.2.jar
12-10
phoenix-client-hbase-2.2-5.1.2.jar
phoenix-hbase-2.4-5.1.2
03-09
phoenix-hbase-2.4-5.1.2
amqp-client-5.1.2-API文档-中文版.zip
06-26
赠送原API文档：amqp-client-5.1.2-javadoc.jar； 赠送源代码：amqp-client-5.1.2-sources.jar； 赠送Maven依赖信息文件：amqp-client-5.1.2.pom； 包含翻译后的API文档：amqp-client-5.1.2-javadoc-API文档-中文...
python2-pbr-5.1.2-2.el7.noarch.rpm
12-31
官方离线安装包，测试可用。使用rpm -ivh [rpm完整包名] 进行安装
Phoenix 启动报错： Error: ERROR 726 (43M10): Inconsistent namespace mapping properties. Cannot initiate
BuildH的博客
07-12 904
phoenix问题
Phoenix 启动报错：ERROR 726 (43M10): Inconsistent namespace mapping properties
hjhjinghui的博客
04-11 966
Phoenix 启动报错：ERROR 726 (43M10): Inconsistent namespace mapping properties
Error: ERROR 726 (43M10): Inconsistent namespace mapping properties. Cannot initiate connection as S
weixin_49068055的博客
11-05 1470
Error: ERROR 726 (43M10): Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have sparkstreaming 向phoenix写数据报异常:Phoenix 启动报错： Error: ERROR 726 (43M10): Inconsistent namespace mapping propert
API连接phoenix报错:java.sql.SQLException: ERROR 726 (43M10): Inconsistent namespace mapping properties
xxxxiju的博客
10-06 791
连接phoenix时配置环境参数完全没问题的情况下出现的连接不上
Inconsistent namespace mapping properties.
qq_38126315的博客
08-17 670
phoenix报错：Inconsistent namespace mapping properties. com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(593)|MyHikariCP - Exception during pool initialization. java.sql.SQLException: ERROR 726 (43M10): Inconsistent namespace mapping proper
spring boot 连接Phoenix 报错SYSTEM:CATALOG is found but client
BertramLAU的专栏
02-26 3932
错误详情： 18:19:14.527 [taskScheduler-1] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - Unexpected error occurred in scheduled task. org.springframework.jdbc.CannotGetJdbcConnectionException: Could not ge...
SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled
王猛的博客
01-24 7107
问题 Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled 详细展示 java.sql.SQLExcepti...
运行sudo yum install xz-libs-5.1.2alpha-4.el7.x86_64时出现There was a problem importing one of the Python modules required to run yum. The error leading to this problem was: /opt/conda/lib/liblzma.so.5: version `XZ_5.1.2alpha' not found (required by /lib64/librpmio.so.3)
最新发布
05-24
这个错误通常是由于系统上缺少某些依赖项而导致的。尝试运行以下命令，以安装缺失的依赖项： ``` sudo yum install xz-libs ``` 如果这不起作用，您可以尝试手动安装所需的依赖项。您可以从以下链接中下载并手动安装缺失的依赖项： https://pkgs.org/download/xz-libs-5.1.2alpha-4.el7.x86_64.rpm 下载后，运行以下命令以手动安装该软件包： ``` sudo rpm -Uvh xz-libs-5.1.2alpha-4.el7.x86_64.rpm ``` 完成后，您应该可以成功运行sudo yum install xz-libs-5.1.2alpha-4.el7.x86_64。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值