tools/delete_all_error_timeout_queue_messages.rb
#!/usr/bin/env ruby
require File.expand_path('../config/environment', __dir__)
cond = {:state => ["error", "timeout"]}
puts "Deleting #{MiqQueue.where(cond).count} queue messages"
result = MiqQueue.where(cond).delete_all
puts "Done, deleted #{result} rows"