zjcnb opened a new issue #14086:
URL: https://github.com/apache/shardingsphere/issues/14086
### Which version of ShardingSphere did you use?
master
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
No need to recreate datasource when the same data source is refresh.
### Actual behavior
recreate datasource when i refresh my configuration.
### Error message
```
2021-12-15 15:10:21.053 INFO 5378 --- [NotifyService-0]
com.zaxxer.hikari.HikariDataSource : HikariPool-4 - Starting...
2021-12-15 15:10:21.184 INFO 5378 --- [NotifyService-0]
com.zaxxer.hikari.HikariDataSource : HikariPool-4 - Start completed.
2021-12-15 15:10:21.184 INFO 5378 --- [NotifyService-0]
com.zaxxer.hikari.HikariDataSource : HikariPool-5 - Starting...
2021-12-15 15:10:21.308 INFO 5378 --- [NotifyService-0]
com.zaxxer.hikari.HikariDataSource : HikariPool-5 - Start completed.
2021-12-15 15:10:21.308 INFO 5378 --- [NotifyService-0]
com.zaxxer.hikari.HikariDataSource : HikariPool-6 - Starting...
2021-12-15 15:10:21.425 INFO 5378 --- [NotifyService-0]
com.zaxxer.hikari.HikariDataSource : HikariPool-6 - Start completed.
2021-12-15 15:10:21.594 INFO 5378 --- [ool-20-thread-1]
com.zaxxer.hikari.HikariDataSource : HikariPool-3 - Shutdown initiated...
2021-12-15 15:10:21.595 INFO 5378 --- [ool-21-thread-1]
com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Shutdown initiated...
2021-12-15 15:10:21.595 INFO 5378 --- [ool-22-thread-1]
com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
2021-12-15 15:10:21.600 INFO 5378 --- [ool-20-thread-1]
com.zaxxer.hikari.HikariDataSource : HikariPool-3 - Shutdown completed.
2021-12-15 15:10:21.601 INFO 5378 --- [ool-21-thread-1]
com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Shutdown completed.
2021-12-15 15:10:21.602 INFO 5378 --- [ool-22-thread-1]
com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
2021-12-15 15:10:25.014 ERROR 5378 --- [-pr_ds_Worker-1]
o.a.s.d.mgr.MGRDatabaseDiscoveryType : An exception occurred while find
primary data source url
java.sql.SQLException: HikariDataSource HikariDataSource (HikariPool-3) has
been closed.
at
com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:96)
~[HikariCP-3.3.1.jar:na]
at
org.apache.shardingsphere.dbdiscovery.mgr.MGRDatabaseDiscoveryType.findPrimaryDataSourceURL(MGRDatabaseDiscoveryType.java:143)
[shardingsphere-db-discovery-mgr-5.0.1-SNAPSHOT.jar:5.0.1-SNAPSHOT]
at
org.apache.shardingsphere.dbdiscovery.mgr.MGRDatabaseDiscoveryType.determinePrimaryDataSource(MGRDatabaseDiscoveryType.java:134)
[shardingsphere-db-discovery-mgr-5.0.1-SNAPSHOT.jar:5.0.1-SNAPSHOT]
at
org.apache.shardingsphere.dbdiscovery.mgr.MGRDatabaseDiscoveryType.updatePrimaryDataSource(MGRDatabaseDiscoveryType.java:123)
[shardingsphere-db-discovery-mgr-5.0.1-SNAPSHOT.jar:5.0.1-SNAPSHOT]
at
org.apache.shardingsphere.dbdiscovery.heartbeat.HeartbeatJob.execute(HeartbeatJob.java:47)
[shardingsphere-db-discovery-core-5.0.1-SNAPSHOT.jar:5.0.1-SNAPSHOT]
at
org.apache.shardingsphere.dbdiscovery.rule.DatabaseDiscoveryRule.lambda$getCronJobs$2(DatabaseDiscoveryRule.java:214)
[shardingsphere-db-discovery-core-5.0.1-SNAPSHOT.jar:5.0.1-SNAPSHOT]
at
org.apache.shardingsphere.schedule.core.api.ModeScheduleContext$ConsumerSimpleJob.execute(ModeScheduleContext.java:148)
~[shardingsphere-schedule-core-5.0.1-SNAPSHOT.jar:5.0.1-SNAPSHOT]
at
org.apache.shardingsphere.elasticjob.simple.executor.SimpleJobExecutor.process(SimpleJobExecutor.java:33)
~[elasticjob-simple-executor-3.0.1.jar:3.0.1]
at
org.apache.shardingsphere.elasticjob.simple.executor.SimpleJobExecutor.process(SimpleJobExecutor.java:29)
~[elasticjob-simple-executor-3.0.1.jar:3.0.1]
at
org.apache.shardingsphere.elasticjob.executor.ElasticJobExecutor.process(ElasticJobExecutor.java:172)
~[elasticjob-executor-kernel-3.0.1.jar:3.0.1]
at
org.apache.shardingsphere.elasticjob.executor.ElasticJobExecutor.process(ElasticJobExecutor.java:141)
~[elasticjob-executor-kernel-3.0.1.jar:3.0.1]
at
org.apache.shardingsphere.elasticjob.executor.ElasticJobExecutor.execute(ElasticJobExecutor.java:124)
~[elasticjob-executor-kernel-3.0.1.jar:3.0.1]
at
org.apache.shardingsphere.elasticjob.executor.ElasticJobExecutor.execute(ElasticJobExecutor.java:100)
~[elasticjob-executor-kernel-3.0.1.jar:3.0.1]
at
org.apache.shardingsphere.elasticjob.lite.internal.schedule.LiteJob.execute(LiteJob.java:35)
~[elasticjob-lite-core-3.0.1.jar:3.0.1]
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
~[quartz-2.3.2.jar:na]
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
~[quartz-2.3.2.jar:na]
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
