[
https://issues.apache.org/jira/browse/PHOENIX-5081?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16728840#comment-16728840
]
huangzh commented on PHOENIX-5081:
----------------------------------
[~Jaanai]
Can't you use connection pools?
Is there a connection pool available to manage Phoenix JDBC connections?
Please teach me,Thanks.
> Used Druid JDBC Connection Pool,Sometimes Throws Exception Connection is null
> or closed.
> ----------------------------------------------------------------------------------------
>
> Key: PHOENIX-5081
> URL: https://issues.apache.org/jira/browse/PHOENIX-5081
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.14.0
> Environment: Spring:4.3
> Mybais:3.2.2
> mybais-spring:1.2.0
> Hbase:1.2.6
> Hadoop:2.7.5
> Reporter: huangzh
> Priority: Minor
> Labels: mesosphere, newbie, patch
> Fix For: 4.14.0
>
> Original Estimate: 1h
> Remaining Estimate: 1h
>
> Driuid Spring Config:
> <!-- Phoneix DataSource -->
> <bean name="dataSource1" class="com.alibaba.druid.pool.DruidDataSource"
> init-method="init" destroy-method="close">
> <property name="driverClassName"
> value="org.apache.phoenix.jdbc.PhoenixDriver" />
> <property name="url" value="${jdbc_hbase_url}" />
> <property name="username" value="${jdbc_hbase_username}" />
> <property name="password" value="${jdbc_hbase_password}" />
> <property name="connectionProperties"
> value="phoenix.connection.schema=${jdbc_hbase_schema};
> phoenix.schema.isNamespaceMappingEnabled=true;
> phoenix.schema.mapSystemTablesToNamespace=true;
> phoenix.query.timeoutMs=1800000;
> phoenix.query.threadPoolSize=512MB;
> hbase.regionserver.lease.period=1800000;
> hbase.rpc.timeout=1800000;
> hbase.client.scanner.caching=1000;
> hbase.client.scanner.timeout.period=1800000;"/>
> <property name="initialSize" value="0" />
> <property name="maxActive" value="20" />
> <property name="minIdle" value="0" />
> <property name="maxWait" value="60000" />
> <property name="poolPreparedStatements" value="true" />
> <property name="maxPoolPreparedStatementPerConnectionSize"
> value="33" />
> <!-- <property name="validationQuery" value="${validationQuery}" /> -->
> <property name="testOnBorrow" value="false" />
> <property name="testOnReturn" value="false" />
> <property name="testWhileIdle" value="true" />
> <property name="timeBetweenEvictionRunsMillis" value="60000" />
> <property name="minEvictableIdleTimeMillis" value="25200000" />
> <property name="removeAbandoned" value="true" />
> <property name="removeAbandonedTimeout" value="1800" />
> <property name="logAbandoned" value="true" />
> <property name="filters" value="mergeStat" />
> <property name="defaultAutoCommit" value="true" />
> </bean>
> Exception:
> ### Error updating database. Cause: java.sql.SQLException:
> java.lang.IllegalArgumentException: Connection is null or closed.
> ### The error may involve defaultParameterMap
> ### The error occurred while setting parameters
> ### SQL: UPSERT INTO TD_RECODE( SN, INTIME, RECODE, IP ) VALUES( ?, ?, ?, ? )
> ### Cause: java.sql.SQLException: java.lang.IllegalArgumentException:
> Connection is null or closed.
> ; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
> java.lang.IllegalArgumentException: Connection is null or closed.; nested
> exception is java.sql.SQLException: java.lang.IllegalArgumentException:
> Connection is null or closed.
> at
> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
> at
> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
> at
> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
> at
> org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
> at
> org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:364)
> at com.sun.proxy.$Proxy23.update(Unknown Source)
> at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:250)
> at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:49)
> at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:43)
> at com.sun.proxy.$Proxy35.saveRecord(Unknown Source)
> at com.chis.jmll.sjcj.dao.SaveRecodeTx.run(SaveRecodeTx.java:34)
> at com.chis.jmll.comm.TxMgmtModule.executeHUpdate(TxMgmtModule.java:98)
> at
> com.chis.jmll.sjcj.service.impl.SjcjServiceImpl.saveRecode(SjcjServiceImpl.java:47)
> at com.alibaba.dubbo.common.bytecode.Wrapper1.invokeMethod(Wrapper1.java)
> at
> com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:45)
> at
> com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:71)
> at
> com.alibaba.dubbo.config.invoker.DelegateProviderMetaDataInvoker.invoke(DelegateProviderMetaDataInvoker.java:48)
> at
> com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:52)
> at
> com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:61)
> at
> com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
> at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:41)
> at
> com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
> at
> com.alibaba.dubbo.rpc.filter.ExecuteLimitFilter.invoke(ExecuteLimitFilter.java:59)
> at
> com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
> at
> com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:74)
> at
> com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
> at
> com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:77)
> at
> com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
> at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:60)
> at
> com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
> at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:131)
> at
> com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
> at
> com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:37)
> at
> com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
> at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:37)
> at
> com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
> at
> com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:95)
> at
> com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:96)
> at
> com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:168)
> at
> com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:50)
> at
> com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:79)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.sql.SQLException: java.lang.IllegalArgumentException:
> Connection is null or closed.
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:1325)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:1287)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.getTable(ConnectionQueryServicesImpl.java:1504)
> at
> org.apache.phoenix.query.DelegateConnectionQueryServices.getTable(DelegateConnectionQueryServices.java:108)
> at
> org.apache.phoenix.schema.MetaDataClient.updateCache(MetaDataClient.java:596)
> at
> org.apache.phoenix.schema.MetaDataClient.updateCache(MetaDataClient.java:519)
> at
> org.apache.phoenix.schema.MetaDataClient.updateCache(MetaDataClient.java:511)
> at
> org.apache.phoenix.schema.MetaDataClient.updateCache(MetaDataClient.java:507)
> at org.apache.phoenix.execute.MutationState.validate(MutationState.java:805)
> at
> org.apache.phoenix.execute.MutationState.validateAll(MutationState.java:793)
> at org.apache.phoenix.execute.MutationState.send(MutationState.java:1005)
> at org.apache.phoenix.execute.MutationState.send(MutationState.java:1496)
> at org.apache.phoenix.execute.MutationState.commit(MutationState.java:1328)
> at
> org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:562)
> at
> org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:559)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixConnection.commit(PhoenixConnection.java:559)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:396)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:376)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:374)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:363)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:269)
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:172)
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:177)
> at
> com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
> at
> com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
> at
> com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
> at
> com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)
> at
> com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
> at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at
> org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:55)
> at com.sun.proxy.$Proxy43.execute(Unknown Source)
> at
> org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)
> at
> org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)
> at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)
> at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100)
> at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
> at
> org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148)
> at sun.reflect.GeneratedMethodAccessor88.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at
> org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:354)
> ... 39 more
> Caused by: java.lang.IllegalArgumentException: Connection is null or closed.
> at org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:308)
> at
> org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getTable(ConnectionManager.java:747)
> at
> org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getTable(ConnectionManager.java:729)
> at
> org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getTable(ConnectionManager.java:724)
> at
> org.apache.phoenix.query.HTableFactory$HTableFactoryImpl.getTable(HTableFactory.java:51)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.getTable(ConnectionQueryServicesImpl.java:456)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:1304)
> ... 83 more
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
