The following database configurations are not set as per our recommended settings: 'pool-remove-abandoned, pool-remove-abandoned-timeout, validation-query-timeout, min-evictable-idle-time-millis, time-between-eviction-runs-millis, pool-test-on-borrow, p..

The following database configurations are not set as per our recommended settings: 'pool-remove-abandoned, pool-remove-abandoned-timeout, validation-query-timeout, min-evictable-idle-time-millis, time-between-eviction-runs-millis, pool-test-on-borrow, pool-test-while-idle'.

jira 7.x.x 로 업그레이드 되면서 DB에 에러가 발생이 된다.

dbconfig.xml 파일을 수정해서

<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>com.mysql.jdbc.Driver</driver-class>

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

빨간색 항목을 추가해 주자 그러면 에러가 없어진다.