FirebirdSQL / firebird

Firebird server, client and tools
https://firebirdsql.org
1.26k stars 217 forks source link

No instant deadlock detection for read-only transactions #6811

Open dyemanov opened 3 years ago

dyemanov commented 3 years ago

This happens because v4 keeps the transaction lock for RO transactions while v3 and v2.5 release it at the transaction start. This behavious was changed when ReadConsistency mode was developed.

dyemanov commented 3 years ago

See also #6802 for details.