The transaction replay will fail if it is attempted more than once. The desired behavior would be to retry the transaction until the delayed_retry_timeout is exceeded which would cause the feature to work consistently in all scenarios.

There are no concerns for consistency as the transaction checksum is updated for each new statement added to the transaction. This guarantees that replaying the transaction always returns results identical to the one the client already has.