FAQ
Hi All ,

I tried to look into this issue from various blogs but cant find the
solution , I have setup CDH5 with CM5 every thing works fine expect , Hive
when trying to connect from HUE it gives me below error

"Unable to connect server:10000" , Also i see when i restart the Hive
service its working and after some time the process of Hiveserver2 is doing
down automatically .

Thanks for looking into it .

To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.

Search Discussions

  • Harsh J at May 12, 2014 at 1:04 pm
    Hi Rakesh,

    Your HS2 may be going down due to insufficient heap for the data it
    gets asked to serve. Try raising its heap size to double or triple its
    existing value (the configuration for it is in CM -> Hive ->
    Configuration -> search for "HiveServer2 Heap" as keywords).

    You can also confirm this by looking at the HS2 logs (CM -> Hive ->
    Instances -> HiveServer2 -> Processes -> Role Log Details), or the
    STDOUT/STDERR of the crashed HS2 process (CM -> Hive -> Instances ->
    HiveServer2 -> Processes -> stdout/stderr, before you restart a
    crashed process next time).

    On Mon, May 12, 2014 at 10:21 AM, Rakesh pagadala
    wrote:
    Hi All ,

    I tried to look into this issue from various blogs but cant find the
    solution , I have setup CDH5 with CM5 every thing works fine expect , Hive
    when trying to connect from HUE it gives me below error

    "Unable to connect server:10000" , Also i see when i restart the Hive
    service its working and after some time the process of Hiveserver2 is doing
    down automatically .

    Thanks for looking into it .

    To unsubscribe from this group and stop receiving emails from it, send an
    email to scm-users+unsubscribe@cloudera.org.


    --
    Harsh J

    To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.
  • Rakesh pagadala at May 12, 2014 at 6:47 pm
    I Harish,

    I increased the heap size but still i see the same issue .
    On Monday, May 12, 2014 6:04:02 AM UTC-7, Harsh J wrote:

    Hi Rakesh,

    Your HS2 may be going down due to insufficient heap for the data it
    gets asked to serve. Try raising its heap size to double or triple its
    existing value (the configuration for it is in CM -> Hive ->
    Configuration -> search for "HiveServer2 Heap" as keywords).

    You can also confirm this by looking at the HS2 logs (CM -> Hive ->
    Instances -> HiveServer2 -> Processes -> Role Log Details), or the
    STDOUT/STDERR of the crashed HS2 process (CM -> Hive -> Instances ->
    HiveServer2 -> Processes -> stdout/stderr, before you restart a
    crashed process next time).

    On Mon, May 12, 2014 at 10:21 AM, Rakesh pagadala
    <mr.rakesh...@gmail.com <javascript:>> wrote:
    Hi All ,

    I tried to look into this issue from various blogs but cant find the
    solution , I have setup CDH5 with CM5 every thing works fine expect , Hive
    when trying to connect from HUE it gives me below error

    "Unable to connect server:10000" , Also i see when i restart the Hive
    service its working and after some time the process of Hiveserver2 is doing
    down automatically .

    Thanks for looking into it .

    To unsubscribe from this group and stop receiving emails from it, send an
    email to scm-users+...@cloudera.org <javascript:>.


    --
    Harsh J
    To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.
  • Darren Lo at May 12, 2014 at 6:56 pm
    What was the error in the log of the daemon that crashed?

    On Mon, May 12, 2014 at 11:47 AM, Rakesh pagadala wrote:

    I Harish,

    I increased the heap size but still i see the same issue .
    On Monday, May 12, 2014 6:04:02 AM UTC-7, Harsh J wrote:

    Hi Rakesh,

    Your HS2 may be going down due to insufficient heap for the data it
    gets asked to serve. Try raising its heap size to double or triple its
    existing value (the configuration for it is in CM -> Hive ->
    Configuration -> search for "HiveServer2 Heap" as keywords).

    You can also confirm this by looking at the HS2 logs (CM -> Hive ->
    Instances -> HiveServer2 -> Processes -> Role Log Details), or the
    STDOUT/STDERR of the crashed HS2 process (CM -> Hive -> Instances ->
    HiveServer2 -> Processes -> stdout/stderr, before you restart a
    crashed process next time).

    On Mon, May 12, 2014 at 10:21 AM, Rakesh pagadala
    wrote:
    Hi All ,

    I tried to look into this issue from various blogs but cant find the
    solution , I have setup CDH5 with CM5 every thing works fine expect , Hive
    when trying to connect from HUE it gives me below error

    "Unable to connect server:10000" , Also i see when i restart the Hive
    service its working and after some time the process of Hiveserver2 is doing
    down automatically .

    Thanks for looking into it .

    To unsubscribe from this group and stop receiving emails from it, send an
    email to scm-users+...@cloudera.org.


    --
    Harsh J
    To unsubscribe from this group and stop receiving emails from it, send an
    email to scm-users+unsubscribe@cloudera.org.
    To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.
  • Rakesh pagadala at May 12, 2014 at 7:04 pm
    Please find attached logs after increasing heap size to 3gb

    ------------------------------------------------------------------------
    1:59:29.311 AM ERROR hive.log

    Got exception: org.apache.thrift.transport.TTransportException
    java.net.SocketTimeoutException: Read timed out
    org.apache.thrift.transport.TTransportException:
    java.net.SocketTimeoutException: Read timed out
      at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:129)
      at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)
      at org.apache.thrift.protocol.TBinaryProtocol.readStringBody(TBinaryProtocol.java:354)
      at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:215)
      at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)
      at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_databases(ThriftHiveMetastore.java:504)
      at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_databases(ThriftHiveMetastore.java:491)
      at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getDatabases(HiveMetaStoreClient.java:727)
      at org.apache.hive.service.cli.operation.GetTablesOperation.run(GetTablesOperation.java:88)
      at org.apache.hive.service.cli.session.HiveSessionImpl.runOperationWithLogCapture(HiveSessionImpl.java:514)
      at org.apache.hive.service.cli.session.HiveSessionImpl.getTables(HiveSessionImpl.java:305)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:62)
      at java.security.AccessController.doPrivileged(Native Method)
      at javax.security.auth.Subject.doAs(Subject.java:415)
      at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1548)
      at org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:554)
      at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:57)
      at com.sun.proxy.$Proxy12.getTables(Unknown Source)
      at org.apache.hive.service.cli.CLIService.getTables(CLIService.java:236)
      at org.apache.hive.service.cli.thrift.ThriftCLIService.GetTables(ThriftCLIService.java:375)
      at org.apache.hive.service.cli.thrift.TCLIService$Processor$GetTables.getResult(TCLIService.java:1453)
      at org.apache.hive.service.cli.thrift.TCLIService$Processor$GetTables.getResult(TCLIService.java:1438)
      at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
      at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
      at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:57)
      at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:244)
      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:744)
    Caused by: java.net.SocketTimeoutException: Read timed out
      at java.net.SocketInputStream.socketRead0(Native Method)
      at java.net.SocketInputStream.read(SocketInputStream.java:152)
      at java.net.SocketInputStream.read(SocketInputStream.java:122)
      at java.io.BufferedInputStream.read1(BufferedInputStream.java:273)
      at java.io.BufferedInputStream.read(BufferedInputStream.java:334)
      at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:127)
      ... 32 more

      11:59:29.314 AM ERROR hive.log

    Converting exception to MetaException



    On Mon, May 12, 2014 at 11:47 AM, Rakesh pagadala wrote:

    I Harish,

    I increased the heap size but still i see the same issue .
    On Monday, May 12, 2014 6:04:02 AM UTC-7, Harsh J wrote:

    Hi Rakesh,

    Your HS2 may be going down due to insufficient heap for the data it
    gets asked to serve. Try raising its heap size to double or triple its
    existing value (the configuration for it is in CM -> Hive ->
    Configuration -> search for "HiveServer2 Heap" as keywords).

    You can also confirm this by looking at the HS2 logs (CM -> Hive ->
    Instances -> HiveServer2 -> Processes -> Role Log Details), or the
    STDOUT/STDERR of the crashed HS2 process (CM -> Hive -> Instances ->
    HiveServer2 -> Processes -> stdout/stderr, before you restart a
    crashed process next time).

    On Mon, May 12, 2014 at 10:21 AM, Rakesh pagadala
    wrote:
    Hi All ,

    I tried to look into this issue from various blogs but cant find the
    solution , I have setup CDH5 with CM5 every thing works fine expect , Hive
    when trying to connect from HUE it gives me below error

    "Unable to connect server:10000" , Also i see when i restart the Hive
    service its working and after some time the process of Hiveserver2 is doing
    down automatically .

    Thanks for looking into it .

    To unsubscribe from this group and stop receiving emails from it, send an
    email to scm-users+...@cloudera.org.


    --
    Harsh J
    To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.
  • Darren Lo at May 12, 2014 at 7:47 pm
    I'm assuming these are the logs for HS2. This error says it's having
    problems connecting to the metastore. What do your Hive Metastore logs say?

    On Mon, May 12, 2014 at 12:03 PM, Rakesh pagadala wrote:

    Please find attached logs after increasing heap size to 3gb

    ------------------------------------------------------------------------
    1:59:29.311 AM ERROR hive.log

    Got exception: org.apache.thrift.transport.TTransportException java.net.SocketTimeoutException: Read timed out
    org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
    at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:129)
    at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)
    at org.apache.thrift.protocol.TBinaryProtocol.readStringBody(TBinaryProtocol.java:354)
    at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:215)
    at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)
    at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_databases(ThriftHiveMetastore.java:504)
    at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_databases(ThriftHiveMetastore.java:491)
    at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getDatabases(HiveMetaStoreClient.java:727)
    at org.apache.hive.service.cli.operation.GetTablesOperation.run(GetTablesOperation.java:88)
    at org.apache.hive.service.cli.session.HiveSessionImpl.runOperationWithLogCapture(HiveSessionImpl.java:514)
    at org.apache.hive.service.cli.session.HiveSessionImpl.getTables(HiveSessionImpl.java:305)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:62)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAs(Subject.java:415)
    at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1548)
    at org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:554)
    at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:57)
    at com.sun.proxy.$Proxy12.getTables(Unknown Source)
    at org.apache.hive.service.cli.CLIService.getTables(CLIService.java:236)
    at org.apache.hive.service.cli.thrift.ThriftCLIService.GetTables(ThriftCLIService.java:375)
    at org.apache.hive.service.cli.thrift.TCLIService$Processor$GetTables.getResult(TCLIService.java:1453)
    at org.apache.hive.service.cli.thrift.TCLIService$Processor$GetTables.getResult(TCLIService.java:1438)
    at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
    at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
    at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:57)
    at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:244)
    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:744)
    Caused by: java.net.SocketTimeoutException: Read timed out
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(SocketInputStream.java:152)
    at java.net.SocketInputStream.read(SocketInputStream.java:122)
    at java.io.BufferedInputStream.read1(BufferedInputStream.java:273)
    at java.io.BufferedInputStream.read(BufferedInputStream.java:334)
    at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:127)
    ... 32 more

    11:59:29.314 AM ERROR hive.log

    Converting exception to MetaException




    On Mon, May 12, 2014 at 11:47 AM, Rakesh pagadala <
    mr.rakesh.pagadala@gmail.com> wrote:
    I Harish,

    I increased the heap size but still i see the same issue .
    On Monday, May 12, 2014 6:04:02 AM UTC-7, Harsh J wrote:

    Hi Rakesh,

    Your HS2 may be going down due to insufficient heap for the data it
    gets asked to serve. Try raising its heap size to double or triple its
    existing value (the configuration for it is in CM -> Hive ->
    Configuration -> search for "HiveServer2 Heap" as keywords).

    You can also confirm this by looking at the HS2 logs (CM -> Hive ->
    Instances -> HiveServer2 -> Processes -> Role Log Details), or the
    STDOUT/STDERR of the crashed HS2 process (CM -> Hive -> Instances ->
    HiveServer2 -> Processes -> stdout/stderr, before you restart a
    crashed process next time).

    On Mon, May 12, 2014 at 10:21 AM, Rakesh pagadala
    wrote:
    Hi All ,

    I tried to look into this issue from various blogs but cant find the
    solution , I have setup CDH5 with CM5 every thing works fine expect , Hive
    when trying to connect from HUE it gives me below error

    "Unable to connect server:10000" , Also i see when i restart the Hive
    service its working and after some time the process of Hiveserver2 is doing
    down automatically .

    Thanks for looking into it .

    To unsubscribe from this group and stop receiving emails from it, send an
    email to scm-users+...@cloudera.org.


    --
    Harsh J
    To unsubscribe from this group and stop receiving emails from it, send an
    email to scm-users+unsubscribe@cloudera.org.
    To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupscm-users @
categorieshadoop
postedMay 12, '14 at 4:51a
activeMay 12, '14 at 7:47p
posts6
users3
websitecloudera.com
irc#hadoop

People

Translate

site design / logo © 2022 Grokbase