rollback transaction and new tests

Signed-off-by: Max Stemplinger <ms@campudus.com>