jmbkeyes edited a comment on issue #9447: URL: https://github.com/apache/shardingsphere/issues/9447#issuecomment-785619944
Thanks, @yu199195 About the deadlock, I add sharding column in sql, it's ok now, but not know why? And I have another issue, use shardingsphere-jdbc with seata, some records are not rollback occasionally if exception are thrown. I have written a demo spring boot app(https://github.com/jmbkeyes/shardingsphere-jdbc-seata-demo), attached the 3 test databases in \db\test_db_with_data.sql, and sharding-proxy config files in shardingproxy-config. You can reproduce the issue via the following steps. 1. download the source, and open the projcect via idea 2. change db connection info in application.yml, and set the seata related configurations, change db connection info in shardingproxy config files. 3. run the spring boot app 4. access the test api http://{ip}:9090/api/test/2?rollback=true (the api just sets records' centerId=-centerId, and then raises an exception in order to rollback updates) #repeatly do this step lots of times. 5. check the changed data select * from trainee_checkin_checkout where centerId<0 via sharding-proxy, rollback failed if records are returned. ---------------------------------------------------------------- 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: us...@infra.apache.org
