Huge Increase In Confluence Content Count After Upgrading To Confluence 4.3.3 and Above

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

Example:

  1. 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  15323 
  2. After 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  138897  

    Notice 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: CONF-11467 - Getting issue details... STATUS , 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.

Last modified on Feb 19, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.