Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-11881

Fail to refresh a portfolio on Oracle if it contains more than 1'000 projects

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.7.6, 7.7
    • Fix Version/s: 7.8
    • Component/s: Database
    • Labels:
      None
    • Edition:
      Enterprise
    • Production Notes:
      None

      Description

      ### Cause: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000 at 
      org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at 
      org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150) at 
      org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) at 
      org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) at 
      org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) at com.sun.proxy.$Proxy76.countByStatusAndMainComponentUuids(Unknown Source) at 
      org.sonar.db.ce.CeQueueDao.lambda$countByStatusAndMainComponentUuids$2(CeQueueDao.java:160) at 
      org.sonar.db.DatabaseUtils.executeLargeUpdates(DatabaseUtils.java:168) at org.sonar.db.DatabaseUtils.executeLargeUpdates(DatabaseUtils.java:149) at 
      org.sonar.db.ce.CeQueueDao.countByStatusAndMainComponentUuids(CeQueueDao.java:157) at org.sonar.ce.queue.CeQueueImpl$NoPendingTaskFilter.<init>
      (CeQueueImpl.java:171) at org.sonar.ce.queue.CeQueueImpl$NoPendingTaskFilter.<init>(CeQueueImpl.java:167) at 
      org.sonar.ce.queue.CeQueueImpl.filterBySubmitOptions(CeQueueImpl.java:161) at org.sonar.ce.queue.CeQueueImpl.massSubmit(CeQueueImpl.java:139) at 
      com.A.B.C.B.A.A(Unknown Source) at com.A.B.L.A.D.A(Unknown Source) at com.A.B.L.A.D.handle(Unknown Source)
      

      The bug is in CeQueueDao#countByStatusAndMainComponentUuids(). It does not paginate input.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                simon.brandhof Simon Brandhof
                Reporter:
                alexandre.frigout Alexandre Frigout
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: