sunkai-cai commented on issue #24152: URL: https://github.com/apache/shardingsphere/issues/24152#issuecomment-1434052827
> @sunkai-cai This is the exception log I got. We can see the information of `Connection refused`, which is the original information provided by the driver. > > ``` > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure > at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) > at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) > at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:342) > at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2197) > at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230) > at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025) > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778) > at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) > at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) > at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) > at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) > at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) > at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) > at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) > at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) > at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) > at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) > at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) > at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) > at org.apache.shardingsphere.infra.datasource.state.DataSourceStateManager.checkState(DataSourceStateManager.java:84) > at org.apache.shardingsphere.infra.datasource.state.DataSourceStateManager.initState(DataSourceStateManager.java:79) > at org.apache.shardingsphere.infra.datasource.state.DataSourceStateManager.lambda$initStates$0(DataSourceStateManager.java:70) > at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721) > at org.apache.shardingsphere.infra.datasource.state.DataSourceStateManager.initStates(DataSourceStateManager.java:70) > at org.apache.shardingsphere.mode.metadata.MetaDataContextsFactory.lambda$checkDataSourceStates$4(MetaDataContextsFactory.java:113) > at java.base/java.util.HashMap.forEach(HashMap.java:1421) > at org.apache.shardingsphere.mode.metadata.MetaDataContextsFactory.checkDataSourceStates(MetaDataContextsFactory.java:111) > at org.apache.shardingsphere.mode.metadata.MetaDataContextsFactory.create(MetaDataContextsFactory.java:87) > at org.apache.shardingsphere.mode.metadata.MetaDataContextsFactory.create(MetaDataContextsFactory.java:68) > at org.apache.shardingsphere.mode.manager.standalone.StandaloneContextManagerBuilder.build(StandaloneContextManagerBuilder.java:53) > at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.createContextManager(BootstrapInitializer.java:69) > at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.init(BootstrapInitializer.java:59) > at org.apache.shardingsphere.proxy.Bootstrap.main(Bootstrap.java:53) > Caused by: java.net.ConnectException: Connection refused > at java.base/sun.nio.ch.Net.pollConnect(Native Method) > at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672) > at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542) > at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597) > at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327) > at java.base/java.net.Socket.connect(Socket.java:633) > at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211) > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:301) > ... 34 common frames omitted > Exception in thread "main" org.apache.shardingsphere.infra.datasource.state.exception.UnavailableDataSourceException: DATA-SOURCE-00001: Data source unavailable. > at org.apache.shardingsphere.infra.datasource.state.DataSourceStateManager.lambda$checkState$1(DataSourceStateManager.java:87) > at org.apache.shardingsphere.infra.util.exception.ShardingSpherePreconditions.checkState(ShardingSpherePreconditions.java:41) > at org.apache.shardingsphere.infra.datasource.state.DataSourceStateManager.checkState(DataSourceStateManager.java:87) > at org.apache.shardingsphere.infra.datasource.state.DataSourceStateManager.initState(DataSourceStateManager.java:79) > at org.apache.shardingsphere.infra.datasource.state.DataSourceStateManager.lambda$initStates$0(DataSourceStateManager.java:70) > at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721) > at org.apache.shardingsphere.infra.datasource.state.DataSourceStateManager.initStates(DataSourceStateManager.java:70) > at org.apache.shardingsphere.mode.metadata.MetaDataContextsFactory.lambda$checkDataSourceStates$4(MetaDataContextsFactory.java:113) > at java.base/java.util.HashMap.forEach(HashMap.java:1421) > at org.apache.shardingsphere.mode.metadata.MetaDataContextsFactory.checkDataSourceStates(MetaDataContextsFactory.java:111) > at org.apache.shardingsphere.mode.metadata.MetaDataContextsFactory.create(MetaDataContextsFactory.java:87) > at org.apache.shardingsphere.mode.metadata.MetaDataContextsFactory.create(MetaDataContextsFactory.java:68) > at org.apache.shardingsphere.mode.manager.standalone.StandaloneContextManagerBuilder.build(StandaloneContextManagerBuilder.java:53) > at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.createContextManager(BootstrapInitializer.java:69) > at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.init(BootstrapInitializer.java:59) > at org.apache.shardingsphere.proxy.Bootstrap.main(Bootstrap.java:53) > Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure > at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) > at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) > at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:342) > at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2197) > at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230) > at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025) > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778) > at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) > at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) > at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) > at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) > at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) > at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) > at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) > at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) > at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) > at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) > at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) > at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) > at org.apache.shardingsphere.infra.datasource.state.DataSourceStateManager.checkState(DataSourceStateManager.java:84) > ... 13 more > Caused by: java.net.ConnectException: Connection refused > at java.base/sun.nio.ch.Net.pollConnect(Native Method) > at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672) > at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542) > at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597) > at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327) > at java.base/java.net.Socket.connect(Socket.java:633) > at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211) > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:301) > ... 34 more > ``` the `UnavailableDataSourceException` message is "DATA-SOURCE-00001: Data source unavailable." , We can add more information to it. ``` Exception in thread "main" org.apache.shardingsphere.infra.datasource.state.exception.UnavailableDataSourceException: DATA-SOURCE-00001: Data source unavailable. ``` -- 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]
