Others have said much about a transaction loop, but I also don't think that database transactions are necessarily designed to fail in the sense that the failure

Others have said much about a transaction loop, but I also don't think that database transactions are necessarily designed to fail in the sense that the failure is a normal mode of operation. Failing transactions are still considered exceptional; their sole goal is to provide logical atomicity.