Dremio x Mongodb - Error

Hi,

I am encountering errors when executing queries using mongodb. The error is: “MongoCursorNotFoundException: Query failed with error code -5 and error message ‘Cursor 277712117235 not found on server 10.20.30.10:27017’ on server 10.20.30.10:27017”

Can someone help me?

Regards,
Victor

@vbraguimcanto,

The MongoCursorNotFoundException error could be due to a timeout limit in Mongodb, which is 10 minutes by default. You can refer to:
https://docs.mongodb.com/manual/tutorial/iterate-a-cursor/#closure-of-inactive-cursors

By default, the server will automatically close the cursor after 10 minutes of inactivity, or if client has exhausted the cursor.

Can you try setting “noCursorTimeout” to true via the Mongo source advanced property and run the query again?