Upgrade to 5.3 or newer versions of confluence using Oracle database hangs on migrating pages batch job
Upgrading confluence in Oracle hangs and the following appears in the
DefaultSiteMigrator:thread-1 - Migration progress 40,831 of 41,341 pages (98%); 117/341 in this batch required migration.
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.
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:
- Confluence をシャットダウンします。
Add the following system property (See: Configuring System Properties):
- Confluence を再起動します。