How to fix the backup error with depreciated contents of USERSTATUS.
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
サーバー*製品のサポートは 2024 年 2 月 15 日に終了しました。サーバー製品を利用している場合は、アトラシアンのサーバー製品のサポート終了のお知らせページにて移行オプションをご確認ください。
*Fisheye および Crucible は除く
要約
Unable to perform XML backup and getting the following error message in the atlassian-confluence.log:
2020-02-18 14:00:52,792 ERROR [http-nio-8090-exec-14] [confluence.importexport.impl.AbstractXmlExporter] backupEntities Couldn't backup database data.
– referer: https://confluence.com/admin/backup.action | url: /admin/dobackup.action | ... | action: dobackup
org.hibernate.WrongClassException: Object [id=12345] was not of the specified subclass [com.atlassian.confluence.core.ContentEntityObject] : Discriminator: USERSTATUS診断
Check if there are contents with the type USERSTATUS by using the following SQL query:
SELECT contentid from CONTENT where contenttype='USERSTATUS';The result of the SQL query above should include the offending object id mentioned in the error message that you have.
原因
This error is happening due to the depreciated content type of USERSTATUS, and it needs to be deleted from the database manually to fix the issue. USERSTATUS has been deprecated since Confluence 5.8.9.
ソリューション
Delete the content from the database and fix the issue with the below steps:
- Confluence を停止します。
- Take a full backup of DB
Delete the content:
DELETE from CONTENT_LABEL where contentid = (SELECT contentid from CONTENT where contenttype='USERSTATUS'); DELETE from CONTENT where contentid = (SELECT contentid from CONTENT where contenttype='USERSTATUS');
Please always backup your database before performing any alteration in the database side.- Confluence を再起動します。
- Reindex Confluence by going to General Configuration > Content Indexing > Rebuild Index