Confluence hangs when trying to add/manage users or during log in
プラットフォームについて: Data Center - この記事は、Data Center プラットフォームのアトラシアン製品に適用されます。
このナレッジベース記事は製品の Data Center バージョン用に作成されています。Data Center 固有ではない機能の Data Center ナレッジベースは、製品のサーバー バージョンでも動作する可能性はありますが、テストは行われていません。サーバー*製品のサポートは 2024 年 2 月 15 日に終了しました。サーバー製品を利用している場合は、アトラシアンのサーバー製品のサポート終了のお知らせページにて移行オプションをご確認ください。
*Fisheye および Crucible は除く
問題
- Confluence is backed by a Microsoft SQL Server database
- When going to Confluence Admin > Users (or 'Manage Users' on some Confluence versions), attempting to add a new user causes the application to hang (loading indefinitely)
- When logging in to Confluence, the application will hang and no longer load any pages until the browser is closed.
- In some variations of this problem, the 'Manage Users' link itself does not load. Other administration links will continue to work.
- This behavior may be cleared up temporarily by a restart of Confluence, but will return after some time
- There may not be any errors in the
atlassian-confluence.logfile
原因
Your Confluence database might not be using the recommended transaction isolation level, which is 'Read-Committed with Row Versioning', which can lead to database deadlocks.
ソリューション
Run the following on your SQL Server to determine whether you are using 'Read-Committed with Row Versioning'. Replace '<database name>' with the actual name of your Confluence database.
SELECT sd.is_read_committed_snapshot_on FROM sys.databases AS sd WHERE sd.[name] = '<database name>';If it returns '1', your database is already using the recommended isolation level. If it returns '0', please run the following to set the transaction isolation level:
ALTER DATABASE <database name> SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE;Please prepare a full database backup prior to run any query against your database.
More information on SQL Server isolation levels can be found in the Microsoft documentation.
An improvement has been implemented in Confluence 5.6.3, for more details see CONFSERVER-26296 - When using MS SQL Server, Check for 'Read-Committed with Row Versioning' transaction isolation during startup/upgrades