Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-2215

Staled queries to update the user course infos

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.5.8
    • Component/s: Database
    • Labels:
      None

      Description

      WARNING: The web application [ROOT] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. Stack trace of request processing thread:
       java.net.SocketInputStream.socketRead0(Native Method)
       java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
       java.net.SocketInputStream.read(SocketInputStream.java:170)
       java.net.SocketInputStream.read(SocketInputStream.java:141)
       org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:146)
       org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:115)
       org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:71)
       org.postgresql.core.PGStream.ReceiveChar(PGStream.java:283)
       org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1719)
       org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
       org.postgresql.jdbc.PgStatement.execute(PgStatement.java:622)
       org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:472)
       org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:429)
       org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
       org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
       org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
       org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:109)
       org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:78)
       org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:445)
       org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:379)
       org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1322)
       org.hibernate.internal.QueryImpl.executeUpdate(QueryImpl.java:118)
       org.hibernate.jpa.internal.QueryImpl.internalExecuteUpdate(QueryImpl.java:371)
       org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:78)
       org.olat.course.assessment.manager.UserCourseInformationsManagerImpl.lowLevelUpdate(UserCourseInformationsManagerImpl.java:128)
       org.olat.course.assessment.manager.UserCourseInformationsManagerImpl.updateUserCourseInformations(UserCourseInformationsManagerImpl.java:138)
       org.olat.course.run.RunMainController.setLaunchDates(RunMainController.java:356)
       org.olat.course.run.RunMainController.<init>(RunMainController.java:214)
       org.olat.repository.handlers.CourseHandler$1.create(CourseHandler.java:482)
       org.olat.repository.ui.RepositoryEntryRuntimeController.launchContent(RepositoryEntryRuntimeController.java:940)
       org.olat.course.run.CourseRuntimeController.launchContent(CourseRuntimeController.java:1396)
       org.olat.repository.ui.RepositoryEntryRuntimeController.doRun(RepositoryEntryRuntimeController.java:791)
       org.olat.repository.ui.RepositoryEntryRuntimeController.<init>(RepositoryEntryRuntimeController.java:227)
       org.olat.course.run.CourseRuntimeController.<init>(CourseRuntimeController.java:200)
       org.olat.repository.handlers.CourseHandler.createLaunchController(CourseHandler.java:476)
       org.olat.course.site.CourseSiteContextEntryControllerCreator.createLaunchController(CourseSiteContextEntryControllerCreator.java:120)
       org.olat.course.site.CourseSiteContextEntryControllerCreator.createController(CourseSiteContextEntryControllerCreator.java:79)
       org.olat.NewControllerFactory.launch(NewControllerFactory.java:238)
       org.olat.NewControllerFactory.launch(NewControllerFactory.java:148)
       org.olat.repository.ui.list.RepositoryEntryListController.doOpen(RepositoryEntryListController.java:504)
       org.olat.repository.ui.list.RepositoryEntryListController.formInnerEvent(RepositoryEntryListController.java:318)
       org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:421)
       org.olat.repository.ui.list.RepositoryEntryListController.event(RepositoryEntryListController.java:401)
       org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:202)
       org.olat.core.gui.components.AbstractComponent$1.run(AbstractComponent.java:240)
       org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
       org.olat.core.gui.components.AbstractComponent.fireEvent(AbstractComponent.java:238)
       org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.fireFormEvent(FormWrapperContainer.java:148)
       org.olat.core.gui.components.form.flexible.impl.Form.fireFormEvent(Form.java:781)
       org.olat.core.gui.components.form.flexible.impl.elements.FormLinkImpl.dispatchFormRequest(FormLinkImpl.java:166)
       org.olat.core.gui.components.form.flexible.impl.FormItemImpl.doDispatchFormRequest(FormItemImpl.java:538)
       org.olat.core.gui.components.form.flexible.impl.Form.evalFormRequest(Form.java:304)
       org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.doDispatchRequest(FormWrapperContainer.java:103)
       org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
       org.olat.core.gui.components.Window.doDispatchToComponent(Window.java:1143)
       org.olat.core.gui.components.Window.dispatchRequest(Window.java:356)
       org.olat.core.gui.components.Window.doDispatchRequest(Window.java:240)
       org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
       org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:275)
       org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:192)
       org.olat.core.servlets.OpenOLATServlet.executeUserRequest(OpenOLATServlet.java:289)
       org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:232)
       javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
       org.olat.core.servlets.OpenOLATServlet.service(OpenOLATServlet.java:175)
       javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
       org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
       org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
       org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
       org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
       org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
       org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
       org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
       org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
       org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
       org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
       org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:521)
       org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:850)
       org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)
       org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1074)
       org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.run(Nio2Endpoint.java:1033)
       java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
       java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
       org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
       java.lang.Thread.run(Thread.java:745)
      

      Testing

      • Make sure course launch still works:
      • Open course as first-time user
      • Open course again

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            srosse Stéphane Rossé
            Tester:
            Sabrina Scheiwiler (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 5 minutes
                1h 5m