UnknownHostException while connecting to mongodb using mongo spark connector and multiple hosts

rishabh 1

As the title says,
Using : spark.read.format("com.mongodb.spark.sql.DefaultSource") \
.option("uri", connectionString) \
.load()
to load data from mongo. It works like a charm when I use only 1 host but when hosts are>1 then it throws:

com.mongodb.MongoTimeoutException: Timed out after 30000 ms while waiting for a server that matches com.mongodb.client.internal.MongoClientDelegate

Please help

PRADEEPCHEEKATLA-MSFT 78,331 Reputation points Microsoft Employee

2022-07-21T10:30:38.823+00:00

Hello @rishabh ,

Thanks for the question and using MS Q&A platform.

Could you please share the code snippet which you are trying to use hosts are >1?
rishabh 1 Reputation point

2022-07-21T11:13:51.95+00:00

connectionString="mongodb://username:password@10.0.7.5:27017,10.0.6.5:27017,10.0.5.5:27017/database.collection?authSource=test"

data=spark.read.format("com.mongodb.spark.sql.DefaultSource") \
.option("uri", connectionString) \
.load()
PRADEEPCHEEKATLA-MSFT 78,331 Reputation points Microsoft Employee

2022-07-26T09:25:53.55+00:00

Hello @rishabh ,

It's looks like an issue from Mongodb timeout. I would suggest you contact the MongoDB Support.