OurBigBook About$ Donate
 Sign in Sign up

Ciro Santilli @cirosantilli 37

 Message
User's profile image

 Incoming links: SQL REPEATABLE READ isolation level

PostgreSQL serialization failure Updated 2025-07-16
 View more
When using SQL REPEATABLE READ isolation level and SQL SERIALIZABLE isolation level, concurrent transactions may fail with a serialization failure, and then you might need to retry them. You server code or your ORM must always account for that.
A good way to explore when it happens is to use the example
Related questions:
  • stackoverflow.com/questions/7705273/what-are-the-conditions-for-encountering-a-serialization-failure
  • stackoverflow.com/questions/59351109/error-could-not-serialize-access-due-to-concurrent-update
  • stackoverflow.com/questions/50797097/postgres-could-not-serialize-access-due-to-concurrent-update/51932824
 Read the full article
Total articles: 1
 About$ Donate Content license: CC BY-SA 4.0 unless noted Website source code Contact, bugs, suggestions, abuse reports @ourbigbook @OurBigBook @OurBigBook