acts_as_list: PG::TRDeadlockDetected
We seem to intermittently get Deadlock errors with acts_as_list and Postgres.
PG::TRDeadlockDetected: ERROR: deadlock detected DETAIL: Process 18092 waits for ShareLock on transaction 53198930; blocked by process 30411. Process 30411 waits for ShareLock on transaction 53198931; blocked by process 18092. HINT: See server log for query details. CONTEXT: while updating tuple (15,28) in relation "payment_methods" : UPDATE "payment_methods" SET "updated_at" = '2016-10-20 00:52:19.754301', "sort_order" = ("payment_methods"."sort_order" - 1) WHERE (user_id = 'user_id' AND deleted_at IS NULL) AND ("payment_methods"."sort_order" > 1) AND ("payment_methods"."sort_order" <= 3 AND "payment_methods".id != 'pm_id')
Is this a known issue? I’m using acts_as_list (0.7.7).
About this issue
- Original URL
- State: open
- Created 8 years ago
- Reactions: 3
- Comments: 23 (12 by maintainers)
@vi-huynh, if you could do some more digging into this to figure out why, that would be helpful 😃 Keen to get this fixed 😃
@brendon sorry for not getting back to you on this. Sadly I cannot remember what we did back then to “fix” the issue for us. I just checked our error reporting again to be sure. Issue did not pop up for us anymore. We are currently using the latest version.