ActiveRecord::Deadlocked in admin/products_v3#bulk_update

[mkllnk]

Error in Open Food Network (Rails)

ActiveRecord::Deadlocked in admin/products_v3#bulk_update
PG::TRDeadlockDetected: ERROR: deadlock detected
DETAIL: Process 14960 waits for ShareLock on transaction 47239840; blocked by process 13644.
Process 13644 waits for ShareLock on transaction 47239854; blocked by process 14960.
HINT: See server log for query details.
CONTEXT: while updating tuple (71,7) in relation "enterprises"

View on Bugsnag

Stacktrace

app/models/enterprise.rb:605 - touch_distributors
app/models/spree/product.rb:299 - touch_supplier
app/services/sets/product_set.rb:107 - create_or_update_variant
app/services/sets/product_set.rb:98 - block in update_variants_attributes
app/services/sets/product_set.rb:97 - each
app/services/sets/product_set.rb:97 - update_variants_attributes
app/services/sets/product_set.rb:93 - update_product_variants
app/services/sets/product_set.rb:58 - update_product
app/services/sets/product_set.rb:52 - update_product_attributes
app/services/sets/product_set.rb:22 - block in save
app/services/sets/product_set.rb:21 - each_value
app/services/sets/product_set.rb:21 - each
app/services/sets/product_set.rb:21 - map
app/services/sets/product_set.rb:21 - save
app/controllers/admin/products_v3_controller.rb:24 - bulk_update

View full stacktrace

Created by Admin OFF via Bugsnag

[dacook]

This occurred when a delete occurred at the same time:

• Delete: Nov 8th, 08:46:44 GMT+11
• Bulk update: Nov 8th, 08:46:45 GMT+11
  

I checked, the deleted product was included in the bulk update (product id 17781 on au_prod)