Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-30638

Use partialFilterExpression on parentId when creating the unique index to avoid duplicates

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.10
    • Fix Version/s: 10.10-HF58, 2021.15
    • Component/s: Core MongoDB
    • Release Notes Summary:
      Enabling unique child constraint doesn't prevent version creation anymore
    • Tags:
    • Backlog priority:
      750
    • Upgrade notes:
      Hide

      For LTS 2019

      Setup having the childNameUniqueConstraintEnabled enabled on MongoDB will need to drop the ecm:parentId_1_ecm:name_1 before starting Nuxeo with the fix installed.
      You should run the command below in a MongoDB in a MongoDB Shell (assuming you're connected to the nuxeo database and your repository is default):

      db.default.dropIndex("ecm:parentId_1_ecm:name_1");

      For LTS 2021

      You must run the command below in a MongoDB Shell (assuming you're connected to the nuxeo database and your repository is default):

      db.default.dropIndex("ecm:parentId_1_ecm:name_1");

      As a workaround, you can configure the nuxeo.db.indexes.create property to false in nuxeo.conf.

      Show
      For LTS 2019 Setup having the childNameUniqueConstraintEnabled enabled on MongoDB will need to drop the ecm:parentId_1_ecm:name_1 before starting Nuxeo with the fix installed. You should run the command below in a MongoDB in a MongoDB Shell (assuming you're connected to the nuxeo  database and your repository is default ): db. default .dropIndex( "ecm:parentId_1_ecm:name_1" ); For LTS 2021 You must run the command below in a MongoDB Shell (assuming you're connected to the nuxeo  database and your repository is default ): db. default .dropIndex( "ecm:parentId_1_ecm:name_1" ); As a workaround, you can configure the nuxeo.db.indexes.create property to false in nuxeo.conf .
    • Sprint:
      nxplatform #52, nxplatform #53
    • Story Points:
      0

      Description

      For MongoDB repository, Nuxeo adds a unique index on "ecm:name ; ecm:parentId" to prevent from creating several documents with the same name in a given container with

              IndexOptions parentNameIndexOptions = new IndexOptions();
        parentNameIndexOptions.unique(true);
        coll.createIndex(Indexes.ascending(KEY_PARENT_ID, KEY_NAME), parentNameIndexOptions);

      However this index prevents from creating versions (there is an error when creating the second version as it has the same name and the same "null" parent).

      It is required to add a partialFilterExpression attribute on the index creation like

      db.default.createIndex( { "ecm:parentId": 1, "ecm:name": 1 }, { unique: true, partialFilterExpression: {'ecm:parentId':{$gt:""}} } )

        Attachments

          Issue Links

          causes

          Task - A task that needs to be done. NXP-30865 Don't prevent Nuxeo from starting if MongoDB indexes are not correct

          • Blocker - Blocks development and/or testing work, production could not run.
          • Resolved
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. NXP-29261 Allow configuration of repository/directory indexes to add, even after initial creation

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          Is referenced in

          [Captain Hook] PR for 10.10: #5041 PR for 10.10: #5041

          [Captain Hook] PR for 2021: #352 PR for 2021: #352

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.