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.

Sign up for GitHub

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

Jump to bottom

ActiveRecord::Deadlocked in datablock_storage#delete_column #57679

Open

snickell opened this issue Apr 1, 2024 · 1 comment

Labels

Contributor

snickell commented Apr 1, 2024

https://app.honeybadger.io/projects/3240/faults/106033231?q=request.url%3A%22%2Adatablock%2A%22

snickell added the honeybadger label

Contributor Author

snickell commented Apr 1, 2024

My best hypothesis:

delete_column modifies the columns column of the tables table, and it ALSO modifies entries in the records table to remove the deleted json key.
update_record and create_record ALSO modify the columns column of the tables table (when the new row adds a previously unseen column) and it also modifies one entry in the records table.

Maybe they do these operations in reverse order from each other? If so, the result would be a potential deadlock if they are run at the same time.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment