Database constraint checker that is new to 5.7 found these discrepancies on an existing installation:

      2014-12-14 19:07:49,320 WARN [main] [core.persistence.schema.StartupSchemaChecker] handleWarnings Database schema is inconsistent with expectations - %s warnings, see below
      2014-12-14 19:07:49,320 WARN [main] [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]
      2014-12-14 19:07:49,320 WARN [main] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [labelid] of table [content_label] has mismatched definitions for expected [Column content_label.labelid int8 non-nullable] and actual [Column content_label.labelid int8(19) nullable]
      2014-12-14 19:07:49,321 WARN [main] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [username] of table [logininfo] has mismatched definitions for expected [Column logininfo.username varchar(255) non-nullable] and actual [Column logininfo.username varchar(255) nullable]
      2014-12-14 19:07:49,321 WARN [main] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [buildnumber] of table [confversion] has mismatched definitions for expected [Column confversion.buildnumber int4 non-nullable] and actual [Column confversion.buildnumber int4(10) nullable]
      2014-12-14 19:07:49,321 WARN [main] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [cp_type] of table [content_perm] has mismatched definitions for expected [Column content_perm.cp_type varchar(10) non-nullable] and actual [Column content_perm.cp_type varchar(10) nullable]
      2014-12-14 19:07:49,321 WARN [main] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [follower] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.follower varchar(255) nullable] and actual [Column follow_connections.follower varchar(255) non-nullable]
      2014-12-14 19:07:49,322 WARN [main] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [followee] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.followee varchar(255) nullable] and actual [Column follow_connections.followee varchar(255) non-nullable]
      2014-12-14 19:07:49,364 WARN [main] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [public_key_id] of table [trustedapp] has mismatched definitions for expected [Column trustedapp.public_key_id int8 non-nullable] and actual [Column trustedapp.public_key_id int8(19) nullable]
      

            [CONFSERVER-35915] Many database constraints have not been updated correctly

            Matt Ryall added a comment - - edited

            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.

            Matt Ryall added a comment - - edited 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.

            I also have similar messages in logs and performance in 5.7 is horrible. Pages take forever to load.

            2015-03-13 09:51:04,940 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Database schema is inconsistent with expectations - %s warnings, see below
            2015-03-13 09:51:04,945 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [follower] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.follower varchar(255) nullable] and actual [Column follow_connections.follower varchar(255) non-nullable]
            2015-03-13 09:51:04,945 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [followee] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.followee varchar(255) nullable] and actual [Column follow_connections.followee varchar(255) non-nullable]
            2015-03-13 09:51:04,945 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]

            Paul Biagio added a comment - I also have similar messages in logs and performance in 5.7 is horrible. Pages take forever to load. 2015-03-13 09:51:04,940 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Database schema is inconsistent with expectations - %s warnings, see below 2015-03-13 09:51:04,945 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [follower] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.follower varchar(255) nullable] and actual [Column follow_connections.follower varchar(255) non-nullable] 2015-03-13 09:51:04,945 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [followee] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.followee varchar(255) nullable] and actual [Column follow_connections.followee varchar(255) non-nullable] 2015-03-13 09:51:04,945 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]

            We just upgrade our test-server to 5.7.

            during the update we had several problems with the internal update-processes (https://support.atlassian.com/servicedesk/agent/CSP/issue/CSP-141051)
            We added the propertie <property name="hibernate.hbm2ddl.skip_creating_missing_indexes">true</property> and the update was a success...

            Now we have some performance-issues on the user-side (everwhere where content is). COnfluence-Administration-Screens running fast as always.

            During every startup of Confluence we receive: (even with removed former added propertie)

            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]
            

            any way to re-create those indexes?

            Kind regards
            André

            Andre Lehmann added a comment - We just upgrade our test-server to 5.7. during the update we had several problems with the internal update-processes ( https://support.atlassian.com/servicedesk/agent/CSP/issue/CSP-141051 ) We added the propertie <property name="hibernate.hbm2ddl.skip_creating_missing_indexes">true</property> and the update was a success... Now we have some performance-issues on the user-side (everwhere where content is). COnfluence-Administration-Screens running fast as always. During every startup of Confluence we receive: (even with removed former added propertie) 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] any way to re-create those indexes? Kind regards André

            the same issue , and the confluence-5.7-cluster can't startup;

            2015-02-12 12:33:42,153 INFO [localhost-startStop-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 5.7 [build 5780  based on commit hash e911fdad641682b02838ab32b82c9780ca1ecd5a]
            2015-02-12 12:33:44,041 INFO [localhost-startStop-1] [confluence.cluster.hazelcast.ConfluenceHazelcastConfigBuilder] getConfigInputStream Reading Hazelcast config from classpath location [confluence-hazelcast-config.xml]
            2015-02-12 12:33:44,071 INFO [localhost-startStop-1] [confluence.cluster.hazelcast.HazelcastClusterManager] configure Configuring Hazelcast with instanceName [confluence], multicast address 238.94.245.0:54327, multicast TTL [1], network interfaces [10.64.13.32, fe80:0:0:0:eef4:bbff:fed1:cde8%2] and local port 5801
            2015-02-12 12:33:44,071 INFO [localhost-startStop-1] [confluence.cluster.hazelcast.HazelcastClusterManager] startCluster Starting the cluster.
            2015-02-12 12:33:49,762 INFO [localhost-startStop-1] [confluence.cluster.hazelcast.HazelcastClusterManager] startCluster Confluence cluster node identifier is [3dc1b14a]
            2015-02-12 12:33:49,865 INFO [localhost-startStop-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
            2015-02-12 12:33:52,663 INFO [localhost-startStop-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
            2015-02-12 12:33:55,243 WARN [localhost-startStop-1] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory!
            2015-02-12 12:34:02,482 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Database schema is inconsistent with expectations - %s warnings, see below
            2015-02-12 12:34:02,482 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [follower] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.follower varchar(255) nullable] and actual [Column follow_connections.follower varchar(255) non-nullable]
            2015-02-12 12:34:02,483 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [followee] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.followee varchar(255) nullable] and actual [Column follow_connections.followee varchar(255) non-nullable]
            2015-02-12 12:34:02,483 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-12 12:34:03,211 INFO [localhost-startStop-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 13345 ms
            2015-02-12 12:34:03,314 WARN [localhost-startStop-1] [confluence.setup.dbcheck.MySQLChecker] checkCharacterSetAndCollation Your database uses non-recommended collation: utf8_general_ci. See https://confluence.atlassian.com/x/IrYC
            2015-02-12 12:34:04,012 INFO [localhost-startStop-1] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve
            

            Jabari Deng added a comment - the same issue , and the confluence-5.7-cluster can't startup; 2015-02-12 12:33:42,153 INFO [localhost-startStop-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 5.7 [build 5780 based on commit hash e911fdad641682b02838ab32b82c9780ca1ecd5a] 2015-02-12 12:33:44,041 INFO [localhost-startStop-1] [confluence.cluster.hazelcast.ConfluenceHazelcastConfigBuilder] getConfigInputStream Reading Hazelcast config from classpath location [confluence-hazelcast-config.xml] 2015-02-12 12:33:44,071 INFO [localhost-startStop-1] [confluence.cluster.hazelcast.HazelcastClusterManager] configure Configuring Hazelcast with instanceName [confluence], multicast address 238.94.245.0:54327, multicast TTL [1], network interfaces [10.64.13.32, fe80:0:0:0:eef4:bbff:fed1:cde8%2] and local port 5801 2015-02-12 12:33:44,071 INFO [localhost-startStop-1] [confluence.cluster.hazelcast.HazelcastClusterManager] startCluster Starting the cluster. 2015-02-12 12:33:49,762 INFO [localhost-startStop-1] [confluence.cluster.hazelcast.HazelcastClusterManager] startCluster Confluence cluster node identifier is [3dc1b14a] 2015-02-12 12:33:49,865 INFO [localhost-startStop-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started 2015-02-12 12:33:52,663 INFO [localhost-startStop-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager 2015-02-12 12:33:55,243 WARN [localhost-startStop-1] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory! 2015-02-12 12:34:02,482 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Database schema is inconsistent with expectations - %s warnings, see below 2015-02-12 12:34:02,482 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [follower] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.follower varchar(255) nullable] and actual [Column follow_connections.follower varchar(255) non-nullable] 2015-02-12 12:34:02,483 WARN [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] handleWarnings Column [followee] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.followee varchar(255) nullable] and actual [Column follow_connections.followee varchar(255) non-nullable] 2015-02-12 12:34:02,483 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-12 12:34:03,211 INFO [localhost-startStop-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 13345 ms 2015-02-12 12:34:03,314 WARN [localhost-startStop-1] [confluence.setup.dbcheck.MySQLChecker] checkCharacterSetAndCollation Your database uses non-recommended collation: utf8_general_ci. See https: //confluence.atlassian.com/x/IrYC 2015-02-12 12:34:04,012 INFO [localhost-startStop-1] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve

              matt@atlassian.com Matt Ryall
              onevalainen Olli Nevalainen
              Affected customers:
              13 This affects my team
              Watchers:
              22 Start watching this issue

                Created:
                Updated:
                Resolved: