Fix #24426 - Removing the code for coarse locking.
Fix #24142 - Make in-flight transaction validation more optimistic to avoid spurious validation failures.