Please let's hear the solution from all the people complaining about a rollback.  Please solve everyone's problems.  If your reply amounts to "I don't know, but a rollback isn't the solution" then please STFU you have nothing to offer.