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 2020/08/15 12:42:03 UTC
[GitHub] [shardingsphere] clayboby opened a new issue #6861: .net core conection problem to SHARDINGSPHERE-PROXY when using MySqlConnector
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 above.(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).
https://github.com/mysql-net/MySqlConnector ServerSession.cs 507 whent it try TryResetConnectionAsync
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking closed issue #6861: .net core conection problem to SHARDINGSPHERE-PROXY when using MySqlConnector "1Unsupported command: [COM_RESET_CONNECTION]"
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #6861:
URL: https://github.com/apache/shardingsphere/issues/6861
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuohai666 commented on issue #6861: .net core conection problem to SHARDINGSPHERE-PROXY when using MySqlConnector "1Unsupported command: [COM_RESET_CONNECTION]"
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #6861:
URL: https://github.com/apache/shardingsphere/issues/6861#issuecomment-682390045
@clayboby Can you use wireshark to capture the process?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking commented on issue #6861: .net core conection problem to SHARDINGSPHERE-PROXY when using MySqlConnector "1Unsupported command: [COM_RESET_CONNECTION]"
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6861:
URL: https://github.com/apache/shardingsphere/issues/6861#issuecomment-679533009
@clayboby
Does the test case work well when directly connect to mysql?
> Create a Mysqlconnection. open once and close. then open again, you will get this error
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] clayboby commented on issue #6861: .net core conection problem to SHARDINGSPHERE-PROXY when using MySqlConnector "1Unsupported command: [COM_RESET_CONNECTION]"
Posted by GitBox <gi...@apache.org>.
clayboby commented on issue #6861:
URL: https://github.com/apache/shardingsphere/issues/6861#issuecomment-681872684
@kimmking<ma...@github.com>
Yes. It work well with mysql 8.0.20
发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用
发件人: kimmking<ma...@github.com>
发送时间: 2020年8月25日 11:41
收件人: apache/shardingsphere<ma...@noreply.github.com>
抄送: clayboby<ma...@outlook.com>; Mention<ma...@noreply.github.com>
主题: Re: [apache/shardingsphere] .net core conection problem to SHARDINGSPHERE-PROXY when using MySqlConnector "1Unsupported command: [COM_RESET_CONNECTION]" (#6861)
@clayboby<https://github.com/clayboby>
Does the test case work well when directly connect to mysql?
Create a Mysqlconnection. open once and close. then open again, you will get this error
―
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<https://github.com/apache/shardingsphere/issues/6861#issuecomment-679533009>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AQT5HKSLYKVY4VMFIKHZSK3SCMXFVANCNFSM4QAIHB6A>.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking closed issue #6861: .net core conection problem to SHARDINGSPHERE-PROXY when using MySqlConnector "1Unsupported command: [COM_RESET_CONNECTION]"
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #6861:
URL: https://github.com/apache/shardingsphere/issues/6861
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking edited a comment on issue #6861: .net core conection problem to SHARDINGSPHERE-PROXY when using MySqlConnector "1Unsupported command: [COM_RESET_CONNECTION]"
Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #6861:
URL: https://github.com/apache/shardingsphere/issues/6861#issuecomment-679533009
@clayboby
Does the test case work well when directly connect to mysql?
> Create a Mysqlconnection. open once and close. then open again, you will get this error
IMO, 'COM_RESET_CONNECTION' doesnt close connection but your case it closed first.
Refer:
1.https://dev.mysql.com/doc/dev/mysql-server/8.0.11/page_protocol_com_reset_connection.html
2.https://dev.mysql.com/doc/dev/mysql-server/8.0.11/page_protocol_com_change_user.html
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org