PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock

[gerben86]

Plugin version

4.11.0

Magento version

2.4.5p1

PHP version

8.1

What went wrong?

Deadlock when trying to ship an order

Reproduction steps

1. Select multiple orders to ship
2. Choose 'print shipping labels' from the dropdown
3. Then it takes ages before the system responds.
   Check the error in the database related to 'CreateAndPrintMyParcelTrack\Interceptor->dispatch()'

Relevant log output

[2024-01-13T15:18:44.234840+00:00] main.CRITICAL: PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /vendor/magento/framework/DB/Statement/Pdo/Mysql.php:90
Stack trace:
#0 /vendor/magento/framework/DB/Statement/Pdo/Mysql.php(90): PDOStatement->execute()
#1 /vendor/magento/framework/DB/Statement/Pdo/Mysql.php(106): Magento\Framework\DB\Statement\Pdo\Mysql->Magento\Framework\DB\Statement\Pdo\{closure}()
#2 /vendor/magento/framework/DB/Statement/Pdo/Mysql.php(91): Magento\Framework\DB\Statement\Pdo\Mysql->tryExecute()
#3 /vendor/magento/zendframework1/library/Zend/Db/Statement.php(313): Magento\Framework\DB\Statement\Pdo\Mysql->_execute()
#4 /vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
#5 /vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query()
#6 /vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(564): Zend_Db_Adapter_Pdo_Abstract->query()
#7 /vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(634): Magento\Framework\DB\Adapter\Pdo\Mysql->_query()
#8 /vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(635): Magento\Framework\DB\Adapter\Pdo\Mysql->query()
#9 /vendor/magento/module-sales/Model/ResourceModel/EntityAbstract.php(179): Zend_Db_Adapter_Abstract->update()
#10 /vendor/magento/framework/Model/ResourceModel/Db/AbstractDb.php(397): Magento\Sales\Model\ResourceModel\EntityAbstract->updateObject()
#11 /vendor/magento/module-sales/Model/Order/ItemRepository.php(173): Magento\Framework\Model\ResourceModel\Db\AbstractDb->save()
#12 /vendor/magento/module-sales/Model/ResourceModel/Order/Relation.php(74): Magento\Sales\Model\Order\ItemRepository->save()
#13 /vendor/magento/framework/Model/ResourceModel/Db/VersionControl/RelationComposite.php(48): Magento\Sales\Model\ResourceModel\Order\Relation->processRelation()
#14 /vendor/magento/framework/Model/ResourceModel/Db/VersionControl/AbstractDb.php(57): Magento\Framework\Model\ResourceModel\Db\VersionControl\RelationComposite->processRelations()
#15 /vendor/magento/framework/Model/ResourceModel/Db/AbstractDb.php(402): Magento\Framework\Model\ResourceModel\Db\VersionControl\AbstractDb->processAfterSaves()
#16 /vendor/magento/module-sales/Model/ResourceModel/Order.php(180): Magento\Framework\Model\ResourceModel\Db\AbstractDb->save()
#17 /vendor/myparcelnl/magento/Model/Sales/MagentoOrderCollection.php(623): Magento\Sales\Model\ResourceModel\Order->save()
#18 /vendor/myparcelnl/magento/Model/Sales/MagentoOrderCollection.php(115): MyParcelNL\Magento\Model\Sales\MagentoOrderCollection->createMagentoShipment()
#19 /vendor/myparcelnl/magento/Controller/Adminhtml/Order/CreateAndPrintMyParcelTrack.php(125): MyParcelNL\Magento\Model\Sales\MagentoOrderCollection->setNewMagentoShipment()
#20 /vendor/myparcelnl/magento/Controller/Adminhtml/Order/CreateAndPrintMyParcelTrack.php(76): MyParcelNL\Magento\Controller\Adminhtml\Order\CreateAndPrintMyParcelTrack->massAction()
#21 /vendor/magento/framework/Interception/Interceptor.php(58): MyParcelNL\Magento\Controller\Adminhtml\Order\CreateAndPrintMyParcelTrack->execute()
#22 /vendor/magento/framework/Interception/Interceptor.php(138): MyParcelNL\Magento\Controller\Adminhtml\Order\CreateAndPrintMyParcelTrack\Interceptor->___callParent()
#23 /vendor/magento/framework/Interception/Interceptor.php(153): MyParcelNL\Magento\Controller\Adminhtml\Order\CreateAndPrintMyParcelTrack\Interceptor->Magento\Framework\Interception\{closure}()
#24 /generated/code/MyParcelNL/Magento/Controller/Adminhtml/Order/CreateAndPrintMyParcelTrack/Interceptor.php(23): MyParcelNL\Magento\Controller\Adminhtml\Order\CreateAndPrintMyParcelTrack\Interceptor->___callPlugins()
#25 /vendor/magento/framework/App/Action/Action.php(111): MyParcelNL\Magento\Controller\Adminhtml\Order\CreateAndPrintMyParcelTrack\Interceptor->execute()
#26 /vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\App\Action\Action->dispatch()
#27 /vendor/magento/framework/Interception/Interceptor.php(138): MyParcelNL\Magento\Controller\Adminhtml\Order\CreateAndPrintMyParcelTrack\Interceptor->___callParent()
#28 /vendor/magento/framework/Interception/Interceptor.php(153): MyParcelNL\Magento\Controller\Adminhtml\Order\CreateAndPrintMyParcelTrack\Interceptor->Magento\Framework\Interception\{closure}()
#29 /generated/code/MyParcelNL/Magento/Controller/Adminhtml/Order/CreateAndPrintMyParcelTrack/Interceptor.php(32): MyParcelNL\Magento\Controller\Adminhtml\Order\CreateAndPrintMyParcelTrack\Interceptor->___callPlugins()
#30 /vendor/magento/framework/App/FrontController.php(245): MyParcelNL\Magento\Controller\Adminhtml\Order\CreateAndPrintMyParcelTrack\Interceptor->dispatch()
#31 /vendor/magento/framework/App/FrontController.php(212): Magento\Framework\App\FrontController->getActionResponse()
#32 /vendor/magento/framework/App/FrontController.php(147): Magento\Framework\App\FrontController->processRequest()
#33 /vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\App\FrontController->dispatch()
#34 /vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\App\FrontController\Interceptor->___callParent()
#35 /vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}()
#36 /generated/code/Magento/Framework/App/FrontController/Interceptor.php(23): Magento\Framework\App\FrontController\Interceptor->___callPlugins()
#37 /vendor/magento/framework/App/Http.php(116): Magento\Framework\App\FrontController\Interceptor->dispatch()
#38 /vendor/magento/framework/App/Bootstrap.php(264): Magento\Framework\App\Http->launch()
#39 /pub/index.php(65): Magento\Framework\App\Bootstrap->run()
#40 {main}

Additional context

No response