deadlock

deadlock.log

[[email protected] /var/www/shopper/ss/current/log]$ zcat production.log-20170321.gz | grep '2017-03-20T18:57:21.144275 #1282' -A 30
D, [2017-03-20T18:57:21.144275 #1282] DEBUG -- : [85d9fbfa-1539-48da-beba-b1c8d25ff5fc]    (1.0ms)  ROLLBACK
I, [2017-03-20T18:57:21.144523 #1282]  INFO -- : [85d9fbfa-1539-48da-beba-b1c8d25ff5fc] Completed 500 Internal Server Error in 1059ms (ActiveRecord: 1032.1ms)
D, [2017-03-20T18:57:21.144579 #1282] DEBUG -- : [5b0994f6-e263-4a99-8e43-0c8d2ab20c85]   Billing::Account Load (0.3ms)  SELECT  "billing_accounts".* FROM "billing_accounts" WHERE "billing_accounts"."owner_id" = $1 AND "billing_accounts"."owner_type" = $2 LIMIT 1  [["owner_id", 659], ["owner_type", "Promotion"]]
F, [2017-03-20T18:57:21.145696 #1282] FATAL -- : [85d9fbfa-1539-48da-beba-b1c8d25ff5fc]
ActiveRecord::StatementInvalid (PG::TRDeadlockDetected: ERROR:  deadlock detected
ПОДРОБНОСТИ:  Process 14287 waits for ShareLock on transaction 15108488; blocked by process 8732.
Process 8732 waits for AccessExclusiveLock on tuple (2,11) of relation 16477 of database 16385; blocked by process 14287.
ПОДСКАЗКА:  See server log for query details.
КОНТЕКСТ:  while locking tuple (2,11) in relation "promotions"
: SELECT  "promotions".* FROM "promotions" WHERE "promotions"."id" = $1 LIMIT 1 FOR UPDATE):
  app/mutations/promotions/check_billing_statistics.rb:8:in `execute'
  app/mutations/involvements/cancel.rb:39:in `check_promotion_billing_statistics'
  app/mutations/involvements/cancel.rb:19:in `execute'
  app/mutations/admin/checks/process_form.rb:57:in `cancel_involvement'
  app/mutations/admin/checks/process_form.rb:46:in `handling_involvement'
  app/mutations/admin/checks/process_form.rb:31:in `block in collect_involvements_data'
  app/mutations/admin/checks/process_form.rb:29:in `each'
  app/mutations/admin/checks/process_form.rb:29:in `collect_involvements_data'
  app/mutations/admin/checks/process_form.rb:12:in `execute'
  app/admin/check.rb:170:in `process_check'
  app/admin/check.rb:130:in `update'