java.util.Date can't be cast to java.sql.Timestamp - exception while upgrading

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

atlassian-jira.log に次のエラーが返される。

2011-09-22 11:45:47,273 IssueIndexer:thread-3 INFO [jira.upgrade.tasks.UpgradeTask_Build646] Re-indexing is 82% complete. Current index: Issue
2011-09-22 11:45:48,323 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:

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-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?

原因

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. 

ソリューション

  1. Upgrade or disable the faulty plugin (example : JIRA application enhancer).
  2. After this, re-index the instance. This should fix the problem.

Last modified on Mar 30, 2016

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.