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

Handle duplicates with MongoDB

    XMLWordPrintable

    Details

    • Release Notes Summary:
      Nuxeo handles possible duplicates creation in MongoDB.
    • Release Notes Description:
      Hide

      Activate this option using

        <extension target="org.nuxeo.ecm.core.storage.mongodb.MongoDBRepositoryService" point="repository">
    <repository name="default">
      <childNameUniqueConstraintEnabled>true</childNameUniqueConstraintEnabled>
    </repository>
  </extension>
      Show
      Activate this option using <extension target= "org.nuxeo.ecm.core.storage.mongodb.MongoDBRepositoryService" point= "repository" > <repository name= "default" > <childNameUniqueConstraintEnabled> true </childNameUniqueConstraintEnabled> </repository> </extension>
    • Epic Link:
    • Tags:
    • Backlog priority:
      900
    • Sprint:
      nxplatform 11.1.25, nxplatform 11.1.26
    • Story Points:
      5

      Description

      Concurrent threads can currently create documents with the same parentId and the same name => both documents will appear in the UI but it will be possible to navigate to only one using the path.

      There should be a check in Nuxeo code to avoid these duplicates, in MongoDBRepository.createState where a comment indicates that dupes should be handled.

      db.collection.createIndex( { "ecm:name": 1, "ecm:parentId": 1 }, { unique: true } )

      Note that this doesn't work with sharding so this should be optional.

        Attachments

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. NXP-28527 Fix TestMongoDBIndices.shouldFailWhenCreatingExistingChildNameDocument on mongodb4

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. NXP-22421 Database-level integrity constraints for PostgreSQL

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

          Bug - A problem which impairs or prevents the functions of the product. NXP-28495 Fix possible bug in Document Import with slow server responses

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-27654 Add a unique index on ecm:id in MongoDB

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

          [Captain Hook] PR for master: #4165 PR for master: #4165

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days, 4 hours
                  2d 4h