My Oracle Support Banner

Memory Leak Caused by QueryDependency with SiteConfigurations (Doc ID 2192947.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle Commerce Platform - Version 11.2 and later
Information in this document applies to any platform.

Symptoms

The memory usage may reach to nearly 100% within as short as a day. The heap analysis shows "atg.repository.query.QueryDependency" as top dominator component which holds huge number of SiteConfiguration objects as shown below:

Class Name         Objects   Shallow Heap   Retained Heap
---------------------------------------------------------------------------------------
QueryDependency  86               2,752           >= 368,602,832
---------------------------------------------------------------------------------------

The top QueryDependency object has more than 1M objects in its cache entry. The object belongs to SiteConfiguration item descriptor.

Changes

Prior to 11.2

siteConfiguration has query-cache-size is set to "1000":

<item-descriptor expert="false" last-modified-property="modificationTime" id-separator=":" display-name-resource="itemDescriptorSiteConfiguration" writable="true" cache-mode="simple" content="false" folder="false" default="true" query-cache-size="1000" hidden="false" name="siteConfiguration" display-property="name" use-id-for-path="false" item-cache-size="1000">
<attribute name="plural-display-name-resource" value="itemDescriptorSiteConfiguration.plural"/>
<attribute name="resourceBundle" value="atg.multisite.SiteRepositoryTemplateResources"/>
<attribute name="categoryBasicsPriority" value="110"/>
<attribute name="categoryLifePriority" value="120"/>
<attribute name="categoryHistoryPriority" value="130"/>
<attribute name="updateLastModified" value="true"/>
<attribute name="flexIconResource" value="iconSwf.siteConfiguration.small"/>
<attribute name="largeFlexIconResource" value="iconSwf.siteConfiguration.large"/>
...
</item-descriptor>

In 11.2

siteConfiguration is a sub-type of touchpoint, but the query-cache-size is not set:

<item-descriptor display-name-resource="itemDescriptorSiteConfiguration" expert="false" hidden="false" use-id-for-path="false" sub-type-value="siteConfiguration" content="false" writable="true" default="true" folder="false" cache-mode="simple" id-separator=":" name="siteConfiguration" super-type="touchpoint">
<attribute name="plural-display-name-resource" value="itemDescriptorSiteConfiguration.plural"/>
<attribute name="resourceBundle" value="atg.multisite.SiteRepositoryTemplateResources"/>
<attribute name="categoryBasicsPriority" value="110"/>
<attribute name="categoryLifePriority" value="120"/>
<attribute name="categoryHistoryPriority" value="130"/>
<attribute name="updateLastModified" value="true"/>
<attribute name="flexIconResource" value="iconSwf.siteConfiguration.small"/>
<attribute name="largeFlexIconResource" value="iconSwf.siteConfiguration.large"/>
...
</item-descriptor>

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
Changes
Cause
Solution
 Workaround
References


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