Forum Stats

  • 3,770,075 Users
  • 2,253,061 Discussions
  • 7,875,300 Comments

Discussions

simple clob insert breaks db with ORA-00600 - can someone confirm?

flavioc
flavioc Member Posts: 1,125 Silver Badge
edited Apr 29, 2020 8:57AM in General Database Discussions

Hi,

I'd like to ask if anyone having an Oracle db version 12.1.0.2.0 (EE 64bit) on some Linux flavor could test if the following simple script fails unexpectedly with ORA-00600.

I tested the script on my Oracle XE11 as well as Oracle 12.2.0.1.0 and it works as expected, no problems at all, indeed I was very surprised when they told me it was ending with such severe error as I have been inserting clobs split into 4000 bytes chunks for at least 10 years if not more.

CREATE TABLE TEST_INSERT (ID NUMBER, DOC CLOB);

INSERT INTO TEST_INSERT VALUES(1, empty_clob() || rpad('x',4000) || rpad('y',4000));

Thank you

Flavio

flavioc

Best Answer

  • Mike Navickas
    Mike Navickas Member Posts: 137 Blue Ribbon
    edited Apr 29, 2020 8:56AM Accepted Answer

    Yes, I am getting the same error on 12.1 instance:

    SQL> select banner from v$version;

    BANNER

    --------------------------------------------------------------------------------

    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

    PL/SQL Release 12.1.0.2.0 - Production

    CORE 12.1.0.2.0 Production

    TNS for Linux: Version 12.1.0.2.0 - Production

    NLSRTL Version 12.1.0.2.0 - Production

    SQL> CREATE TABLE TEST_INSERT (ID NUMBER, DOC CLOB);

    Table created.

    SQL> INSERT INTO TEST_INSERT VALUES(1, empty_clob() || rpad('x',4000) || rpad('y',4000));

    INSERT INTO TEST_INSERT VALUES(1, empty_clob() || rpad('x',4000) || rpad('y',4000))

                *

    ERROR at line 1:

    ORA-00600: internal error code, arguments: [kolaCreateFromSource-2], [], [],

    [], [], [], [], [], [], [], [], []

    SQL>

    Best option probably would be creating an SR with Oracle, since I could not find any references to  [kolaCreateFromSource-2] on Metalink.

    Reagards

    Mike Navickas

    flaviocflavioc

Answers

  • Mike Navickas
    Mike Navickas Member Posts: 137 Blue Ribbon
    edited Apr 29, 2020 8:56AM Accepted Answer

    Yes, I am getting the same error on 12.1 instance:

    SQL> select banner from v$version;

    BANNER

    --------------------------------------------------------------------------------

    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

    PL/SQL Release 12.1.0.2.0 - Production

    CORE 12.1.0.2.0 Production

    TNS for Linux: Version 12.1.0.2.0 - Production

    NLSRTL Version 12.1.0.2.0 - Production

    SQL> CREATE TABLE TEST_INSERT (ID NUMBER, DOC CLOB);

    Table created.

    SQL> INSERT INTO TEST_INSERT VALUES(1, empty_clob() || rpad('x',4000) || rpad('y',4000));

    INSERT INTO TEST_INSERT VALUES(1, empty_clob() || rpad('x',4000) || rpad('y',4000))

                *

    ERROR at line 1:

    ORA-00600: internal error code, arguments: [kolaCreateFromSource-2], [], [],

    [], [], [], [], [], [], [], [], []

    SQL>

    Best option probably would be creating an SR with Oracle, since I could not find any references to  [kolaCreateFromSource-2] on Metalink.

    Reagards

    Mike Navickas

    flaviocflavioc
  • flavioc
    flavioc Member Posts: 1,125 Silver Badge
    edited Apr 29, 2020 8:57AM

    thank you very much for your reply, I appreciate it.

    Flavio

  • User_NHD0O
    User_NHD0O Member Posts: 1 Red Ribbon

    A simpler test case:

    select empty_clob()||'x'||'y' from dual

    Workaround:

    select to_clob(empty_clob())||'x'||'y' from dual

    Seems to be fixed permanently in Oracle 12.2.

    flavioc