Hi folks,
I am bringing utPLSQL project back to life and I am running into an indeterministic problem when running our pipeline.
Most of the times the pipeline fails for 23.26.1 ai with the mentioned error.
BEGIN ut.run(user||'.test_remove_rooms_by_name'); END;
*
ERROR at line 1:
ORA-21779: duration not active
ORA-06512: at "UT3_DEVELOP.UT_REPORTER_BASE", line 171
ORA-06512: at "UT3_DEVELOP.UT_EVENT_MANAGER", line 70
ORA-06512: at "UT3_DEVELOP.UT_EVENT_MANAGER", line 80
ORA-06512: at "UT3_DEVELOP.UT_RUNNER", line 93
ORA-06512: at "UT3_DEVELOP.UT", line 143
ORA-06512: at "UT3_DEVELOP.UT", line 577
ORA-06512: at "UT3_DEVELOP.UT", line 744
ORA-06512: at line 1
Help: https://docs.oracle.com/error-help/db/ora-21779/
Disconnected from Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for Free
Version 23.26.1.0.0
Error: Process completed with exit code 1.
Here are the runs where the problem can be seen.
https://github.com/utPLSQL/utPLSQL/actions/runs/22826603788/job/66207788528
https://github.com/utPLSQL/utPLSQL/actions/runs/22826603788/job/66208318485
https://github.com/utPLSQL/utPLSQL/actions/runs/22826341011/job/66207141087
https://github.com/utPLSQL/utPLSQL/actions/runs/22825692686/job/66205499563
https://github.com/utPLSQL/utPLSQL/actions/runs/22825418189/job/66204799500
On occasions it works well but it is not related to any code changes.
https://github.com/utPLSQL/utPLSQL/actions/runs/22826475558/job/66207472805
https://github.com/utPLSQL/utPLSQL/actions/runs/22826603788/job/66208866950
https://github.com/utPLSQL/utPLSQL/actions/runs/22825956187/job/66206573277
Searching online didn't help much so I suspect it is some issue with the image itself.
Can you please help diagnosing and fixing this issue?
Thank you very much.
Jacek Gebal
P.S.
The problem only occurs on image 23.26.1, not on 23.26.0.
P.P.S.
We have found and implemented a workaround for the problem, but the issue is clearly an Oracle bug related to lifespan of a variable of object type that is passed as in out nocopy.