You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/06/17 04:11:31 UTC
[GitHub] [shardingsphere] zjcnb opened a new issue, #18405: HikariDataSource (HikariPool-1) has been closed occurred when use `ShardingSphere-JDBC`
zjcnb opened a new issue, #18405:
URL: https://github.com/apache/shardingsphere/issues/18405
## Bug Report
### Which version of ShardingSphere did you use?
`master`
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
`ShardingSphere-JDBC`
```
[ERROR] 2022-06-17 12:02:16,450 --Curator-SafeNotifyService-0-- [com.google.common.eventbus.EventBus.default] Exception thrown by subscriber method renew(org.apache.shardingsphere.mode.manager.cluster.coordinator.registry.config.event.schema.SchemaChangedEvent) on subscriber org.apache.shardingsphere.mode.manager.cluster.coordinator.ClusterContextManagerCoordinator@2fbbb850 when dispatching event: org.apache.shardingsphere.mode.manager.cluster.coordinator.registry.config.event.schema.SchemaChangedEvent@531e2642
java.lang.IllegalArgumentException: HikariDataSource HikariDataSource (HikariPool-1) has been closed.
at org.apache.shardingsphere.infra.database.type.DatabaseTypeEngine.getDatabaseType(DatabaseTypeEngine.java:101)
at org.apache.shardingsphere.infra.database.type.DatabaseTypeEngine.getDatabaseType(DatabaseTypeEngine.java:90)
at org.apache.shardingsphere.singletable.rule.SingleTableRule.<init>(SingleTableRule.java:77)
at org.apache.shardingsphere.singletable.rule.builder.SingleTableRuleBuilder.build(SingleTableRuleBuilder.java:39)
at org.apache.shardingsphere.singletable.rule.builder.SingleTableRuleBuilder.build(SingleTableRuleBuilder.java:34)
at org.apache.shardingsphere.infra.rule.builder.schema.DatabaseRulesBuilder.build(DatabaseRulesBuilder.java:56)
at org.apache.shardingsphere.mode.manager.ContextManager.refreshRules(ContextManager.java:210)
at org.apache.shardingsphere.mode.manager.ContextManager.alterSingleTableDataNodes(ContextManager.java:205)
at org.apache.shardingsphere.mode.manager.ContextManager.alterTableSchema(ContextManager.java:196)
at org.apache.shardingsphere.mode.manager.ContextManager.lambda$alterSchema$2(ContextManager.java:184)
at java.util.Optional.ifPresent(Optional.java:159)
at org.apache.shardingsphere.mode.manager.ContextManager.alterSchema(ContextManager.java:184)
at org.apache.shardingsphere.mode.manager.cluster.coordinator.ClusterContextManagerCoordinator.renew(ClusterContextManagerCoordinator.java:149)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.google.common.eventbus.Subscriber.invokeSubscriberMethod(Subscriber.java:87)
at com.google.common.eventbus.Subscriber$SynchronizedSubscriber.invokeSubscriberMethod(Subscriber.java:144)
at com.google.common.eventbus.Subscriber$1.run(Subscriber.java:72)
at com.google.common.util.concurrent.DirectExecutor.execute(DirectExecutor.java:30)
at com.google.common.eventbus.Subscriber.dispatchEvent(Subscriber.java:67)
at com.google.common.eventbus.Dispatcher$PerThreadQueuedDispatcher.dispatch(Dispatcher.java:108)
at com.google.common.eventbus.EventBus.post(EventBus.java:212)
at java.util.Optional.ifPresent(Optional.java:159)
at org.apache.shardingsphere.mode.manager.cluster.coordinator.registry.GovernanceWatcherFactory.lambda$watch$0(GovernanceWatcherFactory.java:55)
at org.apache.shardingsphere.mode.repository.cluster.zookeeper.CuratorZookeeperRepository.lambda$watch$0(CuratorZookeeperRepository.java:240)
at org.apache.curator.framework.recipes.cache.TreeCacheListenerWrapper.sendEvent(TreeCacheListenerWrapper.java:71)
at org.apache.curator.framework.recipes.cache.TreeCacheListenerWrapper.event(TreeCacheListenerWrapper.java:42)
at org.apache.curator.framework.recipes.cache.CuratorCacheListenerBuilderImpl$2.lambda$event$0(CuratorCacheListenerBuilderImpl.java:149)
at java.util.ArrayList.forEach(ArrayList.java:1257)
at org.apache.curator.framework.recipes.cache.CuratorCacheListenerBuilderImpl$2.event(CuratorCacheListenerBuilderImpl.java:149)
at org.apache.curator.framework.recipes.cache.CuratorCacheImpl.lambda$putStorage$7(CuratorCacheImpl.java:279)
at org.apache.curator.framework.listen.MappingListenerManager.lambda$forEach$0(MappingListenerManager.java:92)
at org.apache.curator.framework.listen.MappingListenerManager.forEach(MappingListenerManager.java:89)
at org.apache.curator.framework.listen.StandardListenerManager.forEach(StandardListenerManager.java:89)
at org.apache.curator.framework.recipes.cache.CuratorCacheImpl.lambda$callListeners$10(CuratorCacheImpl.java:293)
at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1626)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: HikariDataSource HikariDataSource (HikariPool-1) has been closed.
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:96)
at org.apache.shardingsphere.infra.database.type.DatabaseTypeEngine.getDatabaseType(DatabaseTypeEngine.java:98)
... 39 common frames omitted
Process finished with exit code 0
```
Please run `ClusterModeRawJavaConfigurationExample` main method.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #18405: HikariDataSource (HikariPool-1) has been closed occurred when use `ShardingSphere-JDBC`
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #18405:
URL: https://github.com/apache/shardingsphere/issues/18405#issuecomment-1275433821
Hi, could we finish this issue in 5.2.1?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zjcnb commented on issue #18405: HikariDataSource (HikariPool-1) has been closed occurred when use `ShardingSphere-JDBC`
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #18405:
URL: https://github.com/apache/shardingsphere/issues/18405#issuecomment-1160252690
The problem reason, there are many tables in my database. The data source has been close but event not process completed when i shutdown my application.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] closed issue #18405: HikariDataSource (HikariPool-1) has been closed occurred when use `ShardingSphere-JDBC`
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #18405: HikariDataSource (HikariPool-1) has been closed occurred when use `ShardingSphere-JDBC`
URL: https://github.com/apache/shardingsphere/issues/18405
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #18405: HikariDataSource (HikariPool-1) has been closed occurred when use `ShardingSphere-JDBC`
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #18405:
URL: https://github.com/apache/shardingsphere/issues/18405#issuecomment-1223921912
Hi @zjcnb , could we finish this issue in `5.1.3`?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #18405: HikariDataSource (HikariPool-1) has been closed occurred when use `ShardingSphere-JDBC`
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #18405:
URL: https://github.com/apache/shardingsphere/issues/18405#issuecomment-1272349613
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org