My Oracle Support Banner

SystemItemCache table is growing at an extremely rapid rate, many rows are duplicates (Doc ID 1499835.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle WebCenter Sites - Version 6.3.0 to 7.6.2 [Release FatWire]
Information in this document applies to any platform.

Symptoms

Every time after a publish, the SystemItemCache table grows at an alarmingly fast rate. Upon inspecting the table, there are many rows that are duplicates. All of the duplicate rows have the same blobkey value and the same asset referenced in the id column.

If a large publish is executed, the entire system appears to slow down considerably. Thread dumps show many threads are trying to insert into the database:

"cat-exec-105" daemon prio=10 tid=<TID> nid=<NID> runnable [0x000000004e511000]
java.lang.Thread.State: RUNNABLE
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:194)
at java.io.FileOutputStream.<init>(FileOutputStream.java:145)
at COM.FutureTense.Util.d.A(y:3151)
at COM.FutureTense.Util.d.J(y:2676)
at COM.FutureTense.Platform.NONE.I.A(y:1091)
at COM.FutureTense.Platform.NONE.F.A(y:3458)
at COM.FutureTense.Platform.NONE.B.A(y:1465)
at COM.FutureTense.Platform.NONE.B.A(y:3147)
at COM.FutureTense.Platform.NONE.B.A(y:849)
at COM.FutureTense.Common.K.killCacheHash(y:1615)
at COM.FutureTense.Common.g.insertRow(y:865)
at COM.FutureTense.Cache.J.A(y:1904)
at COM.FutureTense.Cache.J.A(y:2442)
at COM.FutureTense.Cache.F.B(y:2112)
at COM.FutureTense.Cache.F.A(y:1)
at COM.FutureTense.Common.j.A(y:2102)
at COM.FutureTense.Common.j.A(y:2197)
at COM.FutureTense.Common.j$_A.doWork(y:2879)
at com.fatwire.cs.core.util.KeyThrottle.execute(y:2547)
- locked <0x00000007742905f8> (a java.lang.Object)
at COM.FutureTense.Common.j.evalPage(y:2454)
at COM.FutureTense.Common.j.execute(y:2757)
at COM.FutureTense.Servlet.FTServlet.execute(y:1088)
at COM.FutureTense.Servlet.FTServlet.doGet(y:2917)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:509)
at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:448)
at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:399)
at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2154)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

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.