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

Users belonging to 1001+ groups cannot login (Oracle)

    XMLWordPrintable

    Details

      Description

      When using an Oracle database, any user belonging to strictly more than 1000 groups cannot login.

      Failure in server logs ( login_failure.txt ):

      2016.02.22 16:22:48 ERROR web[o.s.s.ui.JRubyFacade] Fail to render: http://192.168.56.10:9053/
      ActiveRecord::JDBCError: ORA-01795: maximum number of expressions in a list is 1000
      

      Environment ( sys_info.json attached):

      • Seen on SonarQube 4.5.6 , reproduced on 5.3
      • Test done with Oracle 11G

      Reproduction:

      • pick an existing user or create a new one
      • WS loop:
        for i in `seq 1 990`; do curl -u admin:admin -X POST 'http://<ip:port>/api/user_groups/create?name=group'$i && curl -u admin:admin -X POST 'http://<ip:port>/api/user_groups/add_user?name=group'$i'&login=john' ; done
        
      • check /api/users/groups?login=john&ps=1200 to make sure how much groups it actually belongs to
      • if the number of groups is less or equal to 1000: login is possible
      • if the number of groups is strictly more than 1000: login fails

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              julien.lancelot Julien Lancelot
              Reporter:
              nicolas.bontoux Nicolas Bontoux
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: