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/07/02 15:44:41 UTC
[GitHub] [shardingsphere] zjcnb opened a new issue, #18792: javax.net.ssl.SSLException occurred when add resource by `DistSQL`
zjcnb opened a new issue, #18792:
URL: https://github.com/apache/shardingsphere/issues/18792
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
`master`
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
`ShardingSphere-Proxy`
```
Sat Jul 02 23:40:15 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sat Jul 02 23:40:15 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sat Jul 02 23:40:15 CST 2022 WARN: Caught while disconnecting...
EXCEPTION STACK TRACE:
** BEGIN NESTED EXCEPTION **
javax.net.ssl.SSLException
MESSAGE: closing inbound before receiving peer's close_notify
STACKTRACE:
javax.net.ssl.SSLException: closing inbound before receiving peer's close_notify
at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:751)
at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:730)
at com.mysql.jdbc.MysqlIO.quit(MysqlIO.java:2249)
at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4232)
at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1472)
at com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection.close(MysqlPooledConnection.java:183)
at com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection.close(JDBC4MysqlXAConnection.java:46)
at com.atomikos.datasource.xa.jdbc.JdbcTransactionalResource.close(JdbcTransactionalResource.java:153)
at com.atomikos.icatch.config.Configuration.removeAndCloseResources(Configuration.java:361)
at com.atomikos.icatch.config.Configuration.shutdown(Configuration.java:336)
at com.atomikos.icatch.config.Configuration.shutdown(Configuration.java:328)
at com.atomikos.icatch.config.UserTransactionServiceImp.shutdown(UserTransactionServiceImp.java:85)
at org.apache.shardingsphere.transaction.xa.atomikos.manager.AtomikosTransactionManagerProvider.close(AtomikosTransactionManagerProvider.java:67)
at org.apache.shardingsphere.transaction.xa.XAShardingSphereTransactionManager.close(XAShardingSphereTransactionManager.java:124)
at org.apache.shardingsphere.transaction.ShardingSphereTransactionManagerEngine.close(ShardingSphereTransactionManagerEngine.java:94)
at org.apache.shardingsphere.transaction.rule.TransactionRule.closeEngine(TransactionRule.java:111)
at org.apache.shardingsphere.transaction.rule.TransactionRule.addResource(TransactionRule.java:92)
at org.apache.shardingsphere.mode.manager.ContextManager.lambda$refreshMetaDataContext$18(ContextManager.java:496)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at org.apache.shardingsphere.mode.manager.ContextManager.refreshMetaDataContext(ContextManager.java:496)
at org.apache.shardingsphere.mode.manager.ContextManager.addResource(ContextManager.java:215)
at org.apache.shardingsphere.proxy.backend.text.distsql.rdl.resource.AddResourceBackendHandler.execute(AddResourceBackendHandler.java:63)
at org.apache.shardingsphere.proxy.backend.text.distsql.rdl.resource.AddResourceBackendHandler.execute(AddResourceBackendHandler.java:44)
at org.apache.shardingsphere.proxy.backend.text.DatabaseRequiredBackendHandler.execute(DatabaseRequiredBackendHandler.java:51)
at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:99)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:108)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:78)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
** END NESTED EXCEPTION **
Sat Jul 02 23:40:15 CST 2022 WARN: Caught while disconnecting...
EXCEPTION STACK TRACE:
** BEGIN NESTED EXCEPTION **
javax.net.ssl.SSLException
MESSAGE: closing inbound before receiving peer's close_notify
STACKTRACE:
javax.net.ssl.SSLException: closing inbound before receiving peer's close_notify
at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:751)
at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:730)
at com.mysql.jdbc.MysqlIO.quit(MysqlIO.java:2249)
at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4232)
at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1472)
at com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection.close(MysqlPooledConnection.java:183)
at com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection.close(JDBC4MysqlXAConnection.java:46)
at com.atomikos.datasource.xa.jdbc.JdbcTransactionalResource.close(JdbcTransactionalResource.java:153)
at com.atomikos.icatch.config.Configuration.removeAndCloseResources(Configuration.java:361)
at com.atomikos.icatch.config.Configuration.shutdown(Configuration.java:336)
at com.atomikos.icatch.config.Configuration.shutdown(Configuration.java:328)
at com.atomikos.icatch.config.UserTransactionServiceImp.shutdown(UserTransactionServiceImp.java:85)
at org.apache.shardingsphere.transaction.xa.atomikos.manager.AtomikosTransactionManagerProvider.close(AtomikosTransactionManagerProvider.java:67)
at org.apache.shardingsphere.transaction.xa.XAShardingSphereTransactionManager.close(XAShardingSphereTransactionManager.java:124)
at org.apache.shardingsphere.transaction.ShardingSphereTransactionManagerEngine.close(ShardingSphereTransactionManagerEngine.java:94)
at org.apache.shardingsphere.transaction.rule.TransactionRule.closeEngine(TransactionRule.java:111)
at org.apache.shardingsphere.transaction.rule.TransactionRule.addResource(TransactionRule.java:92)
at org.apache.shardingsphere.mode.manager.ContextManager.lambda$refreshMetaDataContext$18(ContextManager.java:496)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at org.apache.shardingsphere.mode.manager.ContextManager.refreshMetaDataContext(ContextManager.java:496)
at org.apache.shardingsphere.mode.manager.ContextManager.addResource(ContextManager.java:215)
at org.apache.shardingsphere.proxy.backend.text.distsql.rdl.resource.AddResourceBackendHandler.execute(AddResourceBackendHandler.java:63)
at org.apache.shardingsphere.proxy.backend.text.distsql.rdl.resource.AddResourceBackendHandler.execute(AddResourceBackendHandler.java:44)
at org.apache.shardingsphere.proxy.backend.text.DatabaseRequiredBackendHandler.execute(DatabaseRequiredBackendHandler.java:51)
at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:99)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:108)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:78)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
** END NESTED EXCEPTION **
```
1.
`CREATE DATABASE sharding_db;`
2.
```
ADD RESOURCE resource_0 (
HOST=127.0.0.1,
PORT=3306,
DB=ds0,
USER=root,
PASSWORD=123456
),resource_1 (
HOST=127.0.0.1,
PORT=3306,
DB=ds1,
USER=root,
PASSWORD=123456
);
```
`server.yaml : `
```
mode:
type: Cluster
repository:
type: ZooKeeper
props:
namespace: governance_ds
server-lists: localhost:2181
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
overwrite: false
rules:
- !AUTHORITY
users:
- root@%:root
- sharding@:sharding
provider:
type: ALL_PERMITTED
```
--
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] zjcnb commented on issue #18792: javax.net.ssl.SSLException occurred when add resource by `DistSQL`
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #18792:
URL: https://github.com/apache/shardingsphere/issues/18792#issuecomment-1190387669
I can't reproduce it, so i close it.
--
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 closed issue #18792: javax.net.ssl.SSLException occurred when add resource by `DistSQL`
Posted by GitBox <gi...@apache.org>.
zjcnb closed issue #18792: javax.net.ssl.SSLException occurred when add resource by `DistSQL`
URL: https://github.com/apache/shardingsphere/issues/18792
--
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