出现如下错误
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.
以下是节选自官方解决方案的方法
http://confluence.atlassian.com/display/JIRA/Surviving+Connection+Closures
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"这段即可。
分享到:
相关推荐
一步步教你如何BW建模,非常简单清楚,很好用的BW入门资料
Maven坐标:jakarta.validation:jakarta.validation-api:2.0.1; 标签:jakarta、validation、api、中英对照文档、jar包、java; 使用方法:解压翻译后的API文档,用浏览器打开“index.html”文件,即可纵览文档内容...
Maven坐标:jakarta.validation:jakarta.validation-api:2.0.2; 标签:api、jakarta、validation、jar包、java、中文文档; 使用方法:解压翻译后的API文档,用浏览器打开“index.html”文件,即可纵览文档内容。 ...
Each project is fully illustrated, so you will see clearly what you are building as you create your own database-driven website. You will build a form for registering users, and then build an ...
Setting Up Slicers (but Only if You Have Excel 2010 or Later) Chanaing pivot Table 1avout Changing Pivot lable Layout Ac0lng a alL Adding Conditional Formatting Troubleshooting Pivot Tables summary ...
Webmail Applications Are Not E-mail Applications 331 Socket Programming 331 Introduction to Sockets 332 Try It Out: Connecting to the SuperSimpleSocketServer with Telnet 333 02_596543 ftoc.qxd 6/...
Maven坐标:jakarta.validation:jakarta.validation-api:2.0.1; 标签:jakarta、validation、api、中文文档、jar包、java; 使用方法:解压翻译后的API文档,用浏览器打开“index.html”文件,即可纵览文档内容。 ...
It can be remarkably hard to design a good communications protocol, much harder even than it is to write a normal sequential program. Unfortunately, when the design of a new protocol is complete, we ...
ICS V7 is a stable release that may still be updated for major bugs, but not for new releases of Delphi, latest it supported was XE3. ICS V8 is the current development release which is held in a ...
Maven坐标:javax.validation:validation-api:2.0.1.Final; 标签:javax、api、validation、jar包、java、API文档、中文版; 使用方法:解压翻译后的API文档,用浏览器打开“index.html”文件,即可纵览文档内容。 ...
But if you can't (existing format, enterprise rules, ...), you may have a look at AsmXml. This library is not for kids ! you have to know how to use an object file with your programming language. ...
validation-api-1.0.0.GA.jar
and we’ll generate a controller which will be used to view and manage the example project’s events.You’ll also learn howhow to use Laravel’s Query Builder to query the database when Eloquent isn...
datasource: primary: url: jdbc:mysql://localhost/primary username: root driver-class-name: com.mysql.jdbc.Driver validation-query: select 1 secondary: url: jdbc:mysql://localhost/secondary ...
赠送jar包:validation-api-1.1.0.Final.jar; 赠送原API文档:validation-api-1.1.0.Final-javadoc.jar; 赠送源代码:validation-api-1.1.0.Final-sources.jar; 包含翻译后的API文档:validation-api-1.1.0....
You will also get experience in error handling and data validation while working on this site. ❑ Comic Book Fan Web site. The creation of this Web site takes you through the steps of building ...
Maven坐标:javax.validation:validation-api:2.0.1.Final; 标签:javax、api、validation、jar包、java、API文档、中英对照版; 使用方法:解压翻译后的API文档,用浏览器打开“index.html”文件,即可纵览文档...
• If you are uncertain about any installation steps or have a problem related to the use of the product, please consult a certified computer technician. • If you use an adapter, extension power...
An Improved Aggregated One-Dependence Estimator:On Not So Rigid Cross Validation,郑庆华,,The naive Bayesian classifier is a simple and effective approach to classifier learning. However, its ...
If you are a CakePHP developer who wants to discover quick and easy ways to improve web applications, and to leverage all aspects of the framework, this book is for you. This book assumes that you ...