Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-48998

Getting "Unexpected error" instead of "Duplicate key error" while trying to insert or update duplicate value in Array(of objects) > Field

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 4.2.6
    • Component/s: Index Maintenance
    • None
    • Server Triage
    • ALL
    • Hide
      1. Create a document with array of objects, say "children", and those array element objects having a field, say "childId".
        Eg:
        {
         "children": [{
         "childId": "child1"
         }, {
         "childId": "child2"
         }]
        }
        
      2. Create an unique index on children>childId
      3. Create another document with same data, but different childId values.
        Eg:
        {
         "children": [{
         "childId": "child3"
         }, {
         "childId": "child4"
         }]
        }
        
      4. In Mongodb Atlas web, clone the document to create a new document with same details. You'll get an error: "Unexpected error"
      5. In Mongodb compass, object view ( {} ), try doing the same, will get issue most of the times, the screen goes blank!
      6. In Mongodb compass, list view, try doing the same, it works as expected most of the times.
      7. If cloning works, without any error, do the following: update the second document to add another object to "children" array with "childId": "child1" (to be a duplicate of childId of an element of first document). You'll get the error.
      Show
      Create a document with array of objects, say "children", and those array element objects having a field, say "childId". Eg: { "children": [{ "childId": "child1" }, { "childId": "child2" }] } Create an unique index on children>childId Create another document with same data, but different childId values. Eg: { "children": [{ "childId": "child3" }, { "childId": "child4" }] } In Mongodb Atlas web, clone the document to create a new document with same details. You'll get an error: "Unexpected error" In Mongodb compass, object view ( {} ), try doing the same, will get issue most of the times, the screen goes blank! In Mongodb compass, list view, try doing the same, it works as expected most of the times. If cloning works, without any error, do the following: update the second document to add another object to "children" array with "childId": "child1" (to be a duplicate of childId of an element of first document). You'll get the error.

      Getting "Unexpected error" instead of "Duplicate key error" while trying to insert or update duplicate value in Array(of objects) > Field

        1. Capture1.5-2.PNG
          28 kB
          Arpan Bag
        2. Capture-2.PNG
          11 kB
          Arpan Bag
        3. Capture2-2.PNG
          20 kB
          Arpan Bag
        4. Capture3-3.PNG
          9 kB
          Arpan Bag
        5. Capture4-1.PNG
          16 kB
          Arpan Bag
        6. Capture5-1.PNG
          17 kB
          Arpan Bag
        7. Capture6-1.PNG
          14 kB
          Arpan Bag
        8. Capture7.PNG
          14 kB
          Arpan Bag
        9. Capture8.PNG
          13 kB
          Arpan Bag
        10. Capture9.PNG
          21 kB
          Arpan Bag

            Assignee:
            backlog-server-triage [HELP ONLY] Backlog - Triage Team
            Reporter:
            arpanbag1996@gmail.com Arpan Bag
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: