search

corona-warn-app / cwa-verification-server

Backend implementation of the verification process
Apache License 2.0
343 stars 105 forks source link

bug: possible multiple entries with same hashed_guid #248

Closed ascheibal closed 2 years ago

ascheibal commented 2 years ago

Describe the bug

More than one entry with a hashed_guid can exist.

Expected behaviour

hashed_guid entries have to be unique.

Steps to reproduce the issue

only in havy load scenarios with multiple instances, threads accessing the database.

Technical details

Possible Fix

add a unique constraint to hashed_guid column

Additional context

will produce a SQL UniqueConstraintViolation Exception that should be handled with an http state 400 response to the App.