[GitHub] [shardingsphere] ben905713861 opened a new issue #8978: SeataAT transaction in ShardingSphere-Proxy block abnormally

Mon, 11 Jan 2021 00:19:17 -0800 


ben905713861 opened a new issue #8978:
URL: https://github.com/apache/shardingsphere/issues/8978


   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   4.1.1
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   When I use Seata-AT transaction in ShardingSphere-Proxy,I have start 
transaction and send a `select for update` SQL,the ShardingSphere-Proxy is 
blocking forever.
   （使用Seata-AT事务，执行select for update语句会永久阻塞）
   
   ```sql
   BEGIN;
   SELECT * FROM user WHERE id=1 FOR UPDATE;
   ```
   After sending this SQL,ShardingSphere-Proxy is blocking.
   In this test, I use wireshark to analysis, I can see the SQL send to 
ShardingSphere-Proxy and MySQL-Server successfuly, and  MySQL-Server echo the 
result successfuly.
   （抓包分析，mysql服务收到了分片语句并成功返回）
   
![image](https://user-images.githubusercontent.com/37857367/104157987-5a471e00-5427-11eb-90b3-78171f31f4b5.png)
   
   
   ### Another behavior
   Using `insert`, `update` or `delete` SQL is successful, only the `select for 
update` is failed (Blocking forever)
   （使用增删改是正常的，只有select for update语句是永久阻塞）


----------------------------------------------------------------
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:
[email protected]

Reply via email to