GenericDataSourceException Due to Missing Database Validation Query Configuration
Symptoms
User may randomly receive this stacktrace:
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE FROM customfieldvalue WHERE ISSUE=? (I/O Error: Connection reset)
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:597)
at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1083)
Workflow transitions randomly stop working with the following errors occurring in the logs:
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT pkey, WORKFLOW_ID FROM jiraissue (java.lang.NullPointerException)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:464)
at com.atlassian.jira.appconsistency.integrity.check.WorkflowStateCheck.getWorkflowIdToKeyMap(WorkflowStateCheck.java:105)
at com.atlassian.jira.appconsistency.integrity.check.WorkflowStateCheck.doCheck(WorkflowStateCheck.java:54)
at com.atlassian.jira.appconsistency.integrity.check.WorkflowStateCheck.preview(WorkflowStateCheck.java:30)
at com.atlassian.jira.appconsistency.integrity.IntegrityChecker.preview(IntegrityChecker.java:63)
at com.atlassian.jira.appconsistency.integrity.IntegrityChecker.previewWithIds(IntegrityChecker.java:35)
at com.atlassian.jira.web.action.admin.IntegrityChecker.doExecute(IntegrityChecker.java:66)
at webwork.action.ActionSupport.execute(ActionSupport.java:165)
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:53)
at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:139)
at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:171)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
Cause
The database connections are being dropped due to connection closures.
Resolution
Ensure that the validation query is set as in:
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.