New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
update read committed docs around handling retries #18375
Comments
Shannon Bradshaw (shannonbradshaw) commented: |
Richard Loveland (rmloveland) commented: Ryan Kuo I think this could go either way - historically I've done a bunch of transaction retry work but you probably have more context on the READ COMMITTED stuff right now. What do you think? |
A relevant slack thread, for some context: |
Ryan Kuo (taroface) commented: |
Ryan Kuo (taroface) commented: |
Shannon Bradshaw (shannonbradshaw) commented: |
Michael Erickson (michae2) commented:
In 23.2, under read committed isolation, applications could still encounter spurious 40001 errors in rare cases, such as lease transfers. In 24.1, under read committed isolation, we expect applications to encounter no spurious 40001 errors. (The only 40001 errors applications might encounter are all avoidable through workload changes, such as avoiding deadlocks or increasing
results_buffer_size
.)This lack of 40001 errors is a special property of read committed isolation, and is definitely worth documenting.
I'm not sure exactly which pages should be updated, but from a quick glance maybe the following:
Jira Issue: DOC-9869
The text was updated successfully, but these errors were encountered: