Retries database transaction on deadlock and transaction serialization errors. Supports MySQL, PostgreSQL, and SQLite.
The gem works automatically by rescuing ActiveRecord::TransactionIsolationConflict and retrying the transaction.
Add this to your Gemfile:
gem 'transaction_retry'
Then run:
bundle
It works out of the box with Ruby on Rails.
If you have a standalone ActiveRecord-based project you'll need to call:
TransactionRetry.apply_activerecord_patch # after connecting to the database
after connecting to the database.
You can optionally configure transaction_retry gem in your config/initializers/transaction_retry.rb (or anywhere else):
TransactionRetry.max_retries = 3
TransactionRetry.wait_times = [0, 1, 2, 4, 8, 16, 32] # seconds to sleep after retry n
This gem was initially developed for and successfully works in production at Kontomierz.pl - the finest Polish personal finance app.
Run tests on the selected database (mysql2 by default):
db=mysql2 bundle exec rake test
db=postgresql bundle exec rake test
db=sqlite3 bundle exec rake test
Run tests on all supported databases:
./tests
Database configuration is hardcoded in test/db/db.rb; feel free to improve this and submit a pull request.
You should be very suspicious about any gem that monkey patches your stock Ruby on Rails framework.
This gem is carefully written to not be more intrusive than it needs to be:
Released under the MIT license. Copyright (C) 2012 Piotr 'Qertoip' Włodarek.