ORA-00600 [qxuag_get_md4] or [qxuag_find_udag] in 11g onwards when user-defined aggregates (UDAGs) (Doc ID 1376310.1)

Last updated on JUNE 05, 2015

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

Your alert log shows ORA-00600 [qxuag_get_md4] or ORA-600 [qxuag_find_udag] errors.

Fri Oct 14 10:38:40 2011
Errors in file /app/oracle/diag/rdbms/X01/X012/trace/X012_ora_17281.trc (incident=22233):
ORA-00600: [qxuag_get_md4], [0], [], [], [], [], [], [], [], [], [], []
Incident details in: /app/oracle/diag/rdbms/X01/X012/incident/incdir_22233/X012_ora_17281_i22233.trc
Fri Oct 14 10:38:43 2011

You may see some or all of the following conditions in your trace file. In our example the trace file analysis shows:

Dump file /app/oracle/diag/rdbms/X01/X012/incident/incdir_51157/X012_ora_2669_i51157.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /app/oracle/product/11.2.0/db_1
System name: Linux


*** 2011-10-17 22:44:48.831
*** SESSION ID:(157.4639) 2011-10-17 22:44:48.831
*** CLIENT ID:() 2011-10-17 22:44:48.831
*** SERVICE NAME:(X01) 2011-10-17 22:44:48.831
*** MODULE NAME:(PL/SQL Developer) 2011-10-17 22:44:48.831          <===3rd party tool
*** ACTION NAME:(SQL Window - New) 2011-10-17 22:44:48.831

Dump continued from file: /app/oracle/diag/rdbms/hk01/hk012/trace/hk012_ora_2669.trc
ORA-00600: ÄÚ²¿´íÎó´úÂë, ²ÎÊý: [qxuag_get_md4], [0], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 51157 (ORA 600 [qxuag_get_md4]) ========

*** 2011-10-17 22:44:48.832
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=gvbmk0qng6fjp) -----
select t.*,t2.DEPTNAME,t2.username,
'2011-10-17' as dt,
(case when g2.gridstarttime is not null then to_char(g2.gridstarttime, 'HH24:MI')
else ''
end ) as GST,
...
)chk on chk.worker_userid = t.WORKER_USERID
where t.WORKER_DATE = 'XXXX-10-17'
and t.UNITID = 'XYZ'
order by GROUPNAME,DEPTNAME, USERNAME desc

complex Select query involving user-defined aggregates (UDAGs)

----- Call Stack Trace -----

Stack Trace: ksfdmp dbgexPhaseII dbgexProcessError dbgeExecuteForError dbgePostErrorKGE kgeadse kgerinv_internal kgerinv kgesinv ksesin qxuag_find_udag qxuageag evaopn2 qervwRow Procedure qerghFetch qervwFetch rwsfcd qerhjFetch qerjoFetch rwsfcd qerhjFetch rwsfcd qerhjFetch qerjoFetch qersoProcessULS qersoFetch opifch2 opifch opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main start

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms