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/12/21 09:19:38 UTC

[GitHub] [shardingsphere] xue2lang opened a new issue #8703: use ShardingSphere-Proxy occur "ERROR 2006 (HY000): MySQL server has gone away"

xue2lang opened a new issue #8703:
URL: https://github.com/apache/shardingsphere/issues/8703


   ## Question
   
   **For English only**, other languages will not accept.
   
   Before asking a question, make sure you have:
   
   - Googled your question.
   - 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**.
   
   ShardingSphere version:4.1.1 (i see proxy use mysql connector is 5.1.47)
   
   Expected behavior
   execute right 
   
   Actual behavior
   ERROR 2006 (HY000): MySQL server has gone away
   No connection. Trying to reconnect...
   Connection id:    61
   
   Reason analyze (If you can)
   i cannot find any reason 
   
   Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   tools:mysql official client (version 5.7.30-log)
   step:
     1.do not use proxy :direct connect db is ok ,then execute sql is ok;
     2.use proxy  : can connect a few seconds  , then execute sql will return  "ERROR 2006 (HY000): MySQL server has gone away" (sql eg:show tables)
   


----------------------------------------------------------------
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] jingshanglu commented on issue #8703: use ShardingSphere-Proxy occur "ERROR 2006 (HY000): MySQL server has gone away"

Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #8703:
URL: https://github.com/apache/shardingsphere/issues/8703#issuecomment-749319908


   @xue2lang  It has been fixed on master branch by #8610, new version will be ok, you can use the master branch.


----------------------------------------------------------------
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] xue2lang commented on issue #8703: use ShardingSphere-Proxy occur "ERROR 2006 (HY000): MySQL server has gone away"

Posted by GitBox <gi...@apache.org>.
xue2lang commented on issue #8703:
URL: https://github.com/apache/shardingsphere/issues/8703#issuecomment-749436777


   > > 3Q,i will review the code and merge it to our branch of 4.1.1
   > 
   > Hi, That's not an easy one. If it is needed, running master branch is another option for you. :)
   
   you are right ,i have saw the master code ,shardingshpere 5.x too much changed for 4.1.x ,i have given up my idea  💔


----------------------------------------------------------------
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] tristaZero closed issue #8703: use ShardingSphere-Proxy occur "ERROR 2006 (HY000): MySQL server has gone away"

Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #8703:
URL: https://github.com/apache/shardingsphere/issues/8703


   


----------------------------------------------------------------
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] xue2lang commented on issue #8703: use ShardingSphere-Proxy occur "ERROR 2006 (HY000): MySQL server has gone away"

Posted by GitBox <gi...@apache.org>.
xue2lang commented on issue #8703:
URL: https://github.com/apache/shardingsphere/issues/8703#issuecomment-749401447


   > @xue2lang It has been fixed on master branch by #8610, new version will be ok, you can use the master branch.
   
   3Q,i will review the code and merge it to our branch of 4.1.1 


----------------------------------------------------------------
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] tristaZero commented on issue #8703: use ShardingSphere-Proxy occur "ERROR 2006 (HY000): MySQL server has gone away"

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #8703:
URL: https://github.com/apache/shardingsphere/issues/8703#issuecomment-749431771


   > 3Q,i will review the code and merge it to our branch of 4.1.1
   
   Hi, That's not an easy one. If it is needed, running master branch is another option for you. :)
   


----------------------------------------------------------------
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] yu199195 commented on issue #8703: use ShardingSphere-Proxy occur "ERROR 2006 (HY000): MySQL server has gone away"

Posted by GitBox <gi...@apache.org>.
yu199195 commented on issue #8703:
URL: https://github.com/apache/shardingsphere/issues/8703#issuecomment-748895231


   @tristaZero  Can you take a look at 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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] z-n commented on issue #8703: use ShardingSphere-Proxy occur "ERROR 2006 (HY000): MySQL server has gone away"

Posted by GitBox <gi...@apache.org>.
z-n commented on issue #8703:
URL: https://github.com/apache/shardingsphere/issues/8703#issuecomment-762680117


   Isn't this a basic requirement? show me what's wrong ok? the server is just gone ,no logs no errors


----------------------------------------------------------------
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] xue2lang commented on issue #8703: use ShardingSphere-Proxy occur "ERROR 2006 (HY000): MySQL server has gone away"

Posted by GitBox <gi...@apache.org>.
xue2lang commented on issue #8703:
URL: https://github.com/apache/shardingsphere/issues/8703#issuecomment-748885429


   > Issue must be follow the template!
   
   now use template


----------------------------------------------------------------
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] yu199195 commented on issue #8703: use ShardingSphere-Proxy occur "ERROR 2006 (HY000): MySQL server has gone away"

Posted by GitBox <gi...@apache.org>.
yu199195 commented on issue #8703:
URL: https://github.com/apache/shardingsphere/issues/8703#issuecomment-748882358


   Issue must be follow the template! 


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