clayboby opened a new issue, #6861:
URL: https://github.com/apache/shardingsphere/issues/6861

   ## Bug Report
   
   **For Chinese Or 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?
   4.1.1
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-proxy
   ### Expected behavior
   first and second connection opened successfully
   ### Actual behavior
   When I User MySqlConnector(.net standart2.0) instead of Mysql.Data(From 
oracle)  and try to conect to proxy at second time. It happened as below.(first 
try was success, close and open again will throw the error)
   I can only use MySqlConnector beacuse of Pomelo.Entityframework.Code,and it 
excute sql in real async mode(oracle's always in sync mode).
   I check the source code, and find the error stacktrace was in 
ServerSession.cs 507th line.
   ### Reason analyze (If you can)
   It work well when I use mysql 8.0.20 directly. I suppose that the proxy does 
not support this command. which use in MySqlConnector SDK to get better 
performance
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule 
configuration, when exception occur etc.
   VS2019
   Create a Cosole project
   Install MySqlConnector Nuget package
   Create a Mysqlconnection. open once and close. then open again, you will get 
this error
   ### Example codes for reproduce this issue (such as a github link).
   
![image](https://user-images.githubusercontent.com/69718954/90312251-7b1d4d00-df35-11ea-88e9-96b534a6520f.png)
   https://github.com/mysql-net/MySqlConnector ServerSession.cs 507 whent it 
try TryResetConnectionAsync
   
![image](https://user-images.githubusercontent.com/69718954/90312466-4dd19e80-df37-11ea-998a-b0fa45ffc3d9.png)
   
![image](https://user-images.githubusercontent.com/69718954/90312502-8c675900-df37-11ea-8d6d-fd9d4ab36f14.png)
   
   
   Please, .net also need your help
   


-- 
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]

Reply via email to