java.util.Date can't be cast to java.sql.Timestamp - exception while upgrading
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
The following appears in the atlassian-jira.log:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
IssueIndexer:thread-3 INFO [jira.upgrade.tasks.UpgradeTask_Build646] Re-indexing is 82% complete. Current index: Issue
main ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: java.util.concurrent.ExecutionException: java.lang.ClassCastException: java.util.Date cannot be cast to java.sql.Timestamp
java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.ClassCastException: java.util.Date cannot be cast to java.sql.Timestamp
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:243)
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)
at $Proxy131.reIndexAll(Unknown Source)
at com.atlassian.jira.util.index.IndexLifecycleManager$Composite.reIndexAll(IndexLifecycleManager.java:112)
at com.atlassian.jira.upgrade.tasks.AbstractReindexUpgradeTask.doUpgrade(AbstractReindexUpgradeTask.java:43)
Also, following appears in the atlassian-jira.log:
1
main ERROR [jira.issue.managers.DefaultCustomFieldManager] Could not load custom field type plugin with key 'com.pyxis.greenhopper.jira:greenhopper-ranking'. Is the plugin present and enabled? 2011-09-22 11:34:36,335 main ERROR [jira.issue.managers.DefaultCustomFieldManager] Could not load custom field type plugin with key 'com.pyxis.greenhopper.jira:greenhopper-releasedmultiversionhistory'. Is the plugin present and enabled? 2011-09-22 11:34:36,355 main ERROR [jira.issue.managers.DefaultCustomFieldManager] Could not load custom field type plugin with key 'org.deblauwe.jira.plugin.database-values-plugin:databasevaluesselectionfield'. Is the plugin present and enabled?Cause
Some custom field records are corrupted or wrongly generated by 3rd party plugin in the database.
There are some third party plugins installed on the instance, most likely the JIRA application enhancer which are not compatible with versions of JIRA applications.
Resolution
Upgrade or disable the faulty plugin (example : JIRA application enhancer).
After this, re-index the instance. This should fix the problem.
Was this helpful?