Script to reproduce a race condition in spacewalk's lookup_evr() function

lookup_evr_hammer.rb

#!/usr/bin/env ruby
# encoding: UTF-8

require 'time'
require 'pg'

def random_string(rng)
  "%02x" % rng.rand(2 ** 64)
end

rng = Random.new(Time.new.to_i)
conn = PG.connect(dbname: "susemanager", user: "spacewalk", password: "spacewalk", host: "suma.tf.local")
conn.prepare("lookup_evr", "SELECT lookup_evr($1, $2, $3)")

conn.transaction do
  (1..1000).each do
    e = random_string(rng)
    v = random_string(rng)
    r = random_string(rng)

    conn.exec_prepared("lookup_evr", [e,v,r])
  end

  puts "Committing..."
end