WARNING: You are using MySQL but do not have a validation query configured

最新推荐文章于 2024-05-25 22:39:17 发布

原创最新推荐文章于 2024-05-25 22:39:17 发布 · 211 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL #Tomcat #SQL Server #Oracle #JDBC

项目架设专栏收录该内容

12 篇文章

订阅专栏

本文介绍了解决JIRA使用MySQL时出现的数据校验查询警告问题。通过配置正确的验证查询参数，可以避免由于MySQL连接超时导致的数据损坏风险。文中提供了针对不同数据库的具体设置示例。

出现如下错误
[color=red]WARNING: You are using MySQL but do not have a validation query configured. Because of MySQL connection timeouts, this situation can cause data corruption in JIRA. For more information please see this bug report.[/color]
以下是节选自官方解决方案的方法
[url]http://confluence.atlassian.com/display/JIRA/Surviving+Connection+Closures[/url]

Setting the validationQuery parameter
In your application server, where the JDBC DataSource is configured, a parameter needs to be added to tell the Connection Pool to use a validation query (determined above) to validate connections.

JIRA Standalone (after version 3.2) or JIRA EAR/WAR on Tomcat 5.5 and Tomcat 6.0
If you are using JIRA Standalone, edit conf/server.xml
If you are using JIRA EAR/WAR on Tomcat 5.5 or Tomcat 6.0, edit conf/Catalina/localhost/jira.xml

Locate the section where the 'jdbc/JiraDS' DataSource is set up, and add the following:

· If you are using MySQL or MS SQL Server, add validationQuery="select 1"
· If you are using Oracle, add validationQuery="select 1 from dual"
· If you are using Postgres, add validationQuery="select version();"
For example (for MySQL):

<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/jiradb?useUnicode=true&characterEncoding=UTF8"
username="jirauser"
password="jirapassword"
maxActive="20"
validationQuery="select 1" />
按照以上文档所写，就是在 conf/server.xml或者新版本中的conf/Catalina/localhost/jira.xml添加以上蓝色内容即可解。只要按照文档做下来的话，一般只要加入validationQuery="select 1"这段即可。