症状

The JIRA application fails to save or display edited issues, and the following error is logged in logs:

com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:
SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM Jira_schema.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? AND PROPERTY_KEY, propertytype FROM Jira_schema.propertyentry
WHERE ENTITY_NAME=? AND ENTITY_ID=? AND PROPERTY_KEY=? (Invalid state, the Connection object is closed.)

原因

The problem is caused due to database connections being closed. Generally, this happens when:

• The server times out the connections due to inactivity
  OR
• The database server is restarted.

Corrupted database tables can cause this as well.

ソリューション

Enable connection checking by adding a validation query which the JIRA application will use when communicating with its database. For more details on how to set the validation query, see:

• Surviving Connection Closures (in the documentation for JIRA 4.4.x and later) or
• Surviving Connection Closures (in the documentation for JIRA 4.3.x and earlier)