com.mongodb.MongoException$DuplicateKey: { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0} { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0}

Pentaho BI Platform Tracking | Doug Moran | 3 years ago
  1. 0

    Inserting records from MySQL into MongoDB via Kettle. Randomly getting Duplicate Key Exceptions which abort the transform. I can successfully add the same records if I do an update instead if insert. This has obvious performance issues. ==========================================ERROR========================================================================== 2013/12/30 15:31:42 - Add Products.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Unexpected error 2013/12/30 15:31:42 - Add Products.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : org.pentaho.di.core.exception.KettleException: 2013/12/30 15:31:42 - Add Products.0 - com.mongodb.MongoException$DuplicateKey: { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0} 2013/12/30 15:31:42 - Add Products.0 - { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0} 2013/12/30 15:31:42 - Add Products.0 - 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput.doBatch(MongoDbOutput.java:388) 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput$1.run(MongoDbOutput.java:265) 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput$1.run(MongoDbOutput.java:87) 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.mongo.AuthContext.doAs(AuthContext.java:68) 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput.processRow(MongoDbOutput.java:87) 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2013/12/30 15:31:42 - Add Products.0 - at java.lang.Thread.run(Unknown Source) 2013/12/30 15:31:42 - Add Products.0 - Caused by: com.mongodb.MongoException$DuplicateKey: { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0} 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.CommandResult.getException(CommandResult.java:74) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.CommandResult.throwOnError(CommandResult.java:110) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBTCPConnector._checkWriteError(DBTCPConnector.java:102) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBTCPConnector.say(DBTCPConnector.java:142) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBTCPConnector.say(DBTCPConnector.java:115) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBApiLayer$MyCollection.insert(DBApiLayer.java:248) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBApiLayer$MyCollection.insert(DBApiLayer.java:204) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBCollection.insert(DBCollection.java:148) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBCollection.insert(DBCollection.java:133) 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput.doBatch(MongoDbOutput.java:347) 2013/12/30 15:31:42 - Add Products.0 - ... 6 more

    Pentaho BI Platform Tracking | 3 years ago | Doug Moran
    com.mongodb.MongoException$DuplicateKey: { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0} { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0}
  2. 0

    Inserting records from MySQL into MongoDB via Kettle. Randomly getting Duplicate Key Exceptions which abort the transform. I can successfully add the same records if I do an update instead if insert. This has obvious performance issues. ==========================================ERROR========================================================================== 2013/12/30 15:31:42 - Add Products.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Unexpected error 2013/12/30 15:31:42 - Add Products.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : org.pentaho.di.core.exception.KettleException: 2013/12/30 15:31:42 - Add Products.0 - com.mongodb.MongoException$DuplicateKey: { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0} 2013/12/30 15:31:42 - Add Products.0 - { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0} 2013/12/30 15:31:42 - Add Products.0 - 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput.doBatch(MongoDbOutput.java:388) 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput$1.run(MongoDbOutput.java:265) 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput$1.run(MongoDbOutput.java:87) 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.mongo.AuthContext.doAs(AuthContext.java:68) 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput.processRow(MongoDbOutput.java:87) 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2013/12/30 15:31:42 - Add Products.0 - at java.lang.Thread.run(Unknown Source) 2013/12/30 15:31:42 - Add Products.0 - Caused by: com.mongodb.MongoException$DuplicateKey: { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0} 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.CommandResult.getException(CommandResult.java:74) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.CommandResult.throwOnError(CommandResult.java:110) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBTCPConnector._checkWriteError(DBTCPConnector.java:102) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBTCPConnector.say(DBTCPConnector.java:142) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBTCPConnector.say(DBTCPConnector.java:115) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBApiLayer$MyCollection.insert(DBApiLayer.java:248) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBApiLayer$MyCollection.insert(DBApiLayer.java:204) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBCollection.insert(DBCollection.java:148) 2013/12/30 15:31:42 - Add Products.0 - at com.mongodb.DBCollection.insert(DBCollection.java:133) 2013/12/30 15:31:42 - Add Products.0 - at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput.doBatch(MongoDbOutput.java:347) 2013/12/30 15:31:42 - Add Products.0 - ... 6 more

    Pentaho BI Platform Tracking | 3 years ago | Doug Moran
    com.mongodb.MongoException$DuplicateKey: { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0} { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0}
  3. 0

    Get error message during benchmark mongodb v 2.4.12 using YCSB 0.1.4

    GitHub | 2 years ago | yeh928
    com.mongodb.MongoException$DuplicateKey: { "serverUsed" : "/192.168.117.121:27017/91db" , "lastOp" : { "$ts" : 0 , "$inc" : 0} , "connectionId" : 118 , "err" : "insertDocument :: caused by :: 11000 E11000 duplicate key error index: 91db.usertable.$_id_ dup key: { : \"user6284781860667377211\" }" , "code" : 11000 , "n" : 0 , "ok" : 1.0}
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Optimistic Locking not working? [moved]

    GitHub | 4 years ago | jyemin
    com.mongodb.MongoException$DuplicateKey: E11000 duplicate key error index: cal_dev.BookingDetail.$_id_ dup key: { : "24-11-2011" }
  6. 0

    Spring Data Mongo Repository update operation

    Stack Overflow | 2 years ago | Kumar Sambhav
    com.mongodb.MongoException$DuplicateKey: { "serverUsed" : "localhost:27017" , "ok" : 1 , "n" : 0 , "err" : "insertDocument :: caused by :: 11000 E11000 duplicate key error index: test.MENU_ITEM.$_id_ dup key: { : ObjectId('541ed581f39d6f87787067e3') }" , "code" : 11000}

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.mongodb.MongoException$DuplicateKey

      { "serverUsed" : "localhost/127.0.0.1:27017" , "err" : "E11000 duplicate key error index: NAD.products.$_id_ dup key: { : ObjectId('52c1d8122362b762c53d2077') }" , "code" : 11000 , "n" : 0 , "connectionId" : 10 , "ok" : 1.0}

      at com.mongodb.CommandResult.getException()
    2. MongoDB Java Driver
      DBCollection.insert
      1. com.mongodb.CommandResult.getException(CommandResult.java:74)
      2. com.mongodb.CommandResult.throwOnError(CommandResult.java:110)
      3. com.mongodb.DBTCPConnector._checkWriteError(DBTCPConnector.java:102)
      4. com.mongodb.DBTCPConnector.say(DBTCPConnector.java:142)
      5. com.mongodb.DBTCPConnector.say(DBTCPConnector.java:115)
      6. com.mongodb.DBApiLayer$MyCollection.insert(DBApiLayer.java:248)
      7. com.mongodb.DBApiLayer$MyCollection.insert(DBApiLayer.java:204)
      8. com.mongodb.DBCollection.insert(DBCollection.java:148)
      9. com.mongodb.DBCollection.insert(DBCollection.java:133)
      9 frames
    3. org.pentaho.di
      MongoDbOutput$1.run
      1. org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput.doBatch(MongoDbOutput.java:347)
      2. org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput$1.run(MongoDbOutput.java:265)
      3. org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput$1.run(MongoDbOutput.java:87)
      3 frames
    4. org.pentaho.mongo
      AuthContext.doAs
      1. org.pentaho.mongo.AuthContext.doAs(AuthContext.java:68)
      1 frame
    5. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput.processRow(MongoDbOutput.java:87)
      2. org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
      2 frames
    6. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame