search

qertoip / transaction_retry

Retries database transaction on deadlock and transaction serialization errors. Supports MySQL, PostgreSQL and SQLite.
MIT License
116 stars 42 forks source link

ActiveRecord::TransactionIsolationConflict not captured #5

Open fguillen opened 8 years ago

fguillen commented 8 years ago

I am seeing this error in my App:

ActiveRecord::TransactionIsolationConflict: Transaction isolation conflict detected: Deadlock found when trying to get lock; try restarting transaction
carsonreinke commented 8 years ago

Do you have stack trace from ActiveRecord at all?

fguillen commented 8 years ago

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
erated commented 7 years ago

same here