When I search our Confluence System Information I find this.
Content (All Versions) | 13389 |
Content (Current Versions) | 3218 |
Then I search the database with sql:'select contenttype,count(*) from content group by contenttype' and find this
PAGE | 11674 |
BLOGPOST | 63 |
COMMENT | 394 |
DRAFT | 171 |
SPACEDESCRIPTION | 94 |
GLOBALDESCRIPTION | 1 |
USERINFO | 927 |
USERSTATUS | 1 |
SUM | 13325 |
13389 != 13325
So could anyone explain the relationship between Content (All Versions) and table content?
Hello Kai,
As far as I know, the content (all versions) doesn't this query as well, checking the entire content table and showing the sum of all contents. I can see there are a difference of 64 contents. I'm afraid there might be some corruption in the content table or there was deleted data recently and the index haven't refreshed yet.
I recommend to shutdown confluence and rebuild indexes from scratch. Then restart confluence, rebuild indexes and check for the results again.
if the issue persists, you might be facing some bug with the application or some database corruption. I recommend to get in touch with Atlassian support if you continue seeing those issues.
Cheers,
Rodrigo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.