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

Last updated on NOVEMBER 03, 2016

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=0x000000005eb9e000 nid=0x43d1 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

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