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

OnlyOffice thumbnail service may lead to RS

    XMLWordPrintable

    Details

      Description

      If the OnlyOffice thumbnail service does not respond fast enough, this can lead to RS because all database connections are occupied. To prevent this we implement two solutions.

      Solution 1: Configuration of the OnlyOffice HTTP connection timeout in olat.local.properties:

      • onlyoffice.http.connect.timeout
      • onlyoffice.http.connect.request.timeout
      • onlyoffice.http.connect.socket.timeout

      Solution 2: More commit statements to release the database connections earlier.

      This was the RS:

      at java.net.SocketInputStream.socketRead0(java.base@11.0.9.1/Native Method)       at java.net.SocketInputStream.socketRead(java.base@11.0.9.1/SocketInputStream.java:115)       at java.net.SocketInputStream.read(java.base@11.0.9.1/SocketInputStream.java:168)       at java.net.SocketInputStream.read(java.base@11.0.9.1/SocketInputStream.java:140)       at sun.security.ssl.SSLSocketInputRecord.read(java.base@11.0.9.1/SSLSocketInputRecord.java:476)       at sun.security.ssl.SSLSocketInputRecord.readHeader(java.base@11.0.9.1/SSLSocketInputRecord.java:470)       at sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(java.base@11.0.9.1/SSLSocketInputRecord.java:70)       at sun.security.ssl.SSLSocketImpl.readApplicationRecord(java.base@11.0.9.1/SSLSocketImpl.java:1354)       at sun.security.ssl.SSLSocketImpl$AppInputStream.read(java.base@11.0.9.1/SSLSocketImpl.java:963)       at org.apache.http.impl.io.SessionInputBufferImpl.streamRead(SessionInputBufferImpl.java:137)       at org.apache.http.impl.io.SessionInputBufferImpl.fillBuffer(SessionInputBufferImpl.java:153)       at org.apache.http.impl.io.SessionInputBufferImpl.readLine(SessionInputBufferImpl.java:280)       at org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead(DefaultHttpResponseParser.java:138)       at org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead(DefaultHttpResponseParser.java:56)       at org.apache.http.impl.io.AbstractMessageParser.parse(AbstractMessageParser.java:259)       at org.apache.http.impl.DefaultBHttpClientConnection.receiveResponseHeader(DefaultBHttpClientConnection.java:163)       at org.apache.http.impl.conn.CPoolProxy.receiveResponseHeader(CPoolProxy.java:157)       at org.apache.http.protocol.HttpRequestExecutor.doReceiveResponse(HttpRequestExecutor.java:273)       at org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.java:125)       at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:272)       at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:186)       at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89)       at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:110)       at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185)       at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83)       at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:108)       at org.olat.core.commons.services.doceditor.onlyoffice.manager.OnlyOfficeConversionServiceImpl.sendCreateThumbnailRequest(OnlyOfficeConversionServiceImpl.java:176)       at org.olat.core.commons.services.doceditor.onlyoffice.manager.OnlyOfficeConversionServiceImpl.tryCreateThumbnail(OnlyOfficeConversionServiceImpl.java:147)       at org.olat.core.commons.services.doceditor.onlyoffice.manager.OnlyOfficeConversionServiceImpl.createThumbnail(OnlyOfficeConversionServiceImpl.java:98)       at org.olat.core.commons.services.doceditor.onlyoffice.manager.OnlyOfficeThumbnailSPI.generateThumbnail(OnlyOfficeThumbnailSPI.java:71)       at org.olat.core.commons.services.thumbnail.impl.ThumbnailServiceImpl.generateThumbnail(ThumbnailServiceImpl.java:85)       at org.olat.core.commons.services.vfs.manager.VFSRepositoryServiceImpl.generateThumbnail(VFSRepositoryServiceImpl.java:740)       at org.olat.core.commons.services.vfs.manager.VFSRepositoryServiceImpl.getThumbnail(VFSRepositoryServiceImpl.java:699)       at org.olat.core.commons.modules.bc.commands.CmdServeThumbnailResource.execute(CmdServeThumbnailResource.java:73)       at org.olat.core.commons.modules.bc.FolderRunController.event(FolderRunController.java:456)       at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:214)       at org.olat.core.gui.components.AbstractComponent$1.run(AbstractComponent.java:240)       at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
      

       

       

        Attachments

          Activity

            People

            uhensler Urs Hensler
            srosse Stéphane Rossé
            Mandy Menzel Mandy Menzel
            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 - 30 minutes
                30m