Upgrade to 5.3 or newer versions of confluence using Oracle database hangs on migrating pages batch job
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs 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
Symptoms
Upgrading confluence in Oracle hangs and the following appears in the atlassian-confluence.log:
1
DefaultSiteMigrator:thread-1 - Migration progress 40,831 of 41,341 pages (98%); 117/341 in this batch required migration.
Cause
The database is not able to process the batch default size which is 500 according this page. In the code, Confluence changes the number of executed threads in parallel to be 1 to avoid deadlocks when using Oracle or SQL server.
Workaround
Rollback the upgrade and modify the confluence.wiki.migration.batch.size from 500 to 1 and perform the upgrade again by following the System Properties article which specifies that we need to perform the following tasks:
Shutdown Confluence
Add the following system property (See: Configuring System Properties):
1-Dconfluence.wiki.migration.batch.size=1Restart Confluence
Was this helpful?