My Oracle Support Banner

XDB.DBMS_XMLPARSER causing an application to hang (Doc ID 1103716.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.1 [Release 10.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Session running an application which calls XDB.DBMS_XMLPARSER hangs.  Memory usage is stable, but CPU usage is increasing.  The only way to stop the session is by killing it.

The application is calling DBMS_XMLPARSER.freeparser (<variable>) in a loop as it parses multiple files.

Error stack generated by oradebug dump errorstack 3 or by OS functions like procstack (AIX) or pstack (Solaris/Linux) shows

ksdxfdmp ksdxcb sspuser _restore_rt qmpa_parser_freeparser spefcmpa spefmccallstd

or

0x0000000100963d50 qmubaGet(??, ??, ??) + 0x30
0x0000000108342494 qmpa_parser_freeparser(0x0, 0x110a719a0,0xfffffffffff5198,0x110920118) + 0x114
0x0000000102e84334 spefcmpa(??, ??, ??, ??, ??) + 0x134

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.