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

Fix default value of property sonar.jdbc.maxActive

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.0
    • Component/s: Database
    • Labels:
      None

      Description

      Pools are badly configured by default. 50 HTTP requests are accepted (see sonar.web.http.maxThreads) but they are backed by only 20 JDBC connections (see sonar.jdbc.maxActive). Most of HTTP requests need a JDBC connection, for example to authenticate user. Moreover two daemon processes need to open JDBC connections too (email notification + compute engine). So 18 concurrent HTTP requests lock all the JDBC connections and the 19th request fails.
      For this reason I suggest to set sonar.jdbc.maxActive=50 (which is the default value of "sonar.web.http.maxThreads").

        Attachments

          Activity

            People

            • Assignee:
              simon.brandhof Simon Brandhof (Inactive)
              Reporter:
              simon.brandhof Simon Brandhof (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: