Skip to content
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

Distributed transactions under a concurrency scenario #7637

Open
SandeepFranklin opened this issue Jun 26, 2024 · 0 comments
Open

Distributed transactions under a concurrency scenario #7637

SandeepFranklin opened this issue Jun 26, 2024 · 0 comments

Comments

@SandeepFranklin
Copy link

This issue is the following question of this issue, I can not re-open it so I create the new one.

My question is about how Citus would work in a concurrency scenario. Suppose Citus executes two transactions t1 and t2 at the same time, which are generated by the same piece of code of a concurrent program, so they would acquire locks first on A and then on B in the same order.

Let's say that A is on NodeA and B is on NodeB, and both t1 and t2 are distributed transactions across nodes. In this case, is it possible that t1 acquires the lock on A first and t2 acquires the lock on B first, then resulting in a deadlock?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant