Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 Stack trace: #0 /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL) #1 /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1527): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1487): Doctrine\DBAL\Connection->executeStatement('UPDATE s_articl...', Array, Array) #3 /var/www/custom/project/TspoShowSoldOutProducts/Controllers/Frontend/Custom404Detail.php(128): Doctrine\DBAL\Connection->executeUpdate('UPDATE s_articl...', Array) #4 /var/www/custom/project/TspoShowSoldOutProducts/Controllers/Frontend/Custom404Detail.php(40): Shopware_Controllers_Frontend_Custom404Detail->setSoldOutDate(Array) #5 /var/www/vendor/shopware/shopware/engine/Library/Enlight/Controller/Action.php(188): Shopware_Controllers_Frontend_Custom404Detail->indexAction() #6 /var/www/vendor/shopware/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight_Controller_Action->dispatch('indexAction') #7 /var/www/vendor/shopware/shopware/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #8 /var/www/vendor/shopware/shopware/engine/Shopware/Kernel.php(195): Enlight_Controller_Front->dispatch() #9 /var/www/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #10 /var/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(AppKernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #11 /var/www/vendor/shopware/shopware/engine/Shopware/Components/HttpCache/AppCache.php(270): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #12 /var/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #13 /var/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #14 /var/www/vendor/shopware/shopware/engine/Shopware/Components/HttpCache/AppCache.php(196): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #15 /var/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #16 /var/www/vendor/shopware/shopware/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #17 /var/www/shopware.php(20): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #18 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: #0 /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException)) #1 /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1527): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1487): Doctrine\DBAL\Connection->executeStatement('UPDATE s_articl...', Array, Array) #3 /var/www/custom/project/TspoShowSoldOutProducts/Controllers/Frontend/Custom404Detail.php(128): Doctrine\DBAL\Connection->executeUpdate('UPDATE s_articl...', Array) #4 /var/www/custom/project/TspoShowSoldOutProducts/Controllers/Frontend/Custom404Detail.php(40): Shopware_Controllers_Frontend_Custom404Detail->setSoldOutDate(Array) #5 /var/www/vendor/shopware/shopware/engine/Library/Enlight/Controller/Action.php(188): Shopware_Controllers_Frontend_Custom404Detail->indexAction() #6 /var/www/vendor/shopware/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight_Controller_Action->dispatch('indexAction') #7 /var/www/vendor/shopware/shopware/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #8 /var/www/vendor/shopware/shopware/engine/Shopware/Kernel.php(195): Enlight_Controller_Front->dispatch() #9 /var/www/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #10 /var/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(AppKernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #11 /var/www/vendor/shopware/shopware/engine/Shopware/Components/HttpCache/AppCache.php(270): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #12 /var/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #13 /var/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #14 /var/www/vendor/shopware/shopware/engine/Shopware/Components/HttpCache/AppCache.php(196): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #15 /var/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #16 /var/www/vendor/shopware/shopware/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #17 /var/www/shopware.php(20): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #18 {main} Next Doctrine\DBAL\Exception\DeadlockException: An exception occurred while executing 'UPDATE s_articles_attributes aa JOIN s_articles_details ad ON aa.articledetailsID = ad.id SET sold_out_since = ? WHERE ad.articleID = ?' with params ["2024-04-26", "3501"]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:51 Stack trace: #0 /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDO\Exception)) #1 /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), 'An exception oc...') #2 /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), 'UPDATE s_articl...', Array) #3 /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1538): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'UPDATE s_articl...', Array, Array) #4 /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1487): Doctrine\DBAL\Connection->executeStatement('UPDATE s_articl...', Array, Array) #5 /var/www/custom/project/TspoShowSoldOutProducts/Controllers/Frontend/Custom404Detail.php(128): Doctrine\DBAL\Connection->executeUpdate('UPDATE s_articl...', Array) #6 /var/www/custom/project/TspoShowSoldOutProducts/Controllers/Frontend/Custom404Detail.php(40): Shopware_Controllers_Frontend_Custom404Detail->setSoldOutDate(Array) #7 /var/www/vendor/shopware/shopware/engine/Library/Enlight/Controller/Action.php(188): Shopware_Controllers_Frontend_Custom404Detail->indexAction() #8 /var/www/vendor/shopware/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight_Controller_Action->dispatch('indexAction') #9 /var/www/vendor/shopware/shopware/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #10 /var/www/vendor/shopware/shopware/engine/Shopware/Kernel.php(195): Enlight_Controller_Front->dispatch() #11 /var/www/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #12 /var/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(AppKernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /var/www/vendor/shopware/shopware/engine/Shopware/Components/HttpCache/AppCache.php(270): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 /var/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 /var/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #16 /var/www/vendor/shopware/shopware/engine/Shopware/Components/HttpCache/AppCache.php(196): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #17 /var/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #18 /var/www/vendor/shopware/shopware/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 /var/www/shopware.php(20): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #20 {main} thrown in /var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 51