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-27", "250427"]:
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