Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-20284

Common db datasource template should take into account nuxeo.db.min-pool-size and nuxeo.db.idle-timeout-minutes

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 6.0-HF30, 7.10-HF13
    • Fix Version/s: 6.0-HF31, 7.10-HF15
    • Component/s: Configuration

      Description

      The template located at:
      nuxeo-distribution/nuxeo-distribution-resources/src/main/resources/templates-tomcat/common-base/nxserver/config/datasources-config.xml.nxftl

      uses hardcoded value for:
      minPoolSize="5"

      wherehas it reads config for:

      maxPoolSize="${nuxeo.db["max-pool-size"]}"

      It does not take into account:
      idleTimeoutMinutes
      (it lacks 

      idleTimeoutMinutes="${nuxeo.db["idle-timeout-minutes"]}"

      as found in master).

      These two values (minPoolSize and idleTimeoutMinutes) have been tested in 6.0, and are propagated to instantiated objects correctly. Clean up of idle connections is also working as expected.

      For the rest of values as found in template file on master, they would need to be evaluated, if they actually work on 6.0/7.10, before backporting.

        Attachments

          Issue Links

          depends on

          Bug - A problem which impairs or prevents the functions of the product. NXP-19541 validationQuery is not taken in account by the connection pool

          • Major - Major loss of function.
          • Resolved
          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-19724 backport validation query fixup in 7.10

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-19723 backport validation query fixup on 6.0

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Task - A task that needs to be done. NXS-3484 Upgrade Studio to 6.0 HF31

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: