sqoop 从mysql导入数据到 hadoop出错

蔚落 2021-11-16 22:28 425阅读 0赞

19/07/29 01:42:50 ERROR tool.ImportTool: Import failed: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.hdfs.server.namenode.SafeModeException): Cannot delete /tmp/hadoop-yarn/staging/root/.staging/job\_1564378866238\_0001. Name node is in safe mode.  
The reported blocks 60 needs additional 3 blocks to reach the threshold 0.9990 of total blocks 63.  
The number of live datanodes 2 has reached the minimum number 0. Safe mode will be turned off automatically once the thresholds have been reached.  
    at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkNameNodeSafeMode(FSNamesystem.java:1335)  
    at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.delete(FSNamesystem.java:3681)  
    at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.delete(NameNodeRpcServer.java:953)  
    at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.delete(ClientNamenodeProtocolServerSideTranslatorPB.java:623)  
    at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java)  
    at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:616)  
    at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:982)  
    at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:2217)  
    at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:2213)  
    at java.security.AccessController.doPrivileged(Native Method)  
    at javax.security.auth.Subject.doAs(Subject.java:422)  
    at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1754)  
    at org.apache.hadoop.ipc.Server$Handler.run(Server.java:2213)

at org.apache.hadoop.ipc.Client.call(Client.java:1476)  
    at org.apache.hadoop.ipc.Client.call(Client.java:1413)  
    at org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker.invoke(ProtobufRpcEngine.java:229)  
    at com.sun.proxy.$Proxy11.delete(Unknown Source)  
    at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolTranslatorPB.delete(ClientNamenodeProtocolTranslatorPB.java:545)  
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
    at java.lang.reflect.Method.invoke(Method.java:498)  
    at org.apache.hadoop.io.retry.RetryInvocationHandler.invokeMethod(RetryInvocationHandler.java:191)  
    at org.apache.hadoop.io.retry.RetryInvocationHandler.invoke(RetryInvocationHandler.java:102)  
    at com.sun.proxy.$Proxy12.delete(Unknown Source)  
    at org.apache.hadoop.hdfs.DFSClient.delete(DFSClient.java:2053)  
    at org.apache.hadoop.hdfs.DistributedFileSystem$14.doCall(DistributedFileSystem.java:707)  
    at org.apache.hadoop.hdfs.DistributedFileSystem$14.doCall(DistributedFileSystem.java:703)  
    at org.apache.hadoop.fs.FileSystemLinkResolver.resolve(FileSystemLinkResolver.java:81)  
    at org.apache.hadoop.hdfs.DistributedFileSystem.delete(DistributedFileSystem.java:714)  
    at org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:251)  
    at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1290)  
    at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1287)  
    at java.security.AccessController.doPrivileged(Native Method)  
    at javax.security.auth.Subject.doAs(Subject.java:422)  
    at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1754)  
    at org.apache.hadoop.mapreduce.Job.submit(Job.java:1287)  
    at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:1308)  
    at org.apache.sqoop.mapreduce.ImportJobBase.doSubmitJob(ImportJobBase.java:200)  
    at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:173)  
    at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:270)  
    at org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:692)  
    at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:520)  
    at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:628)  
    at org.apache.sqoop.Sqoop.run(Sqoop.java:147)  
    at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)  
    at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)  
    at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)  
    at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)  
    at org.apache.sqoop.Sqoop.main(Sqoop.java:252)

解决方案:

hadoop dfsadmin \-safemode leave