Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-61186

MySQL Pool Test Borrow error

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Unresolved
    • None
    • None
    • 0
    • 13
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      Problem Definition

      Latest dbconfig.xml for MySQL looks like below:

      <jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>mysql</database-type>
  <jdbc-datasource>
    <url>jdbc:mysql://localhost:3306/jiradb7010?useUnicode=true&amp;characterEncoding=UTF8&amp;sessionVariables=storage_engine=InnoDB</url>
    <driver-class&gt;com.mysql.jdbc.Driver</driver-class&gt;
    <username>root</username>
    <password>xxxxxxxxxx</password>
    <pool-min-size>20</pool-min-size>
    <pool-max-size>20</pool-max-size>
    <pool-max-wait>30000</pool-max-wait>
    <validation-query>select 1</validation-query>
    <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
    <time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
    <pool-max-idle>20</pool-max-idle>
    <pool-remove-abandoned>true</pool-remove-abandoned>
    <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
    <pool-test-while-idle>true</pool-test-while-idle>
    <validation-query-timeout>3</validation-query-timeout>
  </jdbc-datasource>
</jira-database-config>

      While validation query is set here, there's no <pool-test-on-borrow> set to false line. This will cause Health Checker plugin to throw error below:

      "The database configuration 'pool-test-on-borrow' is not set as per our recommended settings."

      Suggested Solution

      Add <pool-test-on-borrow>false</pool-test-on-borrow> line in the dbconfig.xml when instance with MySQL database is created.

      Workaround

      Add the <pool-test-on-borrow>false</pool-test-on-borrow> line to the dbconfig.xml manually and restart JIRA to resolve the Health Checker error.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-32882 MySQL's dbconfig.xml testOnBorrow does not default to false; need to set explicity

          • Low - Low priority issues
          • Gathering Impact

          Suggestion - JRACLOUD-61186 MySQL Pool Test Borrow error

          • Closed

          Activity

            People

              Unassigned Unassigned
              vshanmugam Vicknesh Shanmugam (Inactive)
              Votes:
              5 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated: