Huge Increase In Confluence Content Count After Upgrading To Confluence 4.3.3 and Above
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
Symptoms
Example:
Before upgrading Confluence, you have the following stats under Confluence Usage in
Confluence Admin >> System Information:Total Spaces 61 Global Spaces 34 Personal Spaces 27 Content (All Versions) 18180 Content (Current Versions) 3819 Local Users 63525 Local Groups 167 Search Index Size 15323After the upgrade, the stats jumped to this:
Total Spaces 61 Global Spaces 34 Personal Spaces 27 Content (All Versions) 85089 Content (Current Versions) 67940 Local Users 63525 Local Groups 167 Search Index Size 138897Notice the increase in Content (All Versions), and Content (Current Versions). The increase in Search Index Size is expected, due to the increase in content count
Cause
The increase in Content count is caused by the fix for this bug: CONFSERVER-11467 - People Directory empty or not displaying the proper number of people - When users have been deleted from an External User Management , which will create content of type USERINFO, for all users, regardless of whether they have logged in to Confluence before or not. If the user does not have a row based on this query before:
SELECT * FROM CONTENT WHERE CONTENTTYPE = 'USERINFO' AND USERNAME = '<username>';Then an entry will be created for them automatically during the upgrade.