Re-index fails due to ClassCastException for Timestamp types
症状
A JIRA administrator is unable to run a re-index due to ClassCastException. The following appears in the atlassian-jira.log:
java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.lang.String
at com.atlassian.jira.index.FutureResult.await(FutureResult.java:35)
at com.atlassian.jira.index.CompositeResultBuilder$CompositeResult.await(CompositeResultBuilder.java:82)
at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexAll(DefaultIndexManager.java:286)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.atlassian.util.profiling.object.ObjectProfiler.profiledInvoke(ObjectProfiler.java:81)
at com.atlassian.jira.config.component.SwitchingInvocationHandler.invoke(SwitchingInvocationHandler.java:28)
...
Caused by: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.lang.String
at com.atlassian.jira.issue.index.indexers.impl.ExactTextCustomFieldIndexer.addDocumentFields(ExactTextCustomFieldIndexer.java:45)
at com.atlassian.jira.issue.index.indexers.impl.ExactTextCustomFieldIndexer.addDocumentFieldsSearchable(ExactTextCustomFieldIndexer.java:29)
at com.atlassian.jira.issue.index.indexers.impl.AbstractCustomFieldIndexer.addIndex(AbstractCustomFieldIndexer.java:46)
at com.atlassian.jira.issue.index.IssueDocument.getDocument(IssueDocument.java:40)原因
The Search Template specified for custom fields using Date Time type is invalid. This could be caused by either a manual database manipulation or an improper upgrade.
ソリューション
- Go to Administration >> Custom Fields
- Find the custom fields of Date Time type, edit them and select one of the available options at the Search Template drop-down.
- Repeat this process for each custom field using Date Time type.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.