Summary

Failed to upgrade to 7.1 and onwards as the cwd_user has some duplicated records. During the upgrade, an attempt is made to add unique constraint to the table, and it eventually fails with OutOfMemoryError.

Environment

6.13.10

Diagnosis

The following error appears before the upgrade is stopped:

INFO [Catalina-utility-1] [internal.upgrade.constraint.UniqueConstraintAddition] addIfMissing Constraint [cwd_user_name_dir_id] not found on table [cwd_user]. Adding it soon.

Verify if you have duplicated records with below SQL query:

SELECT lower_user_name, directory_id, count(*) 
FROM cwd_user 
GROUP BY lower_user_name, directory_id HAVING count(*) > 1;

Cause

The unique constraint added with the following bug fix on 7.1:

• Missing unique constraints and index in certain fresh Confluence installation

As the cwd_user has large duplicated records, adding the unique constraint to the table was failed.

Solution

The issue can be fixed by removing the duplicated records with the following SQL query:

DELETE FROM cwd_user 
WHERE id NOT IN (SELECT MIN(id) FROM cwd_user GROUP BY lower_user_name, directory_id);

Then, try to upgrade the Confluence again.