The only issue I can imagine is the importing Base from some other module. There could be multiple session created without a proper binding which can cause rollback to malfunction. Declare a new base with test models to properly isolated the test environment. If that solve the issue we may debug the rest

We can also explore library like model-bakery which might help us isolating our model although I'm not sure about it