Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ORA-02055 from ut_runner when having a non-manual rollback test on a DB Link #601

Closed
pesse opened this Issue Mar 8, 2018 · 1 comment

Comments

Projects
None yet
2 participants
@pesse
Copy link
Member

pesse commented Mar 8, 2018

Setting:
We have a view available via DB link and a test which selects from it. The test-suite is rollback-automatic, not manual.

Problem:
Wenn calling ut_runner.run we get ORA-02055 after all tests are run (not immediately after the DB-link test).
If we switch the DB link test to rollback-manual it's not an issue (as long as we rollback properly)
ut.run doesn't have that problem because of an additional rollback.

We should maybe catch that situation more specifically and add a test

@jgebal jgebal added the bug label Mar 8, 2018

@jgebal

This comment has been minimized.

Copy link
Member

jgebal commented Mar 16, 2018

Or maybe we should move the pragma autonomous_transaction and rollback from ut.run to ut_runner.run?
Looks like a quick win.
Let me see if I can create a test to reproduce that issue and then do a fix for it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.