Hello Team,
We've encountered a critical error in our Magento instance that requires your assistance.
Error Details:
Error Type: Database Transaction Failure
Error Message: The transaction processing orders failed due to issues with database transactions.
Steps to Reproduce: This error occurs during order placement, causing transactions to fail and orders not to be processed successfully.
Error Context: The following error message ("A server error stopped your order from being placed. Please try to place your order again.") appears when attempting to place an order via the Magento platform. We have attempted debugging this issue but have not had any success. From our examination of the database logs, it seems that before the code attempts to insert data into the sales_order_item table, the entry in the sales_order table, which serves as a foreign key in the sales_order_item table, is being rolled back, resulting in an Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails error.
sharing the exact log below. Please check and try to help us. Magento version 2.4.3-p1
0. /var/www/html/ekart-app/generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php(23): Magento\Framework\DB\Adapter\Pdo\Mysql->beginTransaction()
1. /var/www/html/ekart-app/vendor/magento/framework/Model/ResourceModel/AbstractResource.php(67): Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->beginTransaction()
2. /var/www/html/ekart-app/vendor/magento/framework/Model/ResourceModel/Db/AbstractDb.php(402): Magento\Framework\Model\ResourceModel\AbstractResource->beginTransaction()
3. /var/www/html/ekart-app/vendor/magento/framework/Model/AbstractModel.php(655): Magento\Framework\Model\ResourceModel\Db\AbstractDb->save()
4. /var/www/html/ekart-app/vendor/yotpo/magento2-module-yotpo-reviews/Observer/OrderSaveAfter.php(49): Magento\Framework\Model\AbstractModel->save()
5. /var/www/html/ekart-app/vendor/magento/framework/Event/Invoker/InvokerDefault.php(88): Yotpo\Yotpo\Observer\OrderSaveAfter->execute()
6. /var/www/html/ekart-app/vendor/magento/framework/Event/Manager.php(66): Magento\Framework\Event\Invoker\InvokerDefault->dispatch()
7. /var/www/html/ekart-app/generated/code/Magento/Framework/Event/Manager/Proxy.php(95): Magento\Framework\Event\Manager->dispatch()
8. /var/www/html/ekart-app/vendor/magento/framework/Model/AbstractModel.php(829): Magento\Framework\Event\Manager\Proxy->dispatch()
9. /var/www/html/ekart-app/generated/code/Magento/Sales/Model/Order/Interceptor.php(3551): Magento\Framework\Model\AbstractModel->afterSave()
10. /var/www/html/ekart-app/vendor/magento/framework/Model/ResourceModel/Db/VersionControl/AbstractDb.php(56): Magento\Sales\Model\Order\Interceptor->afterSave()
11. /var/www/html/ekart-app/vendor/magento/framework/Model/ResourceModel/Db/AbstractDb.php(424): Magento\Framework\Model\ResourceModel\Db\VersionControl\AbstractDb->processAfterSaves()
12. /var/www/html/ekart-app/vendor/magento/module-sales/Model/ResourceModel/Order.php(180): Magento\Framework\Model\ResourceModel\Db\AbstractDb->save()
13. /var/www/html/ekart-app/generated/code/Magento/Sales/Model/ResourceModel/Order/Interceptor.php(32): Magento\Sales\Model\ResourceModel\Order->save()
14. /var/www/html/ekart-app/vendor/magento/framework/Model/AbstractModel.php(655): Magento\Sales\Model\ResourceModel\Order\Interceptor->save()
15. /var/www/html/ekart-app/generated/code/Magento/Sales/Model/Order/Interceptor.php(3488): Magento\Framework\Model\AbstractModel->save()
16. /var/www/html/ekart-app/app/code/Bss/CustomerAttributes/Observer/CustomerAttrSave.php(115): Magento\Sales\Model\Order\Interceptor->save()
17. /var/www/html/ekart-app/vendor/magento/framework/Event/Invoker/InvokerDefault.php(88): Bss\CustomerAttributes\Observer\CustomerAttrSave->execute()
18. /var/www/html/ekart-app/vendor/magento/framework/Event/Manager.php(66): Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod()
19. /var/www/html/ekart-app/vendor/magento/framework/Event/Invoker/InvokerDefault.php(74): Magento\Framework\Event\Manager->dispatch()
20. /var/www/html/ekart-app/vendor/magento/framework/Event/Manager.php(66): Magento\Framework\Event\Invoker\InvokerDefault->dispatch()
21. /var/www/html/ekart-app/generated/code/Magento/Framework/Event/Manager/Proxy.php(95): Magento\Framework\Event\Manager->dispatch()
22. /var/www/html/ekart-app/vendor/magento/module-sales/Model/Order.php(1215): Magento\Framework\Event\Manager\Proxy->dispatch()
23. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Sales\Model\Order->place()
24. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Sales\Model\Order\Interceptor->___callParent()
25. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Sales\Model\Order\Interceptor->Magento\Framework\Interception\{closure}()
26. /var/www/html/ekart-app/generated/code/Magento/Sales/Model/Order/Interceptor.php(356): Magento\Sales\Model\Order\Interceptor->___callPlugins()
27. /var/www/html/ekart-app/vendor/magento/module-sales/Model/Service/OrderService.php(209): Magento\Sales\Model\Order\Interceptor->place()
28. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Sales\Model\Service\OrderService->place()
29. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Sales\Model\Service\OrderService\Interceptor->___callParent()
30. /var/www/html/ekart-app/vendor/magento/module-inventory-sales/Plugin/Sales/OrderManagement/AppendReservationsAfterOrderPlacementPlugin.php(195): Magento\Sales\Model\Service\OrderService\Interceptor->Magento\Framework\Interception\{closure}()
31. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(135): Magento\InventorySales\Plugin\Sales\OrderManagement\AppendReservationsAfterOrderPlacementPlugin->aroundPlace()
32. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Sales\Model\Service\OrderService\Interceptor->Magento\Framework\Interception\{closure}()
33. /var/www/html/ekart-app/generated/code/Magento/Sales/Model/Service/OrderService/Interceptor.php(86): Magento\Sales\Model\Service\OrderService\Interceptor->___callPlugins()
34. /var/www/html/ekart-app/vendor/magento/module-quote/Model/QuoteManagement.php(575): Magento\Sales\Model\Service\OrderService\Interceptor->place()
35. /var/www/html/ekart-app/vendor/magento/module-quote/Model/QuoteManagement.php(456): Magento\Quote\Model\QuoteManagement->submitQuote()
36. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Quote\Model\QuoteManagement->submit()
37. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Quote\Model\QuoteManagement\Interceptor->___callParent()
38. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Quote\Model\QuoteManagement\Interceptor->Magento\Framework\Interception\{closure}()
39. /var/www/html/ekart-app/generated/code/Magento/Quote/Model/QuoteManagement/Interceptor.php(68): Magento\Quote\Model\QuoteManagement\Interceptor->___callPlugins()
40. /var/www/html/ekart-app/vendor/magento/module-quote/Model/QuoteManagement.php(414): Magento\Quote\Model\QuoteManagement\Interceptor->submit()
41. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Quote\Model\QuoteManagement->placeOrder()
42. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Quote\Model\QuoteManagement\Interceptor->___callParent()
43. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Quote\Model\QuoteManagement\Interceptor->Magento\Framework\Interception\{closure}()
44. /var/www/html/ekart-app/generated/code/Magento/Quote/Model/QuoteManagement/Interceptor.php(50): Magento\Quote\Model\QuoteManagement\Interceptor->___callPlugins()
45. /var/www/html/ekart-app/vendor/magento/module-checkout/Model/PaymentInformationManagement.php(125): Magento\Quote\Model\QuoteManagement\Interceptor->placeOrder()
46. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Checkout\Model\PaymentInformationManagement->savePaymentInformationAndPlaceOrder()
47. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Checkout\Model\PaymentInformationManagement\Interceptor->___callParent()
48. /var/www/html/ekart-app/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Checkout\Model\PaymentInformationManagement\Interceptor->Magento\Framework\Interception\{closure}()
49. /var/www/html/ekart-app/generated/code/Magento/Checkout/Model/PaymentInformationManagement/Interceptor.php(23): Magento\Checkout\Model\PaymentInformationManagement\Interceptor->___callPlugins()
50. [internal function]: Magento\Checkout\Model\PaymentInformationManagement\Interceptor->savePaymentInformationAndPlaceOrder()
51. /var/www/html/ekart-app/vendor/magento/module-webapi/Controller/Rest/Sync:
