funky-eyes commented on PR #8007: URL: https://github.com/apache/incubator-seata/pull/8007#issuecomment-4064574710
The two transactions committed successfully because they were committed at different times, so the "First-Committer-Wins" mechanism doesn't provide any help in this scenario. As for the snapshot you mentioned, due to the absence of row locks or table locks, the "select for update" operation, which is supposed to acquire the row count before executing DML statements to ensure the accuracy of the before image, fails to work. Without an accurate before image, it's impossible to guarantee the accuracy of the rollback data when the two-phase decision results in a rollback. The prerequisite for creating an accurate before image in Seata AT is a current read, not a snapshot read. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
