Issue #3495554: Add regression test for transaction manager

Simon Bäserequested to merge
issue/drupal-3495554:3495554-error-unpiling-database into main

Closes #3495554

Merge request reports