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"