Issue importing data

Hi all,

when i tried to execute the mongorestore i received the following message:

2018-10-23T10:36:59.599-0300    error dialing mflix-shard-00-00-gda0x.mongodb.net:27017: dial 
tcp 35.168.141.209:27017: connectex: Se produjo un error durante el intento de conexión ya que 
la parte conectada no respondió adecuadamente tras un periodo de tiempo, o bien se produjo un 
error en la conexión establecida ya que el host conectado no ha podido responder.
2018-10-23T10:36:59.607-0300    error dialing mflix-shard-00-01-gda0x.mongodb.net:27017: dial 
tcp 54.159.10.123:27017: connectex: Se produjo un error durante el intento de conexión ya que 
la parte conectada no respondió adecuadamente tras un periodo de tiempo, o bien se produjo un 
error en la conexión establecida ya que el host conectado no ha podido responder. 
2018-10-23T10:36:59.610-0300    error dialing mflix-shard-00-02-gda0x.mongodb.net:27017: dial 
tcp 18.215.212.58:27017: connectex: Se produjo un error durante el intento de conexión ya que 
la parte conectada no respondió adecuadamente tras un periodo de tiempo, o bien se produjo un 
error en la conexión establecida ya que el host conectado no ha podido responder.
2018-10-23T10:36:59.620-0300    error dialing mflix-shard-00-00-gda0x.mongodb.net:27017: dial 
tcp 35.168.141.209:27017: connectex: Se produjo un error durante el intento de conexión ya que 
la parte conectada no respondió adecuadamente tras un periodo de tiempo, o bien se produjo un 
error en la conexión establecida ya que el host conectado no ha podido responder.

the command line that i use is the following:

C:\mongo\bin>mongorestore --drop --gzip --uri mongodb+srv://m220student:m220password@mflix-gda0x.mongodb.net/test data

i already added my ip at the whitelist of the node, i really do not know how to continue. What i am doing wrong?

Thank you all
Regards,

Facundo

Hi Facundo,

Have you made sure that your Atlas cluster is up and running when you tried mongorestore?

If you log into Atlas, try connecting with:

mongo mongodb+srv://m220student:m220password@mflix-gda0x.mongodb.net/test

Your connection attempt is timing out. If you can’t connect to Atlas, try making sure that it is set up to receive all IP addresses.

After that, I would look into your firewall. I am no expert, but these are the steps that I would go through.

best,
Chris

1 Like

Hello fravinale,

I was able to connect to your Atlas cluster with the command posted by Christopher_07166, so it looks like your cluster is available for connections.

Are you still having trouble with mongorestore?

Matt

Hi Matt!

Yes, i still have issues importing the data. it seems like the connection is working now but when i excecute the import it shows the following msg:

    C:\Users\fravinale\Desktop\mongodb-win32-x86_64-enterprise-windows-64-4.0.3\bin    
    λ mongorestore --drop --gzip /uri mongodb+srv://m220student:m220password@mflix-gda0x.mongodb.net/test?retryWrites=true mflix                                          
    2018-10-28T07:50:47.806-0300    WARNING: ignoring unsupported URI parameter 'retrywrites'                                                                             
    2018-10-28T07:50:51.987-0300    preparing collections to restore from              
    2018-10-28T07:50:51.988-0300    don't know what to do with file "mflix\comments.bson.gz", skipping...                                                                 
    2018-10-28T07:50:51.988-0300    don't know what to do with file "mflix\comments.metadata.json.gz", skipping...                                                        
    2018-10-28T07:50:51.988-0300    don't know what to do with file "mflix\movies.bson.gz", skipping...                                                                   
    2018-10-28T07:50:51.988-0300    don't know what to do with file "mflix\movies.metadata.json.gz", skipping...                                                          
    2018-10-28T07:50:51.989-0300    don't know what to do with file "mflix\sessions.bson.gz", skipping...                                                                 
    2018-10-28T07:50:51.989-0300    don't know what to do with file "mflix\sessions.metadata.json.gz", skipping...                                                        
    2018-10-28T07:50:51.989-0300    don't know what to do with file "mflix\theaters.bson.gz", skipping...                                                                 
    2018-10-28T07:50:51.990-0300    don't know what to do with file "mflix\theaters.metadata.json.gz", skipping...                                                        
    2018-10-28T07:50:51.990-0300    don't know what to do with file "mflix\users.bson.gz", skipping...                                                                    
    2018-10-28T07:50:51.990-0300    don't know what to do with file "mflix\users.metadata.json.gz", skipping...                                                           
    2018-10-28T07:50:51.990-0300    don't know what to do with file "mflix\watching_pings.bson.gz", skipping...                                                           
    2018-10-28T07:50:51.991-0300    don't know what to do with file "mflix\watching_pings.metadata.json.gz", skipping...                                                  
    2018-10-28T07:50:51.991-0300    done