[GitHub] [shardingsphere] maketubo opened a new issue #16146: two update after 3ms interval confilct

[GitBox <gi...@apache.org>]

maketubo opened a new issue #16146:
URL: https://github.com/apache/shardingsphere/issues/16146


   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   5.1.0
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-JDBC
   ### Expected behavior
   1. execute A update ： update table0 set status = "Running" where id = 1;
   2. after 3ms
   3. execute B update ： update table0 set status = "Success" where id = 1;
   4. query table0 where id = 1; we expect that the status of query result is Success
   
   ### Actual behavior
   but actually the status of query result is Running;
   我们做了个实验，在100多次A & B调用中，会有10-30个的结果是Running；
   不使用ShardingSphere-JDBC时，这100多次调用都不会出现这样的情况。
   请问如何避免这个问题呢，谢谢🙏
   
   ### Reason analyze (If you can)
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ### Example codes for reproduce this issue (such as a github link).
   


-- 
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] terrymanu commented on issue #16146: two update after 3ms interval confilct

[GitBox <gi...@apache.org>]

terrymanu commented on issue #16146:
URL: https://github.com/apache/shardingsphere/issues/16146#issuecomment-1073289231


   I just set the issue as `invalid` because of the author close it without any reason.


-- 
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] maketubo closed issue #16146: two update after 3ms interval confilct

[GitBox <gi...@apache.org>]

maketubo closed issue #16146:
URL: https://github.com/apache/shardingsphere/issues/16146


   


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