Rolling back a committed transaction

[pathange-s]

How can I rollback a committed transaction?

I am working on a simple two phase commit:

1. Write on api db with apiTx
2. Write on cdpc db with cdpcTx

	// Commit Phase - try committing both transactions
	if err := apiTx.Commit().Error; err != nil {
		// If committing apiTx fails, rollback both transactions
		rollback()
		return errors.InternalServerError(errors.ErrInternalServer, "error committing api transaction: "+err.Error())
	}

	if err := cdpcTx.Commit().Error; err != nil {
		// If cdpcTx commit fails after apiTx has already committed, attempt to "compensate" by reversing apiTx
		// Need to check if we can rollback a committed transaction
		apiRollbackErr := apiTx.Rollback().Error
		if apiRollbackErr != nil {
			return errors.InternalServerError(errors.ErrInternalServer, "error committing cdpc transaction and failed to rollback api transaction: "+err.Error()+"; "+apiRollbackErr.Error())
		}
		return errors.InternalServerError(errors.ErrInternalServer, "error committing cdpc transaction after api commit: "+err.Error())
	}