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

MySQL Pool Test Borrow error

XMLWordPrintable

    • 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.

      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.

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

                Created:
                Updated:
                Resolved: