Skip to content

Doctrine\DBAL\Exception\DeadlockException: An exception occurred while executing a query: SQLSTATE[40001]: Serialization failure: 1213 Deadl...

Sentry Issue: FOODSHARINGDE-BETA-BACKEND-15Q

PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
  File "/src/Modules/Core/Database.php", line 656, in Foodsharing\Modules\Core\Database::preparedQuery
    return $statement->executeQuery();
  File "/src/Modules/Core/Database.php", line 376, in Foodsharing\Modules\Core\Database::update
    return $this->preparedQuery($query, $params)->rowCount();
  File "/src/Modules/Bell/BellGateway.php", line 241, in Foodsharing\Modules\Bell\BellGateway::setBellsAsSeen
    'foodsaver_id' => $foodsaverId
  File "/src/RestApi/BellRestController.php", line 75, in Foodsharing\RestApi\BellRestController::markBellsAsRead
    $changed = $this->bellGateway->setBellsAsSeen($bellIds, $id);
  File "/public/index.php", line 34
    $response = $kernel->handle($request);
...
(9 additional frame(s) were not displayed)

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
  File "/src/Modules/Core/Database.php", line 656, in Foodsharing\Modules\Core\Database::preparedQuery
    return $statement->executeQuery();
  File "/src/Modules/Core/Database.php", line 376, in Foodsharing\Modules\Core\Database::update
    return $this->preparedQuery($query, $params)->rowCount();
  File "/src/Modules/Bell/BellGateway.php", line 241, in Foodsharing\Modules\Bell\BellGateway::setBellsAsSeen
    'foodsaver_id' => $foodsaverId
  File "/src/RestApi/BellRestController.php", line 75, in Foodsharing\RestApi\BellRestController::markBellsAsRead
    $changed = $this->bellGateway->setBellsAsSeen($bellIds, $id);
  File "/public/index.php", line 34
    $response = $kernel->handle($request);
...
(9 additional frame(s) were not displayed)

Doctrine\DBAL\Exception\DeadlockException: An exception occurred while executing a query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
  File "/src/Modules/Core/Database.php", line 656, in Foodsharing\Modules\Core\Database::preparedQuery
    return $statement->executeQuery();
  File "/src/Modules/Core/Database.php", line 376, in Foodsharing\Modules\Core\Database::update
    return $this->preparedQuery($query, $params)->rowCount();
  File "/src/Modules/Bell/BellGateway.php", line 241, in Foodsharing\Modules\Bell\BellGateway::setBellsAsSeen
    'foodsaver_id' => $foodsaverId
  File "/src/RestApi/BellRestController.php", line 75, in Foodsharing\RestApi\BellRestController::markBellsAsRead
    $changed = $this->bellGateway->setBellsAsSeen($bellIds, $id);
  File "/public/index.php", line 34
    $response = $kernel->handle($request);
...
(8 additional frame(s) were not displayed)