Slow XQuery Compilation - Server hang (Doc ID 775734.1)

Last updated on MARCH 27, 2020

Applies to:

Goal

DESCRIPTION:

When processing a request, the customer noticed unacceptable times - about 5 minutes to process this request. When
thread dumps were taken, they indicated that the thread is busy compiling the XQuery. Customer already applied the
patch CR185001.

"ExecuteThread: '12' for queue: 'weblogic.kernel.Default'" daemon prio=5 tid=0x53BE2C60 nid=0x9d4 runnable
[5533e000..5533fdc0]
	at com.bea.xquery.util.MyHashMap.rehash(MyHashMap.java:302)
	at com.bea.xquery.util.MyHashMap.put(MyHashMap.java:377)
	at com.bea.xquery.util.MyHashSet.add(MyHashSet.java:164)
	at java.util.AbstractCollection.addAll(AbstractCollection.java:315)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.SecondOrderExpression.getFreeVariables(SecondOrderExpression.java:56)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.SecondOrderExpression.getFreeVariables(SecondOrderExpression.java:56)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.SecondOrderExpression.getFreeVariables(SecondOrderExpression.java:56)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.SecondOrderExpression.getFreeVariables(SecondOrderExpression.java:56)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.SecondOrderExpression.getFreeVariables(SecondOrderExpression.java:56)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.SecondOrderExpression.getFreeVariables(SecondOrderExpression.java:56)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.SecondOrderExpression.getFreeVariables(SecondOrderExpression.java:56)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.SecondOrderExpression.getFreeVariables(SecondOrderExpression.java:56)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.SecondOrderExpression.getFreeVariables(SecondOrderExpression.java:56)
	at com.bea.xquery.compiler.Expression.getFreeVariables(Expression.java:228)
	at com.bea.xquery.compiler.SecondOrderExpression.getFreeVariables(SecondOrderExpression.java:56)
	at com.bea.xquery.rewriting.Rule12.rewrite(Rule12.java:53)
	at com.bea.xquery.rewriting.RewritingRule.callbackTraverse(RewritingRule.java:158)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:445)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
and 

"ExecuteThread: '12' for queue: 'weblogic.kernel.Default'" daemon prio=5 tid=0x53BE2C60 nid=0x9d4 runnable
[5533e000..5533fdc0]
	at java.lang.Object.hashCode(Native Method)
	at com.bea.xquery.types.Transition.hashCode(Transition.java:35)
	at com.bea.xquery.util.MyHashMap.put(MyHashMap.java:355)
	at com.bea.xquery.util.MyHashSet.add(MyHashSet.java:164)
	at com.bea.xquery.types.State.addTransition(State.java:50)
	at com.bea.xquery.types.Transition.<init>(Transition.java:60)
	at com.bea.xquery.types.XQueryTypeDFA.clone(XQueryTypeDFA.java:47)
	at com.bea.xquery.types.XQueryTypeNFA.<init>(XQueryTypeNFA.java:65)
	at com.bea.xquery.types.XQueryTypeDFA.intersectNonMinimal(XQueryTypeDFA.java:623)
	at com.bea.xquery.types.XQueryTypeDFA.intersect(XQueryTypeDFA.java:92)
	at com.bea.xquery.types.XQueryType.intersect(XQueryType.java:318)
	at com.bea.xquery.compiler.MatchExpression.getTypeImpl(MatchExpression.java:122)
	at com.bea.xquery.compiler.Expression.getType(Expression.java:294)
	at com.bea.xquery.compiler.FLWRExpression.getTypeImpl(FLWRExpression.java:298)
	at com.bea.xquery.compiler.Expression.getType(Expression.java:294)
	at com.bea.xquery.compiler.FunctParamCastExpression.getTypeImpl(FunctParamCastExpression.java:90)
	at com.bea.xquery.compiler.Expression.getType(Expression.java:294)
	at com.bea.xquery.compiler.FirstOrderExpression.getTypeImpl(FirstOrderExpression.java:284)
	at com.bea.xquery.compiler.Expression.getType(Expression.java:294)
	at com.bea.xquery.compiler.FunctParamCastExpression.getTypeImpl(FunctParamCastExpression.java:90)
	at com.bea.xquery.compiler.Expression.getType(Expression.java:294)
	at com.bea.xquery.compiler.FirstOrderExpression.getTypeImpl(FirstOrderExpression.java:284)
	at com.bea.xquery.compiler.Expression.getType(Expression.java:294)
	at com.bea.xquery.compiler.FunctParamCastExpression.getTypeImpl(FunctParamCastExpression.java:90)
	at com.bea.xquery.compiler.Expression.getType(Expression.java:294)
	at com.bea.xquery.compiler.FirstOrderExpression.getTypeImpl(FirstOrderExpression.java:284)
	at com.bea.xquery.compiler.Expression.getType(Expression.java:294)
	at com.bea.xquery.compiler.FunctParamCastExpression.getTypeImpl(FunctParamCastExpression.java:90)
	at com.bea.xquery.compiler.Expression.getType(Expression.java:294)
	at com.bea.xquery.compiler.ForLetVariable.getTypeImpl(ForLetVariable.java:84)
	at com.bea.xquery.compiler.Expression.getType(Expression.java:294)
	at com.bea.xquery.rewriting.Rule50.rewrite(Rule50.java:92)
	at com.bea.xquery.rewriting.RewritingRule.callbackTraverse(RewritingRule.java:158)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:445)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)
	at com.bea.xquery.compiler.Expression.traverse(Expression.java:458)

CONFIGURATION:
WLI 8.1 SP2

Solution

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