Niveth
Niveth
Explore posts from servers
SSolidJSDTDrizzle Team
PostsComments
DTDrizzle Team
Created by Niveth on 1/18/2025 in #help
Identifying error due to Serializable isolation failure in postgres
I have a transaction with serializable isolation level 
db.transaction((tx) => {....}, {isolationLevel: "serializable"})
db.transaction((tx) => {....}, {isolationLevel: "serializable"})
Based on the postgres documentation I have to retry it whenever postgres is unable to guarantee the Serializable isolation level. The error raised by the postgres when I have to retry is 
ERROR:  could not serialize access due to read/write dependencies among transactions
ERROR:  could not serialize access due to read/write dependencies among transactions
Link to the postgres documentation (https://www.postgresql.org/docs/current/transaction-iso.html) My question is to how to identify the above error so that I can retry only when the error occurs due to above case. I can't retry every time there is an error. Thanks!!
1 replies