How to disable the content re-migration job on startup
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. 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.
*Except Fisheye and Crucible
Purpose
Because of a fix in Confluence 5.7.4 ( CONF-35004 ), each restart following a plugin update/upgrade/install triggers a job to re-migrate "unmigrated" pages, which includes pages that have unknown macros. These pages will get re-migrated again if any plugins are updated/enabled/re-enabled and followed by a restart. This creates additional entries in the change histories of the "re-migrated" pages, and can have a possible performance impact since attachments on such re-migrated pages are then re-indexed.
Solution
For Confluence 5.10.7 and below
You can disable the remigration job via SQL.
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Before every Confluence startup, run the following query to determine whether the content remigration job will be triggered:
SELECT * FROM BANDANA WHERE BANDANAKEY = 'migration.required';If the "bandanavalue" column shows "true", then update this to "false" to prevent the startup from starting the re-migration job.
UPDATE BANDANA SET BANDANAVALUE = '<boolean>false</boolean>' WHERE BANDANAKEY = 'migration.required';
This value should be checked on every restart because the aforementioned plugin operations may set the "migration.required" value back to "true".
For Confluence 5.10.8 and above
A system variable was added to enable/disable remigration behavior during startup. To use this feature:
- Open CONF_INSTALL_FOLDER/bin/setenv.sh (or setenv.bat under Windows)
Locate "CATALINA_OPTS" and add the following line to the file:
CATALINA_OPTS="-Dconfluence.startup.remigration.disable=true $ {CATALINA_OPTS}"- Save the file and restart Tomcat