Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-24475

'Error creating manual index or constraint' during space import

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • 4.1.8
    • 4.1.1
    • None

    Description

      Whenever you do a Space Import the following is logged.

      WARN [Long running task: Importing data] [atlassian.confluence.setup.DefaultHibernateConfigurator] doInTransaction Error creating manual index or constraint: [alter table cwd_membership add constraint cwd_unique_user_membership unique (parent_id, child_user_id), alter table cwd_user add constraint cwd_user_name_dir_id unique (lower_user_name, directory_id), alter table cwd_group add constraint cwd_group_name_dir_id unique (lower_group_name, directory_id), alter table cwd_user_attribute add constraint cwd_unique_usr_attr unique (directory_id, user_id, attribute_name, attribute_lower_value), alter table cwd_group_attribute add constraint cwd_unique_grp_attr unique (directory_id, group_id, attribute_name, attribute_lower_value), alter table cwd_membership add constraint cwd_unique_group_membership unique (parent_id, child_group_id), alter table CONTENT_PERM add constraint cp_unique_user unique (CPS_ID, CP_TYPE, USERNAME), alter table CONTENT_PERM add constraint cp_unique_group unique (CPS_ID, CP_TYPE, GROUPNAME), alter table CONTENT_PERM_SET add constraint cps_unique_type unique (CONTENT_ID, CONT_PERM_TYPE), alter table BANDANA add constraint bandana_unique_key unique (BANDANACONTEXT, BANDANAKEY)], StatementCallback; uncategorized SQLException for SQL [alter table cwd_user add constraint cwd_user_name_dir_id unique (lower_user_name, directory_id)]; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
      

      Attachments

        Issue Links

          Activity

            People

              don.willis@atlassian.com Don Willis
              don.willis@atlassian.com Don Willis
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 16h
                  16h