問題

Collaborative Editing does not work due to Stored AppID is missing from the DB. Even after restarting Synchrony or reenabling Collaborative Editing, the issue persists and pages can't be created or edited.

環境

Confluence 7.2.1, 7.4.2

診断

エラー

You will see the following error in the atlassian-confluence.log:

2020-08-07 04:36:20,042 ERROR [http-nio-8090-exec-40] [synchrony.api.v1.SynchronyTokenResource] generateToken Stored AppID is null, this instance may not have been configured.

データベース

Check if AppID exists on the following tables:

select * FROM BANDANA where bandanakey like '%synchrony_collaborative%' order by bandanakey;
select * FROM "SECRETS";

The AppID would look like the following:

synchrony_collaborative_editor_app_id	<string>Synchrony-e8880686-c3f5-3b52-a39c-0ca91c65ce3f</string>
synchrony_collaborative_editor_app_secret	<string>aEev0jWWApE2qnHeLtVjCUnEJKkBeZ8lbJPyWf0TlLs=</string>

If the AppID does not exist in the above outputs, Collaborative Editing will be fail with the above error.

原因

We cannot confirm what caused the missing AppID, but it should be recreated when Collaborative Editing is reenabled. But we found that the AppID is not created, if the below flag is set as true when we turn off Collaborative Editing:

synchrony_collaborative_editor_app_registered <string>true</string> 

ソリューション

1. Disable Collaborative Editing
2. Stop the Confluence

3. Clear all AppID related values and Synchrony data in the DB:

   DELETE FROM bandana WHERE bandanakey = 'synchrony_collaborative_editor_app_registered'
            OR bandanakey = 'synchrony_collaborative_editor_app_secret'
            OR bandanakey = 'synchrony_collaborative_editor_app_id';
   
   TRUNCATE TABLE "EVENTS";
   TRUNCATE TABLE "SECRETS";
   TRUNCATE TABLE "SNAPSHOTS";

4. Confluence を起動します。
5. Enable Collaborative Editing