Affects Version/s: 5.7, 5.7.3, 5.8.4
Fix Version/s: 6.0.5
Component/s: Server - Administration
Support reference count:53
This bug report relates to warnings logged by the Database Constraint Checker which was introduced in Confluence 5.7.
This particular warning occurs because there is a column included in an index that Confluence was not expecting.
This warning has been encountered on these columns:
These warnings appear in the logs:
A composite index is an index created on multiple columns. When all the columns in an index are specified in a query (and in the same order as the index), there is no impact. However, if a query makes use of only a few of the columns, the index will be ignored, and a sequential search will be performed. In large databases, this can be a performance hit.
In some cases, indexes are created on combinations of columns that do see realistic use. For example, space permissions are queried by group name, or by username - but never by both at the same time. Thus an index on both the permgroupname and permusername columns would not provide any improvement, and could actually cause a decrease in performance in certain scenarios.
To resolve these warnings, you will need to change the schema of your database to specify that each column should be nullable. The way you would achieve this varies across each database system, so refer to the official documentation for your database.
To resolve these warnings, you should drop the mentioned index, and re-create it. The syntax will depend on your particular database variety, but generally the following should work:
Next, allow Confluence to recreate the index. Add -Datlassian.forceSchemaUpdate=true to your JVM Arguments and restart Confluence. On the next restart, Confluence will recreate any indexes that are missing.
Confluence will note that the index has been dropped, with a similar warning message:
If the flag is enabled, Confluence will generate a recovery file, and then repair the schema. You can use your database tools to verify that the specified index has been re-created.
Please feel free to contact Support for help with this.