Skip to content

ActiveRecord::TransactionIsolationConflict not captured #5

Description

@fguillen

I am seeing this error in my App:

ActiveRecord::TransactionIsolationConflict: Transaction isolation conflict detected: Deadlock found when trying to get lock; try restarting transaction
  • Rails: 4.2.6
  • TransactionRetry: 1.0.2

Activity

  1. carsonreinke commented on Jun 6, 2016

    @carsonreinke

    Do you have stack trace from ActiveRecord at all?

  2. fguillen commented on Jun 8, 2016

    @fguillen
    Author

    Here:

    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract_mysql_adapter.rb" line 305 in query
    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract_mysql_adapter.rb" line 305 in block in execute
    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract_adapter.rb" line 472 in block in log
    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activesupport-4.2.6/lib/active_support/notifications/instrumenter.rb" line 20 in instrument
    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract_adapter.rb" line 466 in log
    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract_mysql_adapter.rb" line 305 in execute
    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb" line 231 in execute
    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb" line 252 in exec_delete
    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract/database_statements.rb" line 114 in update
    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract/query_cache.rb" line 14 in update
    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/relation.rb" line 345 in update_all
    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/counter_cache.rb" line 84 in update_counters
    File "/var/www/campaignplatform.daliaresearch.com/shared/bundle/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/locking/optimistic.rb" line 170 in update_counters
    File "/var/www/campaignplatform.daliaresearch.com/releases/20160606130833/app/models/offer.rb" line 378 in update_total_provider_reward_dollar
    
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions