You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@seata.apache.org by "iAmClever (via GitHub)" <gi...@apache.org> on 2024/08/22 09:13:48 UTC

Re: [I] TCC模式下，开启它的useTCCFence功能，mysql事务隔离级别是RR，如果prepare阶段发生悬挂 && rollback阶段也发生悬挂，会出现异常【Deadlock found when trying to get lock; try restarting transaction】 [incubator-seata]

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-unsubscribe@seata.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org