Test for warehouse deadlock updating dimensions.

gistfile1.rb

# Change deadlock retry to log exceptions
DeadlockRetry;
module DeadlockRetry
  class << self
    def suppress_deadlock
      yield
    rescue ActiveRecord::StatementInvalid => ex
      if !DEADLOCK_ERROR_MESSAGES.any? { |msg| ex.message.include?(msg) }
        raise
      else
        puts "deadlock!"
      end
    end
  end
end

# this is just the dimension update code from warehouse.
def update_all_dimensions(attributes)
  dimension_generator = Warehouse::Base::Dimension::Generator.new attributes

  Warehouse::CallFactShard.shards.first.all_dimensions.each do |dim|
    DeadlockRetry.transaction(connection) { dimension_generator.dimension_id( dim ) }
  end
end

# Run
def run
  event_attributes = Warehouse::CallFact.call_event_attributes(Call.last)
  1000.times do
    puts ( Benchmark.realtime { Warehouse::CallFact.update_all_dimensions(event_attributes) } )
  end
end