2015-02-18 16:21:47,586 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Database schema is inconsistent with expectations - %s warnings, see below
2015-02-18 16:21:47,587 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [idx_app_dir_group_mapping] of table [cwd_app_dir_group_mapping] is missing; expected [Index cwd_app_dir_group_mapping.idx_app_dir_group_mapping on
[app_dir_mapping_id] non-unique]
2015-02-18 16:21:47,587 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [idx_app_dir_group_app] of table [cwd_app_dir_group_mapping] is missing; expected [Index cwd_app_dir_group_mapping.idx_app_dir_group_app on [applic
ation_id] non-unique]
2015-02-18 16:21:47,587 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [follower] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.follower varchar2(255) nullable] and a
ctual [Column follow_connections.follower varchar2(255) non-nullable]
2015-02-18 16:21:47,587 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [followee] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.followee varchar2(255) nullable] and a
ctual [Column follow_connections.followee varchar2(255) non-nullable]
2015-02-18 16:21:47,588 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [sp_comp_idx] of table [spacepermissions] has mismatched definitions for expected [Index spacepermissions.sp_comp_idx on [permtype, permgroupname]
non-unique] and actual [Index spacepermissions.sp_comp_idx on [permtype, permgroupname, permusername] non-unique]
2015-02-18 16:21:47,588 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [sp_creator_idx] of table [spacepermissions] is missing; expected [Index spacepermissions.sp_creator_idx on [creator] non-unique]
2015-02-18 16:21:47,588 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [sp_lastmodifier_idx] of table [spacepermissions] is missing; expected [Index spacepermissions.sp_lastmodifier_idx on [lastmodifier] non-unique]
2015-02-18 16:21:47,588 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [idx_user_cred_record_user_id] of table [cwd_user_credential_record] is missing; expected [Index cwd_user_credential_record.idx_user_cred_record_us
er_id on [user_id] non-unique]
2015-02-18 16:21:47,588 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [tbl_lastmodifier_idx] of table [trackbacklinks] is missing; expected [Index trackbacklinks.tbl_lastmodifier_idx on [lastmodifier] non-unique]
2015-02-18 16:21:47,589 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [tbl_creator_idx] of table [trackbacklinks] is missing; expected [Index trackbacklinks.tbl_creator_idx on [creator] non-unique]
2015-02-18 16:21:47,589 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [idx_mem_dir_child_user] of table [cwd_membership] is missing; expected [Index cwd_membership.idx_mem_dir_child_user on [child_user_id] non-unique]
2015-02-18 16:21:47,590 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [cp_creator_idx] of table [content_perm] is missing; expected [Index content_perm.cp_creator_idx on [creator] non-unique]
2015-02-18 16:21:47,590 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [cp_lastmodifier_idx] of table [content_perm] is missing; expected [Index content_perm.cp_lastmodifier_idx on [lastmodifier] non-unique]
2015-02-18 16:21:47,590 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [cl_owner_idx] of table [content_label] is missing; expected [Index content_label.cl_owner_idx on [owner] non-unique]
2015-02-18 16:21:47,591 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [idx_app_dir_dir] of table [cwd_app_dir_mapping] is missing; expected [Index cwd_app_dir_mapping.idx_app_dir_dir on [directory_id] non-unique]
2015-02-18 16:21:47,591 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [idx_app_dir_app] of table [cwd_app_dir_mapping] is missing; expected [Index cwd_app_dir_mapping.idx_app_dir_app on [application_id] non-unique]
2015-02-18 16:21:47,591 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [links_creator_idx] of table [links] is missing; expected [Index links.links_creator_idx on [creator] non-unique]
2015-02-18 16:21:47,591 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [links_lastmodifier_idx] of table [links] is missing; expected [Index links.links_lastmodifier_idx on [lastmodifier] non-unique]
2015-02-18 16:21:47,591 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [c_parentccid_idx] of table [content] is missing; expected [Index content.c_parentccid_idx on [parentccid] non-unique]
2015-02-18 16:21:47,592 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [c_lastmodifier_idx] of table [content] is missing; expected [Index content.c_lastmodifier_idx on [lastmodifier] non-unique]
2015-02-18 16:21:47,592 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [el_lastmodifier_idx] of table [extrnlnks] is missing; expected [Index extrnlnks.el_lastmodifier_idx on [lastmodifier] non-unique]
2015-02-18 16:21:47,592 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [el_creator_idx] of table [extrnlnks] is missing; expected [Index extrnlnks.el_creator_idx on [creator] non-unique]
2015-02-18 16:21:47,592 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [s_creator_idx] of table [spaces] is missing; expected [Index spaces.s_creator_idx on [creator] non-unique]
2015-02-18 16:21:47,592 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [s_lastmodifier_idx] of table [spaces] is missing; expected [Index spaces.s_lastmodifier_idx on [lastmodifier] non-unique]
2015-02-18 16:21:47,593 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [n_creator_idx] of table [notifications] is missing; expected [Index notifications.n_creator_idx on [creator] non-unique]
2015-02-18 16:21:47,593 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [n_lastmodifier_idx] of table [notifications] is missing; expected [Index notifications.n_lastmodifier_idx on [lastmodifier] non-unique]
2015-02-18 16:21:47,593 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [n_labelid_idx] of table [notifications] is missing; expected [Index notifications.n_labelid_idx on [labelid] non-unique]
2015-02-18 16:21:47,593 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [n_username_idx] of table [notifications] is missing; expected [Index notifications.n_username_idx on [username] non-unique]
2015-02-18 16:21:47,593 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [n_contentid_idx] of table [notifications] is missing; expected [Index notifications.n_contentid_idx on [contentid] non-unique]
2015-02-18 16:21:47,594 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [spacegroups_lastmodifier_idx] of table [spacegroups] is missing; expected [Index spacegroups.spacegroups_lastmodifier_idx on [lastmodifier] non-un
ique]
2015-02-18 16:21:47,594 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [spacegroups_creator_idx] of table [spacegroups] is missing; expected [Index spacegroups.spacegroups_creator_idx on [creator] non-unique]
2015-02-18 16:21:47,594 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [idx_user_external_id] of table [cwd_user] is missing; expected [Index cwd_user.idx_user_external_id on [external_id] non-unique]
2015-02-18 16:21:47,594 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [j_creationdate_idx] of table [journalentry] is missing; expected [Index journalentry.j_creationdate_idx on [creationdate] non-unique]
2015-02-18 16:21:47,594 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [j_j_name_idx] of table [journalentry] is missing; expected [Index journalentry.j_j_name_idx on [journal_name] non-unique]
2015-02-18 16:21:47,595 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [pt_creator_idx] of table [pagetemplates] is missing; expected [Index pagetemplates.pt_creator_idx on [creator] non-unique]
2015-02-18 16:21:47,595 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Index [pt_lastmodifier_idx] of table [pagetemplates] is missing; expected [Index pagetemplates.pt_lastmodifier_idx on [lastmodifier] non-unique]
Thanks for your feedback. Missing indexes/constraints can indeed indicate a performance or data integrity problem with your Confluence instance, which is why we added this constraint checker in Confluence 5.7.
We have written an article here that describes the different types of problems that our new constraint checker detects, with links to bugs that describe remedial actions to take on each:
https://confluence.atlassian.com/display/CONFKB/The+Database+Constraint+Checker
Eventually we plan to have Confluence automatically address these problems (hence why each is tracked as a bug), but for the moment the recommended approach is the manual workaround described on each ticket.
If you have any questions or concerns about this, please raise a support case at https://support.atlassian.com, and our staff will work through it with you.