SystemItemCache テーブルが非常に速く大きくなっており、多くの行が重複しています (Doc ID 1556614.1)

Last updated on FEBRUARY 26, 2019

適用範囲:

現象

毎パブリッシュ後、SystemItemCacheテーブルが急激に大きくなっています。テーブルを調査すると、重複している行が多数あります。全ての重複行には同一blobkey値と、id列で参照される同一アセット情報があります。

大量のアセットをパブリッシュすると、システム全体が大幅に遅くなる可能性があります。スレッドダンプは、多くのスレッドがデータベースにデータを挿入しようとしている状態を示します。:

"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)

原因

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