Uploaded image for project: 'Forms'
  1. Forms
  2. FORMS-343

Java heap space when displaying the Tool that "list all the forms + the number of entries" when the size of the table if big

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Critical Critical
    • 2.15.0
    • 2.7.0
    • None
    • None

      The table is 5G and contains a lot of images.

      The request shoud perform a count instead of reading every lines.

      ==> ametys-cms-2020-06-04.log <==
      2020-06-04 17:30:17,672 ERROR [org.ametys.plugins.core.ui] (http-nio-8080-exec-10;/plugins/core-ui/servercomm/messages.xml) Can not dispatch request '0' : 'forms' 'forms-list.json' '{lang=fr, siteName=intranet, page=1, start=0, limit=25}'
      org.apache.cocoon.util.location.LocatedException: Can not dispatch request '0' : 'forms' 'forms-list.json' '{lang=fr, siteName=intranet, page=1, start=0, limit=25}'
              at org.ametys.core.ui.dispatcher.DispatchGenerator._dispatching(DispatchGenerator.java:196)
              at org.ametys.core.ui.dispatcher.DispatchGenerator.generate(DispatchGenerator.java:94)
              at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:581)
              at org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:301)
      ...
              at org.apache.cocoon.Cocoon.process(Cocoon.java:699)
              at org.ametys.runtime.servlet.RuntimeServlet.service(RuntimeServlet.java:572)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      ...
              at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
              at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
              at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
              at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
              at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
              at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
              at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
              at java.base/java.lang.Thread.run(Thread.java:834)
      Caused by: java.lang.OutOfMemoryError: Java heap space
              at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3515)
              at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3462)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3905)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
              at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1999)
              at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3413)
              at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:471)
              at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3115)
              at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2344)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2739)
              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
              at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)
              at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
              at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
              at org.ametys.plugins.forms.table.FormTableManager.getSubmissions(FormTableManager.java:327)
              at org.ametys.plugins.forms.data.GetFormsListAction.act(GetFormsListAction.java:108)
              at org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTypeNode.java:125)
              at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:47)
              at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode.invoke(MatchNode.java:108)
      ...
              at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:143)

            Unassigned Unassigned
            fravetier Frederic Ravetier (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: