hive beeline is failing with No space left on device(28) issue

[Satish_Infa]

beeline is failing with no space left on device ,though cluster nodes have enough space

[ParvYadav]

Hi,

Can you share the log lines with us. Also please share the output of df -h.

Thanks!

[Satish_Infa]

hiveserver2 logs lines

Caused by: java.lang.RuntimeException: java.io.IOException: Error: No space left on device(28), file: 5fa24dc7-25c5-4657-ae1d-6ea53f908297, user name: mapr, ID: 30110
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:668) ~[hive-exec-3.1.3.700-eep-932.jar:3.1.3.700-eep-932]
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:603) ~[hive-exec-3.1.3.700-eep-932.jar:3.1.3.700-eep-932]
at org.apache.hive.service.cli.session.HiveSessionImpl.open(HiveSessionImpl.java:170) ~[hive-service-3.1.3.700-eep-932.jar:3.1.3.700-eep-932]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78) ~[hive-service-3.1.3.700-eep-932.jar:3.1.3.700-eep-932]
at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63) ~[hive-service-3.1.3.700-eep-932.jar:3.1.3.700-eep-932]
at java.security.AccessController.doPrivileged(Native Method) ~[?:?]
at javax.security.auth.Subject.doAs(Subject.java:423) ~[?:?]
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:2012) ~[hadoop-common-3.3.5.600-eep-932.jar:?]
at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59) ~[hive-service-3.1.3.700-eep-932.jar:3.1.3.700-eep-932]
at com.sun.proxy.$Proxy31.open(Unknown Source) ~[?:?]
at org.apache.hive.service.cli.session.SessionManager.createSession(SessionManager.java:454) ~[hive-service-3.1.3.700-eep-932.jar:3.1.3.700-eep-932]
... 13 more

beeline> !connect jdbc:hive2://invrh94mpar04.informatica.com:10000/default;ssl=true;saslQop=auth-conf
Connecting to jdbc:hive2://invrh94mpar04.informatica.com:10000/default;ssl=true;saslQop=auth-conf
Enter username for jdbc:hive2://invrh94mpar04.informatica.com:10000/default: mapr
Enter password for jdbc:hive2://invrh94mpar04.informatica.com:10000/default: ****
25/04/21 14:27:44 [main]: WARN jdbc.HiveConnection: Failed to connect to invrh94mpar04.informatica.com:10000
Error: Could not open client transport with JDBC Uri: jdbc:hive2://invrh94mpar04.informatica.com:10000/default;ssl=true;saslQop=auth-conf: Failed to open new session: java.lang.RuntimeException: java.io.IOException: Error: No space left on device(28), file: 5fa24dc7-25c5-4657-ae1d-6ea53f908297, user name: mapr, ID: 30110 (state=08S01,code=0)

[ParvYadav]

Hi,

Thanks for the details.

Can you share below details as well.

1. /opt/mapr/hive/hive-<version>/conf/hive-site.xml

2. df -i

3. du -sh /tmp/*

Thanks!