iAmClever commented on issue #6679: URL: https://github.com/apache/incubator-seata/issues/6679#issuecomment-2304172369
**将隔离级别调成RR:** ![image](https://github.com/user-attachments/assets/fce013f1-2faa-4ca9-9aca-5139aec7b790) 执行第一条rollback线程 到select ... for update 这一行: ![image](https://github.com/user-attachments/assets/7679983f-7aa9-467a-b8e5-b17eeaf1fb85) 此时mysql的锁记录信息如下: ![image](https://github.com/user-attachments/assets/04d95f54-7957-4613-a69d-a795f0001bfe) 执行第二条rollback线程 到select ... for update 这一行: ![image](https://github.com/user-attachments/assets/09c3b978-1948-411b-b012-1246ee18ccca) 此时mysql的锁记录信息如下: ![image](https://github.com/user-attachments/assets/7256166f-9037-448d-8a81-c34a7c077618) 执行结果,会卡住超时后报死锁异常: ![image](https://github.com/user-attachments/assets/b3c0c587-5ef4-4631-861a-30124a0f9e19) **将隔离级别调成RC:** ![image](https://github.com/user-attachments/assets/4b7be957-75d3-478a-8798-7da0862c7320) 执行第一条rollback线程 到select ... for update 这一行: ![image](https://github.com/user-attachments/assets/cf502b7e-44b8-4e26-aa5b-38f2fd1c033c) 此时mysql的锁记录信息如下: ![image](https://github.com/user-attachments/assets/1ab7a51b-0b49-4b93-b468-7bd0e071bffb) 执行第二条rollback线程 到select ... for update 这一行: ![image](https://github.com/user-attachments/assets/9e19c1cb-b161-41c7-8273-b9046a627f86) 此时mysql的锁记录信息如下: ![image](https://github.com/user-attachments/assets/e9faa6d9-ad50-464d-8772-ff94beec1a2b) 执行结果,报主键冲突: ![image](https://github.com/user-attachments/assets/b108ceb8-9018-48bd-b4fb-5958649abe2f) -- 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-unsubscr...@seata.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@seata.apache.org For additional commands, e-mail: notifications-h...@seata.apache.org