While investigating BF-26971 we figured out that the reason with the test failure on the timeout is the fact that the transaction was not committed, while the test code assumed it did.

In order to avoid such BFs in the future we decided to retry the transaction until it is committed.