Deadlock Error in Magento 2 During High Concurrency: Serialization failure on cataloginventory_stock_item Table

[talsan74]

Preconditions (*)

1. Magento: 2.4.7
2. PHP: 8.3
3. RDS MYSQL: 8.0 16GB Memory

Steps to reproduce (*)

1. Install Default Magento
2. Cron for every 1 minitue
3. Added 10k products
4. Run Stress Test for 100 users using JMeter
5. Trying to place order using graphql

Expected result (*)

1. 100% will be placed

Actual result (*)

Out of 100 orders, a single-digit order is regularly missing. Resource metrics are fine. This issue only occurs during the stress test, not during manual execution. The logs are being retrieved in Magento.

main.ERROR: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: SELECT `si`.* FROM `cataloginventory_stock_item` AS `si` WHERE (item_id IN (4475, 4522, 4679, 8444, 8745)) FOR UPDATE

GraphQL (3:7)
    mutation {
       placeOrder(input: { cart_id: "Zsasfghssdfgghfghghjgs" }) {
         ^
       order {
 {"exception":"[object] (GraphQL\\Error\\Error(code: 0): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: SELECT `si`.* FROM `cataloginventory_stock_item` AS `si` WHERE (item_id IN (4475, 4522, 4679, 8444, 8745)) FOR UPDATE at /var/www/html/vendor/webonyx/graphql-php/src/Error/Error.php:170)
[previous exception] [object] (Magento\\Framework\\DB\\Adapter\\DeadlockException(code: 1213): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: SELECT `si`.* FROM `cataloginventory_stock_item` AS `si` WHERE (item_id IN (4475, 4522, 4679, 8444, 8745)) FOR UPDATE at /var/www/html/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php:672)
[previous exception] [object] (Zend_Db_Statement_Exception(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: SELECT `si`.* FROM `cataloginventory_stock_item` AS `si` WHERE (item_id IN (4475, 4522, 4679, 8444, 8745)) FOR UPDATE at /var/www/html/lib/internal/Magento/Framework/DB/Statement/Pdo/Mysql.php:109)
[previous exception] [object] (PDOException(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/lib/internal/Magento/Framework/DB/Statement/Pdo/Mysql.php:90)"} []

[m2-assistant[bot]]

Hi @talsan74. Thank you for your report. To speed up processing of this issue, make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce.

• For more details, review the Magento Contributor Assistant documentation.
• Add a comment to assign the issue: @magento I am working on this

• To learn more about issue processing workflow, refer to the Code Contributions.

  Join Magento Community Engineering Slack and ask your questions in #github channel. :warning: According to the Magento Contribution requirements, all issues must go through the Community Contributions Triage process. Community Contributions Triage is a public meeting. :clock10: You can find the schedule on the Magento Community Calendar page. :telephone_receiver: The triage of issues happens in the queue order. If you want to speed up the delivery of your contribution, join the Community Contributions Triage session to discuss the appropriate ticket.