Hadoop: …be replicated to 0 nodes instead of minReplication (=1). There are 1 datanode(s) running and no node(s) are excluded in this operation

Lab Support
#1

I’m getting the following error when attempting to write to HDFS as part of my sqoop application

/*
could only be replicated to 0 nodes instead of minReplication (=1). There are 1 datanode(s) running and no node(s) are excluded in this operation.
*/

This error is caused by the block replication system of HDFS since it could not manage to make any copies of a specific block within the focused file

Please find the below sqoop command

sqoop import
–connect “jdbc:mysql://ip-172-31-13-154:3306/retail_db”
–username sqoopuser
–password NHkkP876rp \
–table weather
–target-dir /user/…

#2

Hi @Mahesh,

I’ve restarted data nodes.

Can you please check now?

#3

Yeah…its fine now thank you very much :slight_smile:

#4

Hi @abhinav, I am getting same error now. Can you please help me out too ? Are we authorized to restart data nodes ? and if yes, what are the steps ?

#5

Hi @Piyush_Patil,

Can you please check now? I’ve restarted datanodes.

Thanks

#6

That helped. Thanks !

#7

@abhinav Could you please restart the server again. I am getting the same error message.

could only be replicated to 0 nodes instead of minReplication (=1). There are 6 datanod
e(s) running and no node(s) are excluded in this operation

#8

I am also getting the same error.