Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop Import Faile "No Space Left on Device"

Solved Go to solution

Sqoop Import Faile "No Space Left on Device"

Explorer

Sqoop unable to import data into hadoop thorwing error as " No Space Left on Device" on random table. We have plenty of space on both HDFS and Local FS. Not sure why,  Please let me know how to fix it.

 

 

 ALTR_DESC WHERE 1=1 WITH UR
2017-03-29 00:32:27 ERROR SqoopThread:165 - Error occurred while importing data HALS.CLOUD_AESC
java.lang.RuntimeException: java.io.FileNotFoundException: /apps/data/cloud.log 170329.003227.HALSDBP3.1694.TBA_ALTR_DESC.log (No space left on device)
        at com.apache.sqoop.log.LogWriter.close(LogWriter.java:137)
        at com.apache.sqoop.log.LogWriter.flush(LogWriter.java:155)
        at com.apche.sqoop.log.LogWriter.write(LogWriter.java:41)
        at com.apache.sqoop.service.SqoopThread.run(SqoopThread.java:100)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.io.FileNotFoundException: /apps/data/cloud.log/170329.003227.HALSDBP3.1694.TBA_ALTR_DESC.log (No space left on device)
        at java.io.FileOutputStream.open(Native Method)
        at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
        at java.io.FileOutputStream.<init>(FileOutputStream.java:142)
        at java.io.FileWriter.<init>(FileWriter.java:78)
        at com.apache.sqoop.log.LogWriter.close(LogWriter.java:127)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Sqoop Import Faile "No Space Left on Device"

Explorer

We found the problem. It not related to Disk Space. Problem with Directory index full of the directory

3 REPLIES 3

Re: Sqoop Import Faile "No Space Left on Device"

Rising Star

Can you confirm that you have enough space in the error's logging directories listed? Perhaps they are on different mount points that do not have the same capacity as other directories you have setup?

Highlighted

Re: Sqoop Import Faile "No Space Left on Device"

Explorer

We found the problem. It not related to Disk Space. Problem with Directory index full of the directory

Re: Sqoop Import Faile "No Space Left on Device"

@MughilWhat did you do,,,, How did you diagnose the problem? Where is the directory index?

Don't have an account?
Coming from Hortonworks? Activate your account here