error connecting to host: could not connect to server: server selection error: server selection timeout current topology: Type: Single Servers

mongodb mongoimport
Szelek picture Szelek · Dec 19, 2019 · Viewed 12.1k times · Source

I need to import a CSV file to mongoDB unfortunately i'm having below error:

    error connecting to host: could not connect to server: server selection error: server selection timeout
    current topology: Type: Single
    Servers:
    Addr: eaderline:27017, Type: Unknown, State: Connected, Average RTT: 0, Last error: connection() : dial tcp: lookup eaderline: no such host

my import string looks like that:

mongoimport --host Test-shard-0/test-shard-00-00-gceee.mongodb.net:27017,test-shard-00-01-gceee.mongodb.net:27017,test-shard-00-02-gceee.mongodb.net:27017 --ssl --username <username> --password <password> --authenticationDatabase admin --db EngineeringProject --collection FirstName --type csv -file "C:\Users\Ja\Desktop\INFA\ProjektInzynierski\DaneDBzMC\imiona.csv" -headerline

The funny part about this error is that, i was able to import data to mongodb a 2 weeks ago by similar string which looks like this one below, and today it's imposible, why?

mongoimport --host Test-shard-0/test-shard-00-00-gceee.mongodb.net:27017,test-shard-00-01-gceee.mongodb.net:27017,test-shard-00-02-gceee.mongodb.net:27017 --ssl --username <username> --password <password> --authenticationDatabase admin --db Test2 --collection COL_First --type csv -file "C:\Users\Ja\Desktop\Przykladowy\Mapy\liczba.csv" -headerline

Does anyone see any mistake?

I have checked the port 27017 on my machine is free, maybe there is something going on on the cluster side? Is there a way to launch an empty import, just for checking the connection?

Answer

Szelek picture Szelek · Dec 19, 2019

Finally I was able to import my CSV file via mongodb GUI client, Compass.

In the meantime i bumped into another issue. Compass connect do the cluster showed the DBs, but didn't show the collections. It turned out that my user had a bad role. I deleted the user and add it once again, and it worked, I could see the collections also.

After that I was able to import my CSV file.

Related questions

Mongoimport of json file

I have a json file consisting of about 2000 records. Each record which will correspond to a document in the mongo database is formatted as follows: {jobID:"2597401", account:"XXXXX", user:"YYYYY", pkgT:{"pgi/7.2-5":{libA:["libpgc.so"],flavor:["default"]}}, startEpoch:"1338497979", runTime:"1022", …

Read More
How to use mongoimport to import csv

Trying to import a CSV with contact information: Name,Address,City,State,ZIP Jane Doe,123 Main St,Whereverville,CA,90210 John Doe,555 Broadway Ave,New York,NY,10010 Running this doesn't seem to add any documents to the database: $ mongoimport -d mydb …

Read More
mongoimport json file syntax

I'm trying to import json document using mongoimport command and have tried all possible ways but it's giving be below error. Plz tell me what m I doing wrong here. I've given full path of json doc. I want to …

Read More