問題

Attempting to edit the page after enabling Collaborative Editing , but it fails, looking at the atlassian-confluence.log file we will notice the below errors:

Caused by: org.postgresql.util.PSQLException: ERROR: relation \"SECRETS\" does not exist

INFO [ListenableFutureAdapter-thread-3] [plugins.synchrony.config.DefaultSynchronyConfigurationManager] postConfigToSynchrony [Collab editing plugin] Synchrony response (500): Could not verify  AppID/Secret for real-time collaboration service at endpoint: http://127.0.0.1:8091/synchrony/v1/apps/secret 

原因

Synchrony tables related tables i.e., EVENTS, SNAPSHOTS and SECRETS are in lower case.

ソリューション

 Please ensure to take necessary Database and Confluence Instance backup prior to running the steps below. Note that the below query is applicable for Postgres, please work with your DBA to amend the queries as per the Database in use.

• Take a backup of your Postgress DB
• Switch Collaborative Editing to OFF.
• Shutdown Confluence Instance (all nodes if using Data Center)
• Alter the three tables to have UPPERCASE names:

ALTER TABLE public."snapshots" RENAME TO "SNAPSHOTS";
ALTER TABLE public."events" RENAME TO "EVENTS";
ALTER TABLE public."secrets" RENAME TO "SECRETS";

•  Cleanup the table entries by running the below query

TRUNCATE TABLE "EVENTS"; 
TRUNCATE TABLE "SECRETS"; 
TRUNCATE TABLE "SNAPSHOTS";

• Cleanup bandana to start to register the Synchrony service:

delete from bandana where bandanakey = 'synchrony_collaborative_editor_app_registered' 
or bandanakey = 'synchrony_collaborative_editor_app_secret'
or bandanakey = 'synchrony_collaborative_editor_app_id';

• Start Confluence and switch Collaborative Editing to ON again.