hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Feroze Daud (Jira)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-25382) "No space left on device" error when running show database
Date Tue, 27 Jul 2021 22:17:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-25382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Feroze Daud resolved HIVE-25382.
--------------------------------
    Resolution: Not A Problem

> "No space left on device" error when running show database
> ----------------------------------------------------------
>
>                 Key: HIVE-25382
>                 URL: https://issues.apache.org/jira/browse/HIVE-25382
>             Project: Hive
>          Issue Type: Bug
>          Components: Clients
>    Affects Versions: 2.3.2
>            Reporter: Feroze Daud
>            Priority: Major
>
> We are using Hive provided by Amazon EMR.
> When executing "show database" command, we are getting a "No space left on device" exception.
> {noformat}
> Error running query: show databases like 'my_database' -> java.sql.SQLException: [Amazon][HiveJDBCDriver](500051)
ERROR processing query/statement. Error Code: 1, SQL state: org.apache.hive.service.cli.HiveSQLException:
Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
java.io.IOException: No space left on device
> 	at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:380)
> 	at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:257)
> 	at org.apache.hive.service.cli.operation.SQLOperation.access$800(SQLOperation.java:91)
> 	at org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:348)
> 	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:1844)
> 	at org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:363)
> 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> 	at java.lang.Thread.run(Thread.java:748)
> Caused by: org.apache.hadoop.fs.FSError: java.io.IOException: No space left on device
> 	at org.apache.hadoop.fs.RawLocalFileSystem$LocalFSFileOutputStream.write(RawLocalFileSystem.java:265)
> 	at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
> 	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
> 	at java.io.FilterOutputStream.close(FilterOutputStream.java:158)
> 	at org.apache.hadoop.fs.FSDataOutputStream$PositionCache.close(FSDataOutputStream.java:74)
> 	at org.apache.hadoop.fs.FSDataOutputStream.close(FSDataOutputStream.java:108)
> 	at org.apache.hadoop.fs.ChecksumFileSystem$ChecksumFSOutputSummer.close(ChecksumFileSystem.java:414)
> 	at org.apache.hadoop.fs.FSDataOutputStream$PositionCache.close(FSDataOutputStream.java:74)
> 	at org.apache.hadoop.fs.FSDataOutputStream.close(FSDataOutputStream.java:108)
> 	at org.apache.hadoop.io.IOUtils.cleanup(IOUtils.java:251)
> 	at org.apache.hadoop.io.IOUtils.closeStream(IOUtils.java:268)
> 	at org.apache.hadoop.hive.ql.exec.DDLTask.showDatabases(DDLTask.java:2515)
> 	at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:439)
> 	at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:199)
> 	at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:100)
> 	at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2183)
> 	at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1839)
> 	at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1526)
> 	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1237)
> 	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1232)
> 	at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:255)
> 	... 11 more
> Caused by: java.io.IOException: No space left on device
> 	at java.io.FileOutputStream.writeBytes(Native Method)
> 	at java.io.FileOutputStream.write(FileOutputStream.java:326)
> 	at org.apache.hadoop.fs.RawLocalFileSystem$LocalFSFileOutputStream.write(RawLocalFileSystem.java:263)
> 	... 31 more
> , Query: show databases like 'my_database'. Query: show databases like 'my_database'
Parameters: [] {noformat}
> As mentioned we use Amazon EMR, and it comes with it's own Amazon HiveJdbc client.
> I am not sure if this error is happening on the client or the server. I looked at the
client and dont see any disk space issues.
>  
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message