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

Web service api/rules/search is slow when there are many Quality profiles

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.4
    • Fix Version/s: 6.4
    • Component/s: Web API
    • Labels:

      Description

      On Rebloch (ie. 6.4), calls to api/rules/search can take up to 44 seconds:

      Calls on this WS by scanner are also too slow:

      [INFO] 10:01:52.274 Load active rules
      [DEBUG] 10:02:20.669 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvXxLHCJ4b7N_3pp-e1&p=1&ps=500 | time=28395ms
      [DEBUG] 10:02:33.045 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvXz9VYJ4b7N_3pvuIX&p=1&ps=500 | time=12175ms
      [DEBUG] 10:02:35.629 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvX1iziJ4b7N_3pyfk6&p=1&ps=500 | time=2484ms
      [DEBUG] 10:02:40.539 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvX5C6rJ4b7N_3p5pMM&p=1&ps=500 | time=4908ms
      [DEBUG] 10:02:42.843 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvX2UNuJ4b7N_3pzy5H&p=1&ps=500 | time=2210ms
      [DEBUG] 10:02:43.919 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvX532CJ4b7N_3p66FP&p=1&ps=500 | time=1075ms
      [DEBUG] 10:02:53.460 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvX7DDtJ4b7N_3p9ft8&p=1&ps=500 | time=9541ms
      [DEBUG] 10:03:08.468 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvX9WmjJ4b7N_3pCcKz&p=1&ps=500 | time=14910ms
      [DEBUG] 10:03:49.080 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvYAyvtJ4b7N_3pKdUZ&p=1&ps=500 | time=40515ms
      [DEBUG] 10:03:54.519 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvYD9saJ4b7N_3pP-hV&p=1&ps=500 | time=5249ms
      [DEBUG] 10:03:55.791 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvYE9--J4b7N_3pRV3a&p=1&ps=500 | time=1178ms
      [DEBUG] 10:04:00.505 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvYFuyfJ4b7N_3pS2Xd&p=1&ps=500 | time=4714ms
      [DEBUG] 10:04:00.899 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvYGbVOJ4b7N_3pTzSZ&p=1&ps=500 | time=301ms
      [DEBUG] 10:04:05.785 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvYHFVLJ4b7N_3pVJZt&p=1&ps=500 | time=4886ms
      [DEBUG] 10:04:08.327 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvYJdTrJ4b7N_3pYZQu&p=1&ps=500 | time=2448ms
      [DEBUG] 10:04:12.560 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvYKaQcJ4b7N_3paINM&p=1&ps=500 | time=4232ms
      [DEBUG] 10:04:17.130 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvYLemRJ4b7N_3pcMqI&p=1&ps=500 | time=4569ms
      [DEBUG] 10:04:28.220 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvYOEAEJ4b7N_3phdVE&p=1&ps=500 | time=10997ms
      [DEBUG] 10:04:31.949 GET 200 https://rebloch.sonarsource.com/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt&activation=true&qprofile=AVvYMlMHJ4b7N_3peHxq&p=1&ps=500 | time=3633ms
      [INFO] 10:04:31.961 Load active rules (done) | time=159686ms
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fabrice.bellingard Fabrice Bellingard
                Reporter:
                sebastien.lesaint Sebastien Lesaint
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: