Sqoop Import Faile "No Space Left on Device"

Mughil — Fri, 16 Sep 2022 11:21:39 GMT

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)

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

tseader — Sat, 01 Apr 2017 16:56:08 GMT

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?

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

Mughil — Mon, 15 May 2017 10:52:11 GMT

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"

Genthandsome — Tue, 10 Jul 2018 22:12:41 GMT

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

question Re: Sqoop Import Faile "No Space Left on Device" in Archives of Support Questions (Read Only)

Sqoop Import Faile "No Space Left on Device"

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

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

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