Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-61186

MySQL Pool Test Borrow error

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Resolved Locally
    • None

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? 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

          is related to

          Suggestion - JRASERVER-61186 MySQL Pool Test Borrow error

          • Gathering Interest

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: