Upgrade or Export Fails due to GenericDataSourceException Communications Link Failure
プラットフォームについて: Data Center のみ。 - This article only applies to Atlassian apps on the Data Center プラットフォーム。
この KB は Data Center バージョンの製品用に作成されています。Data Center 固有ではない機能の Data Center KB は、製品のサーバー バージョンでも動作する可能性はありますが、テストは行われていません。 Server* 製品のサポートは 2024 年 2 月 15 日に終了しました。Server 製品を実行している場合は、 アトラシアン Server サポート終了 のお知らせにアクセスして、移行オプションを確認してください。
*Fisheye および Crucible は除く
症状
The below error has been seen during the export step of an in-place upgrade. Attempting an XML backup will yield the same error.
atlassian-jira.log に次のエラーが返される。
2013-01-18 09:00:46,463 main ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Error occurred during export before upgrade: com.atlassian.core.AtlassianCoreException: Error in action: com.atlassian.jira.action.admin.DataExport@128a9b7f, result: error
Error exporting data: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem (Communications link failure
The last packet successfully received from the server was 4,478 milliseconds ago. The last packet sent successfully to the server was 171,783 milliseconds ago.). If necessary, auto-export can be disabled; see http://www.atlassian.com/software/jira/docs/latest/upgrade/autoexport.html
com.atlassian.core.AtlassianCoreException: Error in action: com.atlassian.jira.action.admin.DataExport@128a9b7f, result: error
Error exporting data: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem (Communications link failure
原因
The only known cause at this moment is due to a large database backup. JIRA may struggle communicating with the database management system while attempting to generating an XML backup of a large instance (>4 GB heap). Adding validation query as documented in Surviving Connection Closures and configuring the ulimit (Too many open files error in Jira server) will not correct this issue.
回避策
Please disable the auto-export option by setting the property, jira.autoexport=false in the $JIRAHOME/jira-config.properties file and restarting JIRA. Please make a backup using your native db tools before attempting this.
ℹ️ See Making changes to the jira-config.properties file for more information.
この内容はお役に立ちましたか?