org.pentaho.di.core.exception.KettleException: Unexpected error cursor 691369090140069798 not found on server /10.100.9.85:27017

Pentaho BI Platform Tracking | Sulaiman Karmali | 3 years ago
  1. 0

    I am creating a 3 panel dashboard where each panel points to a PRPT report for 10K, 100K and 1M record set. During the rename of the 3rd panel dashboard name, the busy cursor has been displaying for over 30 minutes and am seeing exception in DI Server. 2013/11/14 11:13:44 - mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf" - Dispatching started for transformation [mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf"] 2013/11/14 11:13:44 - MongoDB Input.0 - Configuring connection with read preference: primary 2013/11/14 11:13:44 - MongoDB Input.0 - No read preference tag sets defined 2013/11/14 11:13:44 - MongoDB Input.0 - Configuring connection with default write concern - w = 1, wTimeout: 0, journaled = false 2013/11/14 11:13:49 - mongo_uspo_perf - SQL - SELECT * FROM "Kettle"."mongo_uspo_perf" - Dispatching started for transformation [mongo_uspo_perf - SQL - SELECT * FROM "Kettle"."mongo_uspo_perf"] 2013/11/14 11:13:49 - MongoDB Input.0 - Query pulled data from: /10.100.9.85:27017 2013/11/14 11:17:47 - Merge Join.0 - linenr 50000 2013/11/14 11:17:49 - Table input.0 - linenr 50000 2013/11/14 11:17:52 - Merge Join.0 - linenr 100000 2013/11/14 11:17:59 - Mongo Output.0 - Linenr 50000 2013/11/14 11:18:05 - Injector.0 - Linenr 50000 2013/11/14 11:18:11 - Merge Join.0 - linenr 150000 2013/11/14 11:18:16 - Select values.0 - linenr 50000 2013/11/14 11:47:21 - RESULT.0 - Linenr 50000 2013/11/14 11:47:21 - Table input.0 - linenr 100000 2013/11/14 11:47:22 - Merge Join.0 - linenr 200000 2013/11/14 11:47:22 - Mongo Output.0 - Linenr 100000 2013/11/14 11:47:22 - Injector.0 - Linenr 100000 org.pentaho.di.core.exception.KettleException: Unexpected error cursor 691369090140069798 not found on server /10.100.9.85:27017 at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:151) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:61) at java.lang.Thread.run(Thread.java:722) Caused by: com.mongodb.MongoException$CursorNotFound: cursor 691369090140069798 not found on server /10.100.9.85:27017 at com.mongodb.DBApiLayer$Result.init(DBApiLayer.java:366) at com.mongodb.DBApiLayer$Result._advance(DBApiLayer.java:432) at com.mongodb.DBApiLayer$Result.hasNext(DBApiLayer.java:399) at com.mongodb.DBCursor._hasNext(DBCursor.java:464) at com.mongodb.DBCursor.hasNext(DBCursor.java:484) at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:96) at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:67) at org.pentaho.mongo.AuthContext.doAs(AuthContext.java:85) at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:67) ... 2 more 2013/11/14 11:47:23 - MongoDB Input.0 - ERROR (version TRUNK-SNAPSHOT, build 1 from 2013-11-11 11.26.18 by tomcat) : Unexpected error 2013/11/14 11:47:23 - MongoDB Input.0 - ERROR (version TRUNK-SNAPSHOT, build 1 from 2013-11-11 11.26.18 by tomcat) : org.pentaho.di.core.exception.KettleException: 2013/11/14 11:47:23 - MongoDB Input.0 - Unexpected error 2013/11/14 11:47:23 - MongoDB Input.0 - cursor 691369090140069798 not found on server /10.100.9.85:27017 2013/11/14 11:47:23 - MongoDB Input.0 - 2013/11/14 11:47:23 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:151) 2013/11/14 11:47:23 - MongoDB Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:61) 2013/11/14 11:47:23 - MongoDB Input.0 - at java.lang.Thread.run(Thread.java:722) 2013/11/14 11:47:23 - MongoDB Input.0 - Caused by: com.mongodb.MongoException$CursorNotFound: cursor 691369090140069798 not found on server /10.100.9.85:27017 2013/11/14 11:47:23 - MongoDB Input.0 - at com.mongodb.DBApiLayer$Result.init(DBApiLayer.java:366) 2013/11/14 11:47:23 - MongoDB Input.0 - at com.mongodb.DBApiLayer$Result._advance(DBApiLayer.java:432) 2013/11/14 11:47:23 - MongoDB Input.0 - at com.mongodb.DBApiLayer$Result.hasNext(DBApiLayer.java:399) 2013/11/14 11:47:23 - MongoDB Input.0 - at com.mongodb.DBCursor._hasNext(DBCursor.java:464) 2013/11/14 11:47:23 - MongoDB Input.0 - at com.mongodb.DBCursor.hasNext(DBCursor.java:484) 2013/11/14 11:47:23 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:96) 2013/11/14 11:47:23 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:67) 2013/11/14 11:47:23 - MongoDB Input.0 - at org.pentaho.mongo.AuthContext.doAs(AuthContext.java:85) 2013/11/14 11:47:23 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:67) 2013/11/14 11:47:23 - MongoDB Input.0 - ... 2 more child index = 3, logging object : org.pentaho.di.core.logging.LoggingObject@43324808 parent=d4920172-a31a-4c29-97ef-372fe72765ed 2013/11/14 11:47:23 - Table input.0 - Finished reading query, closing connection. 2013/11/14 11:47:23 - Mongo Output.0 - Finished processing (I=0, O=0, R=107351, W=107351, U=0, E=0) 2013/11/14 11:47:23 - Merge Join.0 - Finished processing (I=0, O=0, R=214904, W=107451, U=0, E=0) 2013/11/14 11:47:23 - MongoDB Input.0 - Finished processing (I=0, O=0, R=0, W=107487, U=0, E=1) 2013/11/14 11:47:23 - mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf" - mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf" 2013/11/14 11:47:23 - mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf" - mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf" 2013/11/14 11:47:29 - Select values.0 - linenr 100000 2013/11/14 11:47:29 - RESULT.0 - Linenr 100000 2013/11/14 11:47:31 - Table input.0 - Finished processing (I=117356, O=0, R=0, W=117355, U=0, E=0) 2013/11/14 11:47:31 - Injector.0 - Finished processing (I=0, O=0, R=107351, W=107351, U=0, E=0) 2013/11/14 11:47:31 - Select values.0 - Finished processing (I=0, O=0, R=107351, W=107351, U=0, E=0) 2013/11/14 11:47:31 - RESULT.0 - Finished processing (I=0, O=0, R=107351, W=107351, U=0, E=0) bytes written: 14439394 2013/11/14 11:48:21 - mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf" - Dispatching started for transformation [mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf"] 2013/11/14 11:48:21 - MongoDB Input.0 - Configuring connection with read preference: primary 2013/11/14 11:48:21 - MongoDB Input.0 - No read preference tag sets defined 2013/11/14 11:48:21 - MongoDB Input.0 - Configuring connection with default write concern - w = 1, wTimeout: 0, journaled = false 2013/11/14 11:48:27 - mongo_uspo_perf - SQL - SELECT * FROM "Kettle"."mongo_uspo_perf" - Dispatching started for transformation [mongo_uspo_perf - SQL - SELECT * FROM "Kettle"."mongo_uspo_perf"] 2013/11/14 11:48:27 - MongoDB Input.0 - Query pulled data from: /10.100.9.85:27017

    Pentaho BI Platform Tracking | 3 years ago | Sulaiman Karmali
    org.pentaho.di.core.exception.KettleException: Unexpected error cursor 691369090140069798 not found on server /10.100.9.85:27017
  2. 0

    I am creating a 3 panel dashboard where each panel points to a PRPT report for 10K, 100K and 1M record set. During the rename of the 3rd panel dashboard name, the busy cursor has been displaying for over 30 minutes and am seeing exception in DI Server. 2013/11/14 11:13:44 - mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf" - Dispatching started for transformation [mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf"] 2013/11/14 11:13:44 - MongoDB Input.0 - Configuring connection with read preference: primary 2013/11/14 11:13:44 - MongoDB Input.0 - No read preference tag sets defined 2013/11/14 11:13:44 - MongoDB Input.0 - Configuring connection with default write concern - w = 1, wTimeout: 0, journaled = false 2013/11/14 11:13:49 - mongo_uspo_perf - SQL - SELECT * FROM "Kettle"."mongo_uspo_perf" - Dispatching started for transformation [mongo_uspo_perf - SQL - SELECT * FROM "Kettle"."mongo_uspo_perf"] 2013/11/14 11:13:49 - MongoDB Input.0 - Query pulled data from: /10.100.9.85:27017 2013/11/14 11:17:47 - Merge Join.0 - linenr 50000 2013/11/14 11:17:49 - Table input.0 - linenr 50000 2013/11/14 11:17:52 - Merge Join.0 - linenr 100000 2013/11/14 11:17:59 - Mongo Output.0 - Linenr 50000 2013/11/14 11:18:05 - Injector.0 - Linenr 50000 2013/11/14 11:18:11 - Merge Join.0 - linenr 150000 2013/11/14 11:18:16 - Select values.0 - linenr 50000 2013/11/14 11:47:21 - RESULT.0 - Linenr 50000 2013/11/14 11:47:21 - Table input.0 - linenr 100000 2013/11/14 11:47:22 - Merge Join.0 - linenr 200000 2013/11/14 11:47:22 - Mongo Output.0 - Linenr 100000 2013/11/14 11:47:22 - Injector.0 - Linenr 100000 org.pentaho.di.core.exception.KettleException: Unexpected error cursor 691369090140069798 not found on server /10.100.9.85:27017 at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:151) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:61) at java.lang.Thread.run(Thread.java:722) Caused by: com.mongodb.MongoException$CursorNotFound: cursor 691369090140069798 not found on server /10.100.9.85:27017 at com.mongodb.DBApiLayer$Result.init(DBApiLayer.java:366) at com.mongodb.DBApiLayer$Result._advance(DBApiLayer.java:432) at com.mongodb.DBApiLayer$Result.hasNext(DBApiLayer.java:399) at com.mongodb.DBCursor._hasNext(DBCursor.java:464) at com.mongodb.DBCursor.hasNext(DBCursor.java:484) at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:96) at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:67) at org.pentaho.mongo.AuthContext.doAs(AuthContext.java:85) at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:67) ... 2 more 2013/11/14 11:47:23 - MongoDB Input.0 - ERROR (version TRUNK-SNAPSHOT, build 1 from 2013-11-11 11.26.18 by tomcat) : Unexpected error 2013/11/14 11:47:23 - MongoDB Input.0 - ERROR (version TRUNK-SNAPSHOT, build 1 from 2013-11-11 11.26.18 by tomcat) : org.pentaho.di.core.exception.KettleException: 2013/11/14 11:47:23 - MongoDB Input.0 - Unexpected error 2013/11/14 11:47:23 - MongoDB Input.0 - cursor 691369090140069798 not found on server /10.100.9.85:27017 2013/11/14 11:47:23 - MongoDB Input.0 - 2013/11/14 11:47:23 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:151) 2013/11/14 11:47:23 - MongoDB Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:61) 2013/11/14 11:47:23 - MongoDB Input.0 - at java.lang.Thread.run(Thread.java:722) 2013/11/14 11:47:23 - MongoDB Input.0 - Caused by: com.mongodb.MongoException$CursorNotFound: cursor 691369090140069798 not found on server /10.100.9.85:27017 2013/11/14 11:47:23 - MongoDB Input.0 - at com.mongodb.DBApiLayer$Result.init(DBApiLayer.java:366) 2013/11/14 11:47:23 - MongoDB Input.0 - at com.mongodb.DBApiLayer$Result._advance(DBApiLayer.java:432) 2013/11/14 11:47:23 - MongoDB Input.0 - at com.mongodb.DBApiLayer$Result.hasNext(DBApiLayer.java:399) 2013/11/14 11:47:23 - MongoDB Input.0 - at com.mongodb.DBCursor._hasNext(DBCursor.java:464) 2013/11/14 11:47:23 - MongoDB Input.0 - at com.mongodb.DBCursor.hasNext(DBCursor.java:484) 2013/11/14 11:47:23 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:96) 2013/11/14 11:47:23 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:67) 2013/11/14 11:47:23 - MongoDB Input.0 - at org.pentaho.mongo.AuthContext.doAs(AuthContext.java:85) 2013/11/14 11:47:23 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:67) 2013/11/14 11:47:23 - MongoDB Input.0 - ... 2 more child index = 3, logging object : org.pentaho.di.core.logging.LoggingObject@43324808 parent=d4920172-a31a-4c29-97ef-372fe72765ed 2013/11/14 11:47:23 - Table input.0 - Finished reading query, closing connection. 2013/11/14 11:47:23 - Mongo Output.0 - Finished processing (I=0, O=0, R=107351, W=107351, U=0, E=0) 2013/11/14 11:47:23 - Merge Join.0 - Finished processing (I=0, O=0, R=214904, W=107451, U=0, E=0) 2013/11/14 11:47:23 - MongoDB Input.0 - Finished processing (I=0, O=0, R=0, W=107487, U=0, E=1) 2013/11/14 11:47:23 - mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf" - mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf" 2013/11/14 11:47:23 - mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf" - mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf" 2013/11/14 11:47:29 - Select values.0 - linenr 100000 2013/11/14 11:47:29 - RESULT.0 - Linenr 100000 2013/11/14 11:47:31 - Table input.0 - Finished processing (I=117356, O=0, R=0, W=117355, U=0, E=0) 2013/11/14 11:47:31 - Injector.0 - Finished processing (I=0, O=0, R=107351, W=107351, U=0, E=0) 2013/11/14 11:47:31 - Select values.0 - Finished processing (I=0, O=0, R=107351, W=107351, U=0, E=0) 2013/11/14 11:47:31 - RESULT.0 - Finished processing (I=0, O=0, R=107351, W=107351, U=0, E=0) bytes written: 14439394 2013/11/14 11:48:21 - mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf" - Dispatching started for transformation [mongo_uspo_perf - Service - SELECT * FROM "Kettle"."mongo_uspo_perf"] 2013/11/14 11:48:21 - MongoDB Input.0 - Configuring connection with read preference: primary 2013/11/14 11:48:21 - MongoDB Input.0 - No read preference tag sets defined 2013/11/14 11:48:21 - MongoDB Input.0 - Configuring connection with default write concern - w = 1, wTimeout: 0, journaled = false 2013/11/14 11:48:27 - mongo_uspo_perf - SQL - SELECT * FROM "Kettle"."mongo_uspo_perf" - Dispatching started for transformation [mongo_uspo_perf - SQL - SELECT * FROM "Kettle"."mongo_uspo_perf"] 2013/11/14 11:48:27 - MongoDB Input.0 - Query pulled data from: /10.100.9.85:27017

    Pentaho BI Platform Tracking | 3 years ago | Sulaiman Karmali
    org.pentaho.di.core.exception.KettleException: Unexpected error cursor 691369090140069798 not found on server /10.100.9.85:27017
  3. 0

    Not fetching data from Mongo DB

    GitHub | 3 years ago | hiteshvanjani
    com.mongodb.MongoException$CursorNotFound: cursor 7430749966549964 not found on server /127.0.0.1:27017
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    River not connect to replica secondary instace after master is disconnected.

    GitHub | 2 years ago | nai0om
    com.mongodb.MongoException$CursorNotFound: cursor 387727812883675452 not found on server mongo1/xxx.xxx.xxx.xxx:60002
  6. 0

    River crashes upon loosing mongodb connection

    GitHub | 3 years ago | ltworf
    com.mongodb.MongoException$CursorNotFound: cursor 7766048665814738629 not found on server build/127.0.0.1:27017

    2 unregistered visitors
    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$CursorNotFound

      cursor 691369090140069798 not found on server /10.100.9.85:27017

      at com.mongodb.DBApiLayer$Result.init()
    2. MongoDB Java Driver
      DBCursor.hasNext
      1. com.mongodb.DBApiLayer$Result.init(DBApiLayer.java:366)
      2. com.mongodb.DBApiLayer$Result._advance(DBApiLayer.java:432)
      3. com.mongodb.DBApiLayer$Result.hasNext(DBApiLayer.java:399)
      4. com.mongodb.DBCursor._hasNext(DBCursor.java:464)
      5. com.mongodb.DBCursor.hasNext(DBCursor.java:484)
      5 frames
    3. org.pentaho.di
      MongoDbInput$1.run
      1. org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:96)
      2. org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:67)
      2 frames
    4. org.pentaho.mongo
      AuthContext.doAs
      1. org.pentaho.mongo.AuthContext.doAs(AuthContext.java:85)
      1 frame
    5. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:67)
      2. org.pentaho.di.trans.step.RunThread.run(RunThread.java:61)
      2 frames
    6. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:722)
      1 frame