Skip to content

ORA-12838: cannot read/modify an object after modifying it in parallel on PaaS ATP #1134

@satyendra33

Description

@satyendra33

I have installed utPLSQL on a PaaS ATP database which is 19c Enterprise Edition Version 19.5.0.0.0. I tried to validate installation by creating package test_betwnstr and calling exec ut.run but here I get this exception.

I added a commit at line#91 of the package UT_ANNOTATION_CACHE_MANAGER, which resolved the error, but the run is taking forever.FYI- My installation is without DDL trigger and I do not have many custom objects in schema.

ORA-06512: at "UT3.UT_ANNOTATION_CACHE_MANAGER", line 91
ORA-06512: at "UT3.UT_ANNOTATION_MANAGER", line 201
ORA-06512: at "UT3.UT_ANNOTATION_MANAGER", line 311
ORA-06512: at "UT3.UT_SUITE_MANAGER", line 431
ORA-06512: at "UT3.UT_SUITE_MANAGER", line 505
ORA-06512: at "UT3.UT_RUNNER", line 150

ORA-12838: cannot read/modify an object after modifying it in parallel
ORA-06512: at "UT3.UT_ANNOTATION_CACHE_MANAGER", line 91
ORA-06512: at "UT3.UT_ANNOTATION_MANAGER", line 201
ORA-06512: at "UT3.UT_ANNOTATION_MANAGER", line 311
ORA-06512: at "UT3.UT_SUITE_MANAGER", line 431
ORA-06512: at "UT3.UT_SUITE_MANAGER", line 505

Error starting at line : 8 in command -
begin ut.run(); end;
Error report -
ORA-12838: cannot read/modify an object after modifying it in parallel
ORA-06512: at "UT3.UT_RUNNER", line 180
ORA-06512: at "UT3.UT_ANNOTATION_CACHE_MANAGER", line 91
ORA-06512: at "UT3.UT_ANNOTATION_MANAGER", line 201
ORA-06512: at "UT3.UT_ANNOTATION_MANAGER", line 311
ORA-06512: at "UT3.UT_SUITE_MANAGER", line 431
ORA-06512: at "UT3.UT_SUITE_MANAGER", line 505
ORA-06512: at "UT3.UT_RUNNER", line 150
ORA-06512: at "UT3.UT", line 134
ORA-06512: at "UT3.UT", line 488
ORA-06512: at "UT3.UT", line 558
ORA-06512: at line 1
12838. 00000 - "cannot read/modify an object after modifying it in parallel"
*Cause: Within the same transaction, an attempt was made to add read or
modification statements on a table after it had been modified in parallel
or with direct load. This is not permitted.
*Action: Rewrite the transaction, or break it up into two transactions
one containing the initial modification and the second containing the
parallel modification operation.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions