Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1...
The UUID of an uploaded file was not unique. This only happened twice until now but it should actually never happen. Maybe the error needs to be caught in php.
Sentry Issue: FOODSHARINGDE-PROD-BACKEND-1X7
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'eb2a65a6-d073-4816-92c8-4579ba370c30' for key 'uploads'
File "/src/Modules/Core/Database.php", line 662, in Foodsharing\Modules\Core\Database::preparedQuery
return $statement->executeQuery();
File "/src/Modules/Core/Database.php", line 273, in Foodsharing\Modules\Core\Database::insert
$this->preparedQuery($query, array_values($data));
File "/src/Modules/Uploads/UploadsGateway.php", line 45, in Foodsharing\Modules\Uploads\UploadsGateway::addFile
'uuid' => $uuid,
File "/src/RestApi/UploadsRestController.php", line 138, in Foodsharing\RestApi\UploadsRestController::uploadImageAction
$fileInfoFromDatabase = $this->uploadsGateway->addFile($this->session->id(), $temporaryFile->hashedBody, $temporaryFileSize, $temporaryFileMimeType);
File "/public/index.php", line 34
$response = $kernel->handle($request);
...
(7 additional frame(s) were not displayed)
Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'eb2a65a6-d073-4816-92c8-4579ba370c30' for key 'uploads'
File "/src/Modules/Core/Database.php", line 662, in Foodsharing\Modules\Core\Database::preparedQuery
return $statement->executeQuery();
File "/src/Modules/Core/Database.php", line 273, in Foodsharing\Modules\Core\Database::insert
$this->preparedQuery($query, array_values($data));
File "/src/Modules/Uploads/UploadsGateway.php", line 45, in Foodsharing\Modules\Uploads\UploadsGateway::addFile
'uuid' => $uuid,
File "/src/RestApi/UploadsRestController.php", line 138, in Foodsharing\RestApi\UploadsRestController::uploadImageAction
$fileInfoFromDatabase = $this->uploadsGateway->addFile($this->session->id(), $temporaryFile->hashedBody, $temporaryFileSize, $temporaryFileMimeType);
File "/public/index.php", line 34
$response = $kernel->handle($request);
...
(7 additional frame(s) were not displayed)
Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'eb2a65a6-d073-4816-92c8-4579ba370c30' for key 'uploads'
File "/src/Modules/Core/Database.php", line 662, in Foodsharing\Modules\Core\Database::preparedQuery
return $statement->executeQuery();
File "/src/Modules/Core/Database.php", line 273, in Foodsharing\Modules\Core\Database::insert
$this->preparedQuery($query, array_values($data));
File "/src/Modules/Uploads/UploadsGateway.php", line 45, in Foodsharing\Modules\Uploads\UploadsGateway::addFile
'uuid' => $uuid,
File "/src/RestApi/UploadsRestController.php", line 138, in Foodsharing\RestApi\UploadsRestController::uploadImageAction
$fileInfoFromDatabase = $this->uploadsGateway->addFile($this->session->id(), $temporaryFile->hashedBody, $temporaryFileSize, $temporaryFileMimeType);
File "/public/index.php", line 34
$response = $kernel->handle($request);
...
(8 additional frame(s) were not displayed)
Edited by Alex