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-00600 during execution #1227

Open
MickeVr opened this issue Aug 22, 2022 · 1 comment
Open

ORA-00600 during execution #1227

MickeVr opened this issue Aug 22, 2022 · 1 comment

Comments

@MickeVr
Copy link

MickeVr commented Aug 22, 2022

During test execution with utplsql-cli, I get the following error. I am not sure if it is really an issue in utplsql or of the database

ORA-00600: internal error code, arguments: [kollgdur1], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "UT.UT_EXECUTABLE", line 142
ORA-06512: at "UT.UT_EXECUTABLE", line 44
ORA-06512: at "UT.UT_EXECUTABLE_TEST", line 178
ORA-06512: at "UT.UT_EXECUTABLE_TEST", line 38
ORA-06512: at "UT.UT_TEST", line 80
ORA-06512: at "UT.UT_SUITE_ITEM", line 50
ORA-06512: at "UT.UT_SUITE", line 66
ORA-06512: at "UT.UT_SUITE_ITEM", line 50
ORA-06512: at "UT.UT_SUITE", line 66
ORA-06512: at "UT.UT_RUN", line 59
ORA-06512: at "UT.UT_SUITE_ITEM", line 50
ORA-06512: at "UT.UT_RUNNER", line 144
ORA-06512: at line 1

========= Dump for incident (ORA 600 [kollgdur1]) ========
*** 2022-08-19T18:15:51.887888+02:00
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=fxw2jhgfw3jqm) -----
SELECT /*+ no_parallel */ XMLSERIALIZE( CONTENT UCD.ITEM_DATA NO INDENT) FROM UT_COMPOUND_DATA_TMP TMP ,XMLTABLE ( '/ROWSET' PASSING TMP.ITEM_DATA COLUMNS ITEM_DATA XMLTYPE PATH '*' ) UCD WHERE TMP.DATA_ID = :B2 AND ROWNUM <= :B1
[TOC00004]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x7abcde80       652  package body UT.UT_COMPOUND_DATA_HELPER.GET_ROW_DATA_AS_XML
0x9f41bd98        51  type body UT.UT_COMPOUND_DATA_VALUE.TO_STRING
0xb77e6cf8       128  type body UT.UT_DATA_VALUE_REFCURSOR.TO_STRING
0x18a605d40        56  type body UT.UT_DATA_VALUE.TO_STRING_REPORT
0x8fa74d38        62  type body UT.UT_MATCHER.FAILURE_MESSAGE_WHEN_NEGATED
0x157e07518       327  type body UT.UT_EQUAL.FAILURE_MESSAGE_WHEN_NEGATED
0xe2bc7580        40  type body UT.UT_EXPECTATION_BASE.NOT_TO
0x13fa81fa8       234  type body UT.UT_EXPECTATION.NOT_TO_EQUAL
0x16a9d4b28        50  package body UT.UT_PACK_NUMBER_ROUND.UT_PRECISION_NOT_EQUAL
0x1027c1090         6  anonymous block
0x182f53f88      1721  package body SYS.DBMS_SQL.EXECUTE
0xeaa4f0e8       142  type body UT.UT_EXECUTABLE.DO_EXECUTE
0xeaa4f0e8        44  type body UT.
PL/SQL call stack truncated after 1024 bytes.
[TOC00004-END]
[TOC00003-END]

Version info about utPLSQL and Database version
utPLSQL v3.1.12.3876
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

NLS_LANGUAGE	AMERICAN
NLS_TERRITORY	AMERICA
NLS_CURRENCY	$
NLS_ISO_CURRENCY	AMERICA
NLS_NUMERIC_CHARACTERS	.,
NLS_CALENDAR	GREGORIAN
NLS_DATE_FORMAT	DD-MON-RR
NLS_DATE_LANGUAGE	AMERICAN
NLS_SORT	BINARY
NLS_TIME_FORMAT	HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT	DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY	$
NLS_COMP	BINARY
NLS_LENGTH_SEMANTICS	BYTE
NLS_NCHAR_CONV_EXCP	FALSE

x86_64/Linux 2.4.xx

Information about client software
utPLSQL-cli 3.1.7
utPLSQL-java-api 3.1.7.504
Java-Version: 1.8.0_301
NLS_LANG: null

To Reproduce
Starting the process again did not raise any errors, so I am not able to reproduce it.

Expected behavior
I would not expect this error to occur.

@jgebal
Copy link
Member

jgebal commented Aug 22, 2022

Hi @MickeVr
Thanks for putting this into an issue.
At this time I'm unable to help. If you are unable to reproduce it, most likely we are unable to reproduce it even more.

If you manage to fins steps to reproduce, please share those. I assume that the issue is on Oracle side (as in most cases with ORA-00600).

Please keep us posted if you hear back from Oracle on that issue or if the issue is happening regularly and it is becoming a blocker.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants