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

duplicate key error should report field names as well as values

    XMLWordPrintableJSON

Details

    • Fully Compatible
    • Storage NYC 2018-09-24

    Description

      Consider a compound index with a name:

      db.test.ensureIndex( { a: 1, b : 1 }, { unique: true, name : 'index_1' }

      A duplicate key error on that index reports this errmsg:

      "errmsg" : "insertDocument :: caused by :: 11000 E11000 duplicate key error index: admin.test.$index_1  dup key: { : 1.0, : 2.0 }"

      The dup key is a string that looks like JSON but is missing the field names. It would be easier for clients to understand the error message if the dup key contained the field names as well as the values, especially in the case of named indexes where the index name doesn't provide enough of a clue, e.g.

      "errmsg" : "insertDocument :: caused by :: 11000 E11000 duplicate key error index: admin.test.$index_1  dup key: { a : 1.0, b : 2.0 }"

      I'd also prefer that the index name be rendered without the collection name or the $. Clients know what collection they are using. and the $ is not part of the index name from the clients perspective.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. PYTHON-1767 Doctests fails on unexpected keyPattern/keyValue fields in writeErrors

          • Major - P3 - Major loss of function.
          • Closed
          depends on

          Task - A task that needs to be done. SERVER-37070 All storage engines should show the collection name and the index name in the error message of duplicate keys

          • Major - P3 - Major loss of function.
          • Closed
          is depended on by

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-37124 Retry full upsert path when duplicate key exception matches exact query predicate

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-37532 Retry update on specific duplicate index exception during upsert

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. NODE-1130 Show full path of duplicate key errors with indexes (Error 11000)

          • Trivial - P5 - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-33567 Show full path of duplicate key errors with indexes (Error 11000) (from NODE)

          • Trivial - P5 - Cosmetic problem like misspelt words or misaligned text.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-33814 Include additional metadata as properties on 11000 error messages

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. JAVA-1352 DuplicateKeyException should provide the propertyname which is duplicated

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-4637 E11000 (duplicate key error) should return a list of duplicate keys and _ids in insert, bulk insert, and continue_on_error inserts.

          • Major - P3 - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-3069 Add extra fields to getLastError output on duplicate key error

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-19281 Add index name as a separate field on duplicate key error object

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              xiangyu.yao@mongodb.com Xiangyu Yao (Inactive)
              jeff.yemin@mongodb.com Jeffrey Yemin
              Votes:
              2 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: