search

scc-digitalhub / AAC

Apache License 2.0
4 stars 7 forks source link

Transaction errors with postgresql due to isolation level serialization #496

Open matteo-s opened 11 months ago

matteo-s commented 11 months ago

When storing new tokens in postgresql the following error may happen on concurrent requests.

 Hint: The transaction might succeed if retried.; nested exception is org.postgresql.util.PSQLException: 
     ERROR: could not serialize access due to read/write dependencies among transactions
matteo-s commented 11 months ago

wontfix for now because it requires changing isolation levels for transactions in different components and affects only a single db platform.