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

Last updated on FEBRUARY 28, 2022

Applies to:

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

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