Uploaded image for project: 'MongoDB Database Tools'
  1. MongoDB Database Tools
  2. TOOLS-1810

mongoimport reports wrong number of documents inserted on error

    XMLWordPrintable

    Details

    • Type: Question
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: mongoimport
    • Labels:
      None

      Description

      Consider a JSON file with an invalid document:

      $ cat b.json
      {"a":13}
      {"a":75}
      {"a":20}
      {"a":89}
      {"a":36}
      {"a":64}
      {"a":67}
      {"a":32}
      {"a":55,}
      {"a":27}
      

      Note the extra "," in the ninth document. Then try to import it:

      $ mongoimport --drop -d test -c foo < b.json
      2017-10-11T09:16:29.537-0400    connected to: localhost
      2017-10-11T09:16:29.538-0400    dropping: test.foo
      2017-10-11T09:16:29.538-0400    Failed: error processing document #9: invalid character '}' looking for beginning of object key string
      2017-10-11T09:16:29.538-0400    imported 8 documents
      

      mongoimport reports 8 documents being imported, but there are none in the collection:

      $ echo 'db.foo.count()' | mongo
      MongoDB shell version v3.5.12
      connecting to: mongodb://127.0.0.1:27017
      MongoDB server version: 3.5.12
      0
      bye
      

      This is present in master:

      $ mongoimport --version
      mongoimport version: r3.5.12
      git version: 3128427f77397916967e3eb684dfed845bb1638a
      Go version: go1.7
         os: darwin
         arch: amd64
         compiler: gc
      OpenSSL version: OpenSSL 0.9.8zh 14 Jan 2016
      

      Same results (the number of documents reported and inserted differ) using --batchSize 1.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              david.golden David Golden
              Reporter:
              ramon.fernandez Ramon Fernandez Marina
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: