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

RS: Admin search all courses

    XMLWordPrintable

    Details

      Description

      A lion occurs when searching learning resources:

      message:org.hibernate.exception.JDBCConnectionException: could not extract ResultSet,javax.persistence.PersistenceException
      
      at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
      at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1535)
      at org.hibernate.query.Query.getResultList(Query.java:165)
      at org.olat.core.commons.services.license.manager.ResourceLicenseDAO.loadLicenses(ResourceLicenseDAO.java:120)
      at org.olat.core.commons.services.license.manager.LicenseServiceImpl.loadLicenses(LicenseServiceImpl.java:130)
      at org.olat.repository.ui.author.AuthoringEntryDataSource.processViewModel(AuthoringEntryDataSource.java:159)
      at org.olat.repository.ui.author.AuthoringEntryDataSource.getRows(AuthoringEntryDataSource.java:134)
      
      message:Tried to send an out-of-range integer as a 2-byte value: 32769,java.io.IOExceptionat org.postgresql.core.PGStream.sendInteger2(PGStream.java:266)
      at org.postgresql.core.v3.QueryExecutorImpl.sendParse(QueryExecutorImpl.java:1500)
      
      

      The cause seems to be this query:

      select license from license license inner join fetch license.licenseType as licenseType where license.resName in (:resNames) and license.resId in (:resIds_0, :resIds_1, :resIds_2, :resIds_3, .... :resIds_32767).

      I found this comment: At least I can tell there is a technical limit of 32767 values (=Short.MAX_VALUE) (https://stackoverflow.com/questions/1009706/postgresql-max-number-of-parameters-in-in-clause)

      So it seems that a large number of resources exceeds this limit.

       

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            stephan Stephan Clemenz
            Tester:
            Mandy Menzel
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: