When migrating from database to file system storage for attachments, Confluence appears to hang
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
問題
When migrating from Database Attachment Storage to Filesystem Attachment storage, you may notice that the progress bar will hang at 99% or 100; with no error message in the logs.
診断
Check the Disk IO and CPU activity of Confluence and your Database Process - if Confluence is idle, and the database is experiencing activity, Confluence is likely removing data from the attachments table. Depending on the number of attachments, this process may take a while.
原因
After Confluence extracts the binary information from the attachment data in the database, it will delete the contents of the attachmentdata table with the query DELETE FROM ATTACHMENTDATA.
回避策
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。
- Shut down Confluence, and take a full database backup
- If a long running DELETE query is running in your database, use your administrative tools to stop it
Execute the following SQL:
TRUNCATE TABLE ATTACHMENTDATA- Start Confluence again
ソリューション
Wait for the process to complete.