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

HTTP request should open only one DB connection

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.5-M3, 6.5
    • Component/s: Database
    • Labels:

      Description

      In the current state a HTTP request can open multiple JDBC connections at the same time. It requires the DB connection pool to be configured with more connections that the size of HTTP thread pool. It also books too many DB "heavy" connections comparing to the effective activity.

      The goal is that a single DB connection must be dedicated to a HTTP request. Note that in certain conditions a second connection is required for bach inserts/updates (this is a design constraint of MyBatis which requires two different sessions).
      The default settings of HTTP and DB pools must be fixed accordingly.

      Compute Engine has long-living steps and should not keep long DB connections open. The mechanism should not be changed. As a safeguard we should ensure that CE does not open two DB connections at the same time.

        Attachments

          Activity

            People

            • Assignee:
              sebastien.lesaint Sebastien Lesaint
              Reporter:
              simon.brandhof Simon Brandhof
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: