Currently there is some custom code that handles DB transaction errors in the db library. Actually, such a transaction error can be seen as an exception, and should be handled by PHP exceptions.

Just throw a DatabaseTransactionException (or whatever you want to call it) and let the default exception handler handle the further execution.