[jira] [Commented] (IMPALA-10120) Beeline hangs when connecting to coordinators
[ https://issues.apache.org/jira/browse/IMPALA-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17292401#comment-17292401 ] Quanlong Huang commented on IMPALA-10120: - Look back into this, the issue still exists. The invalid query option doesn't cause the hanging. In the jstack of beeline client, it's waiting for response of GetInfo(): {code:java} "main" #1 prio=5 os_prio=0 tid=0x7f5c9c034000 nid=0x3bec runnable [0x7f5ca29bd000] java.lang.Thread.State: RUNNABLE at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at java.io.BufferedInputStream.fill(BufferedInputStream.java:246) at java.io.BufferedInputStream.read1(BufferedInputStream.java:286) at java.io.BufferedInputStream.read(BufferedInputStream.java:345) - locked <0xfeb239c8> (a java.io.BufferedInputStream) at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:127) at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86) at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:429) at org.apache.thrift.protocol.TBinaryProtocol.readByte(TBinaryProtocol.java:285) at org.apache.thrift.protocol.TBinaryProtocol.readFieldBegin(TBinaryProtocol.java:243) at org.apache.hive.service.rpc.thrift.TCLIService$GetInfo_result$GetInfo_resultStandardScheme.read(TCLIService.java:5261) at org.apache.hive.service.rpc.thrift.TCLIService$GetInfo_result$GetInfo_resultStandardScheme.read(TCLIService.java:5254) at org.apache.hive.service.rpc.thrift.TCLIService$GetInfo_result.read(TCLIService.java:5201) at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86) at org.apache.hive.service.rpc.thrift.TCLIService$Client.recv_GetInfo(TCLIService.java:222) at org.apache.hive.service.rpc.thrift.TCLIService$Client.GetInfo(TCLIService.java:209) < A GetInfo Request at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hive.jdbc.HiveConnection$SynchronizedHandler.invoke(HiveConnection.java:1727) at com.sun.proxy.$Proxy21.GetInfo(Unknown Source) at org.apache.hive.jdbc.HiveDatabaseMetaData.getServerInfo(HiveDatabaseMetaData.java:1232) at org.apache.hive.jdbc.HiveDatabaseMetaData.getSQLKeywords(HiveDatabaseMetaData.java:632) at org.apache.hive.beeline.SQLCompleter.getSQLCompleters(SQLCompleter.java:56) at org.apache.hive.beeline.DatabaseConnection.setCompletions(DatabaseConnection.java:99) at org.apache.hive.beeline.BeeLine.setCompletions(BeeLine.java:2411) at org.apache.hive.beeline.Commands.connect(Commands.java:1693) at org.apache.hive.beeline.Commands.connect(Commands.java:1574) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hive.beeline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:56) at org.apache.hive.beeline.BeeLine.execCommandWithPrefix(BeeLine.java:1456) at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:1495) at org.apache.hive.beeline.BeeLine.connectUsingArgs(BeeLine.java:917) at org.apache.hive.beeline.BeeLine.initArgs(BeeLine.java:803) at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:1108) at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:1082) at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:546) at org.apache.hive.beeline.BeeLine.main(BeeLine.java:528) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:318) at org.apache.hadoop.util.RunJar.main(RunJar.java:232) {code} However, doing a minidump on impalad and resolving it doesn't find any hanging threads doing the GetInfo request. Impalad may already return it. But Beeline client fails t
[jira] [Commented] (IMPALA-10120) Beeline hangs when connecting to coordinators
[ https://issues.apache.org/jira/browse/IMPALA-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17528016#comment-17528016 ] Quanlong Huang commented on IMPALA-10120: - Looking back into this, the sympton is slightly different. I can trigger a query, e.g. "show tables". But it's hanging: {code} $ beeline -u "jdbc:hive2://localhost:21050/default;auth=noSasl" SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-23144489/apache-hive-3.1.3000.7.2.15.0-88-bin/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-23144489/hadoop-3.1.1.7.2.15.0-88/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-23144489/apache-hive-3.1.3000.7.2.15.0-88-bin/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-23144489/hadoop-3.1.1.7.2.15.0-88/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Connecting to jdbc:hive2://localhost:21050/default;auth=noSasl Connected to: Impala (version 4.1.0-SNAPSHOT) Driver: Hive JDBC (version 3.1.3000.7.2.15.0-88) Transaction isolation: TRANSACTION_REPEATABLE_READ Beeline version 3.1.3000.7.2.15.0-88 by Apache Hive 0: jdbc:hive2://localhost:21050/default> show tables; {code} jstack of the thread: {code} "main" #1 prio=5 os_prio=0 tid=0x7fe0dc03a000 nid=0x7355 runnable [0x7fe0e4c33000] java.lang.Thread.State: RUNNABLE at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at java.io.BufferedInputStream.read1(BufferedInputStream.java:284) at java.io.BufferedInputStream.read(BufferedInputStream.java:345) - locked <0xff8c0e28> (a java.io.BufferedInputStream) at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:125) at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86) at org.apache.thrift.protocol.TBinaryProtocol.readStringBody(TBinaryProtocol.java:411) at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:254) at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:77) at org.apache.hive.service.rpc.thrift.TCLIService$Client.recv_ExecuteStatement(TCLIService.java:218) at org.apache.hive.service.rpc.thrift.TCLIService$Client.ExecuteStatement(TCLIService.java:205) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hive.jdbc.HiveConnection$SynchronizedHandler.invoke(HiveConnection.java:1986) at com.sun.proxy.$Proxy21.ExecuteStatement(Unknown Source) at org.apache.hive.jdbc.HiveStatement.runAsyncOnServer(HiveStatement.java:333) at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:275) at org.apache.hive.beeline.Commands.executeInternal(Commands.java:1007) at org.apache.hive.beeline.Commands.execute(Commands.java:1217) at org.apache.hive.beeline.Commands.sql(Commands.java:1146) at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:1504) at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:1362) at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:1141) at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:1089) at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:547) at org.apache.hive.beeline.BeeLine.main(BeeLine.java:529) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498
[jira] [Commented] (IMPALA-10120) Beeline hangs when connecting to coordinators
[ https://issues.apache.org/jira/browse/IMPALA-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532604#comment-17532604 ] Quanlong Huang commented on IMPALA-10120: - In the above case, Hive jdbc driver uses thrift-0.13.0, while Impala uses thrift-0.11.0. So the client version is higher than the server version. This could be the cause. > Beeline hangs when connecting to coordinators > - > > Key: IMPALA-10120 > URL: https://issues.apache.org/jira/browse/IMPALA-10120 > Project: IMPALA > Issue Type: Bug > Components: Clients >Reporter: Quanlong Huang >Priority: Critical > > Beeline is always hanging when connecting to a coordinator: > {code:java} > $ beeline -u "jdbc:hive2://localhost:21050/default;auth=noSasl" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > ERROR StatusLogger No log4j2 configuration file found. Using default > configuration: logging only errors to the console. Set system property > 'log4j2.debug' to show Log4j2 internal initialization logging. > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:21050/default;auth=noSasl > Connected to: Impala (version 4.0.0-SNAPSHOT) > Driver: Hive JDBC (version 3.1.3000.7.2.1.0-287) > Transaction isolation: TRANSACTION_REPEATABLE_READ > {code} > Looking into the impalad log file, there is a wrong option set: > {code:java} > I0901 15:41:14.577576 25325 TAcceptQueueServer.cpp:340] New connection to > server hiveserver2-frontend from client > I0901 15:41:14.577911 25597 impala-hs2-server.cc:300] Opening session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 request username: > I0901 15:41:14.577970 25597 status.cc:129] Invalid query option: > set:hiveconf:hive.server2.thrift.resultset.default.fetch.size > @ 0x1cdba3d impala::Status::Status() > @ 0x24c673f impala::SetQueryOption() > @ 0x250c1d1 impala::ImpalaServer::OpenSession() > @ 0x2b0dc45 > apache::hive::service::cli::thrift::TCLIServiceProcessor::process_OpenSession() > @ 0x2b0d993 > apache::hive::service::cli::thrift::TCLIServiceProcessor::dispatchCall() > @ 0x2acd15a > impala::ImpalaHiveServer2ServiceProcessor::dispatchCall() > @ 0x1c8a483 apache::thrift::TDispatchProcessor::process() > @ 0x218ab4a > apache::thrift::server::TAcceptQueueServer::Task::run() > @ 0x218004a impala::ThriftThread::RunRunnable() > @ 0x2181686 boost::_mfi::mf2<>::operator()() > @ 0x218151a boost::_bi::list3<>::operator()<>() > @ 0x2181260 boost::_bi::bind_t<>::operator()() > @ 0x2181172 > boost::detail::function::void_function_obj_invoker0<>::invoke() > @ 0x20fba57 boost::function0<>::operator()() > @ 0x26cb779 impala::Thread::SuperviseThread() > @ 0x26d3716 boost::_bi::list5<>::operator()<>() > @ 0x26d363a boost::_bi::bind_t<>::operator()() > @ 0x26d35fb boost::detail::thread_data<>::run() > @ 0x3eb7ae1 thread_proxy > @ 0x7fc9443456b9 start_thread > @ 0x7fc940e334dc clone > I0901 15:41:14.739985 25597 impala-hs2-server.cc:405] Opened session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 effective username: > I0901 15:41:14.781677 25597 impala-hs2-server.cc:426] GetInfo(): > request=TGetInfoReq { > 01: sessionHandle (struct) = TSessionHandle { > 01: sessionId (struct) = THandleIdentifier { > 01: guid (string) = "\xea(\x8e\xcc3?J \xa7j\xb2\x96\xab\x15\xa9\xd6", > 02: secret (string) =
[jira] [Commented] (IMPALA-10120) Beeline hangs when connecting to coordinators
[ https://issues.apache.org/jira/browse/IMPALA-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17219768#comment-17219768 ] Sahil Takiar commented on IMPALA-10120: --- Not particularly familiar with that config, but this is what the Hive code has to say about it: {code:java} HIVE_SERVER2_THRIFT_RESULTSET_DEFAULT_FETCH_SIZE("hive.server2.thrift.resultset.default.fetch.size", 1000, "The number of rows sent in one Fetch RPC call by the server to the client, if not\n" + "specified by the client."), {code} > Beeline hangs when connecting to coordinators > - > > Key: IMPALA-10120 > URL: https://issues.apache.org/jira/browse/IMPALA-10120 > Project: IMPALA > Issue Type: Bug >Reporter: Quanlong Huang >Priority: Critical > > Beeline is always hanging when connecting to a coordinator: > {code:java} > $ beeline -u "jdbc:hive2://localhost:21050/default;auth=noSasl" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > ERROR StatusLogger No log4j2 configuration file found. Using default > configuration: logging only errors to the console. Set system property > 'log4j2.debug' to show Log4j2 internal initialization logging. > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:21050/default;auth=noSasl > Connected to: Impala (version 4.0.0-SNAPSHOT) > Driver: Hive JDBC (version 3.1.3000.7.2.1.0-287) > Transaction isolation: TRANSACTION_REPEATABLE_READ > {code} > Looking into the impalad log file, there is a wrong option set: > {code:java} > I0901 15:41:14.577576 25325 TAcceptQueueServer.cpp:340] New connection to > server hiveserver2-frontend from client > I0901 15:41:14.577911 25597 impala-hs2-server.cc:300] Opening session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 request username: > I0901 15:41:14.577970 25597 status.cc:129] Invalid query option: > set:hiveconf:hive.server2.thrift.resultset.default.fetch.size > @ 0x1cdba3d impala::Status::Status() > @ 0x24c673f impala::SetQueryOption() > @ 0x250c1d1 impala::ImpalaServer::OpenSession() > @ 0x2b0dc45 > apache::hive::service::cli::thrift::TCLIServiceProcessor::process_OpenSession() > @ 0x2b0d993 > apache::hive::service::cli::thrift::TCLIServiceProcessor::dispatchCall() > @ 0x2acd15a > impala::ImpalaHiveServer2ServiceProcessor::dispatchCall() > @ 0x1c8a483 apache::thrift::TDispatchProcessor::process() > @ 0x218ab4a > apache::thrift::server::TAcceptQueueServer::Task::run() > @ 0x218004a impala::ThriftThread::RunRunnable() > @ 0x2181686 boost::_mfi::mf2<>::operator()() > @ 0x218151a boost::_bi::list3<>::operator()<>() > @ 0x2181260 boost::_bi::bind_t<>::operator()() > @ 0x2181172 > boost::detail::function::void_function_obj_invoker0<>::invoke() > @ 0x20fba57 boost::function0<>::operator()() > @ 0x26cb779 impala::Thread::SuperviseThread() > @ 0x26d3716 boost::_bi::list5<>::operator()<>() > @ 0x26d363a boost::_bi::bind_t<>::operator()() > @ 0x26d35fb boost::detail::thread_data<>::run() > @ 0x3eb7ae1 thread_proxy > @ 0x7fc9443456b9 start_thread > @ 0x7fc940e334dc clone > I0901 15:41:14.739985 25597 impala-hs2-server.cc:405] Opened session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 effective username: > I0901 15:41:14.781677 25597 impala-hs2-server.cc:426] GetInfo(): > request=TGetInfoReq { > 01: sessionHandle (struct) = TSessionHandle { > 01
[jira] [Commented] (IMPALA-10120) Beeline hangs when connecting to coordinators
[ https://issues.apache.org/jira/browse/IMPALA-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17753061#comment-17753061 ] xiongyinke commented on IMPALA-10120: - I encountered a similar situation where I was using beeline with Hive 3.1.3 to connect to Impala 4.1 with Kerberos. Upgrading the Hive Thrift version to 0.11.0 resolved the issue of hanging during connection, but hanging still occurred when executing "show databases" and "show tables". [~stigahuang] Did you eventually solve this issue? > Beeline hangs when connecting to coordinators > - > > Key: IMPALA-10120 > URL: https://issues.apache.org/jira/browse/IMPALA-10120 > Project: IMPALA > Issue Type: Bug > Components: Clients >Reporter: Quanlong Huang >Assignee: XiangYang >Priority: Critical > > Beeline is always hanging when connecting to a coordinator: > {code:java} > $ beeline -u "jdbc:hive2://localhost:21050/default;auth=noSasl" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > ERROR StatusLogger No log4j2 configuration file found. Using default > configuration: logging only errors to the console. Set system property > 'log4j2.debug' to show Log4j2 internal initialization logging. > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:21050/default;auth=noSasl > Connected to: Impala (version 4.0.0-SNAPSHOT) > Driver: Hive JDBC (version 3.1.3000.7.2.1.0-287) > Transaction isolation: TRANSACTION_REPEATABLE_READ > {code} > Looking into the impalad log file, there is a wrong option set: > {code:java} > I0901 15:41:14.577576 25325 TAcceptQueueServer.cpp:340] New connection to > server hiveserver2-frontend from client > I0901 15:41:14.577911 25597 impala-hs2-server.cc:300] Opening session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 request username: > I0901 15:41:14.577970 25597 status.cc:129] Invalid query option: > set:hiveconf:hive.server2.thrift.resultset.default.fetch.size > @ 0x1cdba3d impala::Status::Status() > @ 0x24c673f impala::SetQueryOption() > @ 0x250c1d1 impala::ImpalaServer::OpenSession() > @ 0x2b0dc45 > apache::hive::service::cli::thrift::TCLIServiceProcessor::process_OpenSession() > @ 0x2b0d993 > apache::hive::service::cli::thrift::TCLIServiceProcessor::dispatchCall() > @ 0x2acd15a > impala::ImpalaHiveServer2ServiceProcessor::dispatchCall() > @ 0x1c8a483 apache::thrift::TDispatchProcessor::process() > @ 0x218ab4a > apache::thrift::server::TAcceptQueueServer::Task::run() > @ 0x218004a impala::ThriftThread::RunRunnable() > @ 0x2181686 boost::_mfi::mf2<>::operator()() > @ 0x218151a boost::_bi::list3<>::operator()<>() > @ 0x2181260 boost::_bi::bind_t<>::operator()() > @ 0x2181172 > boost::detail::function::void_function_obj_invoker0<>::invoke() > @ 0x20fba57 boost::function0<>::operator()() > @ 0x26cb779 impala::Thread::SuperviseThread() > @ 0x26d3716 boost::_bi::list5<>::operator()<>() > @ 0x26d363a boost::_bi::bind_t<>::operator()() > @ 0x26d35fb boost::detail::thread_data<>::run() > @ 0x3eb7ae1 thread_proxy > @ 0x7fc9443456b9 start_thread > @ 0x7fc940e334dc clone > I0901 15:41:14.739985 25597 impala-hs2-server.cc:405] Opened session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 effective username: > I0901 15:41:14.781677 25597 impala-hs2-server.cc:426] GetInfo(): > request=TGetInfoReq { > 01: session
[jira] [Commented] (IMPALA-10120) Beeline hangs when connecting to coordinators
[ https://issues.apache.org/jira/browse/IMPALA-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17753089#comment-17753089 ] xiongyinke commented on IMPALA-10120: - This issue is related to HIVE-17765, and after I revert that patch in Hive3.1.3, Beeline was able to connect to Impala normally. > Beeline hangs when connecting to coordinators > - > > Key: IMPALA-10120 > URL: https://issues.apache.org/jira/browse/IMPALA-10120 > Project: IMPALA > Issue Type: Bug > Components: Clients >Reporter: Quanlong Huang >Assignee: XiangYang >Priority: Critical > > Beeline is always hanging when connecting to a coordinator: > {code:java} > $ beeline -u "jdbc:hive2://localhost:21050/default;auth=noSasl" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > ERROR StatusLogger No log4j2 configuration file found. Using default > configuration: logging only errors to the console. Set system property > 'log4j2.debug' to show Log4j2 internal initialization logging. > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:21050/default;auth=noSasl > Connected to: Impala (version 4.0.0-SNAPSHOT) > Driver: Hive JDBC (version 3.1.3000.7.2.1.0-287) > Transaction isolation: TRANSACTION_REPEATABLE_READ > {code} > Looking into the impalad log file, there is a wrong option set: > {code:java} > I0901 15:41:14.577576 25325 TAcceptQueueServer.cpp:340] New connection to > server hiveserver2-frontend from client > I0901 15:41:14.577911 25597 impala-hs2-server.cc:300] Opening session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 request username: > I0901 15:41:14.577970 25597 status.cc:129] Invalid query option: > set:hiveconf:hive.server2.thrift.resultset.default.fetch.size > @ 0x1cdba3d impala::Status::Status() > @ 0x24c673f impala::SetQueryOption() > @ 0x250c1d1 impala::ImpalaServer::OpenSession() > @ 0x2b0dc45 > apache::hive::service::cli::thrift::TCLIServiceProcessor::process_OpenSession() > @ 0x2b0d993 > apache::hive::service::cli::thrift::TCLIServiceProcessor::dispatchCall() > @ 0x2acd15a > impala::ImpalaHiveServer2ServiceProcessor::dispatchCall() > @ 0x1c8a483 apache::thrift::TDispatchProcessor::process() > @ 0x218ab4a > apache::thrift::server::TAcceptQueueServer::Task::run() > @ 0x218004a impala::ThriftThread::RunRunnable() > @ 0x2181686 boost::_mfi::mf2<>::operator()() > @ 0x218151a boost::_bi::list3<>::operator()<>() > @ 0x2181260 boost::_bi::bind_t<>::operator()() > @ 0x2181172 > boost::detail::function::void_function_obj_invoker0<>::invoke() > @ 0x20fba57 boost::function0<>::operator()() > @ 0x26cb779 impala::Thread::SuperviseThread() > @ 0x26d3716 boost::_bi::list5<>::operator()<>() > @ 0x26d363a boost::_bi::bind_t<>::operator()() > @ 0x26d35fb boost::detail::thread_data<>::run() > @ 0x3eb7ae1 thread_proxy > @ 0x7fc9443456b9 start_thread > @ 0x7fc940e334dc clone > I0901 15:41:14.739985 25597 impala-hs2-server.cc:405] Opened session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 effective username: > I0901 15:41:14.781677 25597 impala-hs2-server.cc:426] GetInfo(): > request=TGetInfoReq { > 01: sessionHandle (struct) = TSessionHandle { > 01: sessionId (struct) = THandleIdentifier { > 01: guid (string) = "\xea(\x8e\xcc3?J \xa7j\xb2\x96\xab\x15\xa9\xd6", > 02: secret (string) = "\xf9\x11\xac\xf5
[jira] [Commented] (IMPALA-10120) Beeline hangs when connecting to coordinators
[ https://issues.apache.org/jira/browse/IMPALA-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17753206#comment-17753206 ] XiangYang commented on IMPALA-10120: Hi quanlong, I found that the reason why beeline hang at 'HiveDatabaseMetaData.getServerInfo()' maybe because of TGetInfoResp has two required fields(see: [https://github.com/apache/hive/blob/rel/release-3.1.3/service-rpc/if/TCLIService.thrift#L700] ), but impala server only return one field when error(see: [https://github.com/apache/impala/blob/4.0.0/be/src/service/impala-hs2-server.cc#L457]). Although the latest version beeline doesn't hang at 'HiveDatabaseMetaData.getServerInfo()', it can run happily after I fix the above implementation error :) > Beeline hangs when connecting to coordinators > - > > Key: IMPALA-10120 > URL: https://issues.apache.org/jira/browse/IMPALA-10120 > Project: IMPALA > Issue Type: Bug > Components: Clients >Reporter: Quanlong Huang >Assignee: XiangYang >Priority: Critical > > Beeline is always hanging when connecting to a coordinator: > {code:java} > $ beeline -u "jdbc:hive2://localhost:21050/default;auth=noSasl" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > ERROR StatusLogger No log4j2 configuration file found. Using default > configuration: logging only errors to the console. Set system property > 'log4j2.debug' to show Log4j2 internal initialization logging. > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:21050/default;auth=noSasl > Connected to: Impala (version 4.0.0-SNAPSHOT) > Driver: Hive JDBC (version 3.1.3000.7.2.1.0-287) > Transaction isolation: TRANSACTION_REPEATABLE_READ > {code} > Looking into the impalad log file, there is a wrong option set: > {code:java} > I0901 15:41:14.577576 25325 TAcceptQueueServer.cpp:340] New connection to > server hiveserver2-frontend from client > I0901 15:41:14.577911 25597 impala-hs2-server.cc:300] Opening session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 request username: > I0901 15:41:14.577970 25597 status.cc:129] Invalid query option: > set:hiveconf:hive.server2.thrift.resultset.default.fetch.size > @ 0x1cdba3d impala::Status::Status() > @ 0x24c673f impala::SetQueryOption() > @ 0x250c1d1 impala::ImpalaServer::OpenSession() > @ 0x2b0dc45 > apache::hive::service::cli::thrift::TCLIServiceProcessor::process_OpenSession() > @ 0x2b0d993 > apache::hive::service::cli::thrift::TCLIServiceProcessor::dispatchCall() > @ 0x2acd15a > impala::ImpalaHiveServer2ServiceProcessor::dispatchCall() > @ 0x1c8a483 apache::thrift::TDispatchProcessor::process() > @ 0x218ab4a > apache::thrift::server::TAcceptQueueServer::Task::run() > @ 0x218004a impala::ThriftThread::RunRunnable() > @ 0x2181686 boost::_mfi::mf2<>::operator()() > @ 0x218151a boost::_bi::list3<>::operator()<>() > @ 0x2181260 boost::_bi::bind_t<>::operator()() > @ 0x2181172 > boost::detail::function::void_function_obj_invoker0<>::invoke() > @ 0x20fba57 boost::function0<>::operator()() > @ 0x26cb779 impala::Thread::SuperviseThread() > @ 0x26d3716 boost::_bi::list5<>::operator()<>() > @ 0x26d363a boost::_bi::bind_t<>::operator()() > @ 0x26d35fb boost::detail::thread_data<>::run() > @ 0x3eb7ae1 thread_proxy > @ 0x7fc9443456b9 start_thread > @ 0x7fc940e334dc clone > I0901 15:41:14
[jira] [Commented] (IMPALA-10120) Beeline hangs when connecting to coordinators
[ https://issues.apache.org/jira/browse/IMPALA-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17761728#comment-17761728 ] Zhi Tang commented on IMPALA-10120: --- Hi, [~yx91490] and [~stigahuang]! Has there been any progress on this issue? > Beeline hangs when connecting to coordinators > - > > Key: IMPALA-10120 > URL: https://issues.apache.org/jira/browse/IMPALA-10120 > Project: IMPALA > Issue Type: Bug > Components: Clients >Reporter: Quanlong Huang >Assignee: XiangYang >Priority: Critical > > Beeline is always hanging when connecting to a coordinator: > {code:java} > $ beeline -u "jdbc:hive2://localhost:21050/default;auth=noSasl" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > ERROR StatusLogger No log4j2 configuration file found. Using default > configuration: logging only errors to the console. Set system property > 'log4j2.debug' to show Log4j2 internal initialization logging. > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:21050/default;auth=noSasl > Connected to: Impala (version 4.0.0-SNAPSHOT) > Driver: Hive JDBC (version 3.1.3000.7.2.1.0-287) > Transaction isolation: TRANSACTION_REPEATABLE_READ > {code} > Looking into the impalad log file, there is a wrong option set: > {code:java} > I0901 15:41:14.577576 25325 TAcceptQueueServer.cpp:340] New connection to > server hiveserver2-frontend from client > I0901 15:41:14.577911 25597 impala-hs2-server.cc:300] Opening session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 request username: > I0901 15:41:14.577970 25597 status.cc:129] Invalid query option: > set:hiveconf:hive.server2.thrift.resultset.default.fetch.size > @ 0x1cdba3d impala::Status::Status() > @ 0x24c673f impala::SetQueryOption() > @ 0x250c1d1 impala::ImpalaServer::OpenSession() > @ 0x2b0dc45 > apache::hive::service::cli::thrift::TCLIServiceProcessor::process_OpenSession() > @ 0x2b0d993 > apache::hive::service::cli::thrift::TCLIServiceProcessor::dispatchCall() > @ 0x2acd15a > impala::ImpalaHiveServer2ServiceProcessor::dispatchCall() > @ 0x1c8a483 apache::thrift::TDispatchProcessor::process() > @ 0x218ab4a > apache::thrift::server::TAcceptQueueServer::Task::run() > @ 0x218004a impala::ThriftThread::RunRunnable() > @ 0x2181686 boost::_mfi::mf2<>::operator()() > @ 0x218151a boost::_bi::list3<>::operator()<>() > @ 0x2181260 boost::_bi::bind_t<>::operator()() > @ 0x2181172 > boost::detail::function::void_function_obj_invoker0<>::invoke() > @ 0x20fba57 boost::function0<>::operator()() > @ 0x26cb779 impala::Thread::SuperviseThread() > @ 0x26d3716 boost::_bi::list5<>::operator()<>() > @ 0x26d363a boost::_bi::bind_t<>::operator()() > @ 0x26d35fb boost::detail::thread_data<>::run() > @ 0x3eb7ae1 thread_proxy > @ 0x7fc9443456b9 start_thread > @ 0x7fc940e334dc clone > I0901 15:41:14.739985 25597 impala-hs2-server.cc:405] Opened session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 effective username: > I0901 15:41:14.781677 25597 impala-hs2-server.cc:426] GetInfo(): > request=TGetInfoReq { > 01: sessionHandle (struct) = TSessionHandle { > 01: sessionId (struct) = THandleIdentifier { > 01: guid (string) = "\xea(\x8e\xcc3?J \xa7j\xb2\x96\xab\x15\xa9\xd6", > 02: secret (string) = "\xf9\x11\xac\xf5wTB\xe8\xacN\r\x8e\xe3MJ\xa9", > }, > }, > 02
[jira] [Commented] (IMPALA-10120) Beeline hangs when connecting to coordinators
[ https://issues.apache.org/jira/browse/IMPALA-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17762009#comment-17762009 ] XiangYang commented on IMPALA-10120: Hi [~tangzhi] , there is a onging commit: [https://gerrit.cloudera.org/c/20344/] , sorry for too busy to reply the review recently, I'll try to complete it in the next few days. > Beeline hangs when connecting to coordinators > - > > Key: IMPALA-10120 > URL: https://issues.apache.org/jira/browse/IMPALA-10120 > Project: IMPALA > Issue Type: Bug > Components: Clients >Reporter: Quanlong Huang >Assignee: XiangYang >Priority: Critical > > Beeline is always hanging when connecting to a coordinator: > {code:java} > $ beeline -u "jdbc:hive2://localhost:21050/default;auth=noSasl" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > ERROR StatusLogger No log4j2 configuration file found. Using default > configuration: logging only errors to the console. Set system property > 'log4j2.debug' to show Log4j2 internal initialization logging. > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:21050/default;auth=noSasl > Connected to: Impala (version 4.0.0-SNAPSHOT) > Driver: Hive JDBC (version 3.1.3000.7.2.1.0-287) > Transaction isolation: TRANSACTION_REPEATABLE_READ > {code} > Looking into the impalad log file, there is a wrong option set: > {code:java} > I0901 15:41:14.577576 25325 TAcceptQueueServer.cpp:340] New connection to > server hiveserver2-frontend from client > I0901 15:41:14.577911 25597 impala-hs2-server.cc:300] Opening session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 request username: > I0901 15:41:14.577970 25597 status.cc:129] Invalid query option: > set:hiveconf:hive.server2.thrift.resultset.default.fetch.size > @ 0x1cdba3d impala::Status::Status() > @ 0x24c673f impala::SetQueryOption() > @ 0x250c1d1 impala::ImpalaServer::OpenSession() > @ 0x2b0dc45 > apache::hive::service::cli::thrift::TCLIServiceProcessor::process_OpenSession() > @ 0x2b0d993 > apache::hive::service::cli::thrift::TCLIServiceProcessor::dispatchCall() > @ 0x2acd15a > impala::ImpalaHiveServer2ServiceProcessor::dispatchCall() > @ 0x1c8a483 apache::thrift::TDispatchProcessor::process() > @ 0x218ab4a > apache::thrift::server::TAcceptQueueServer::Task::run() > @ 0x218004a impala::ThriftThread::RunRunnable() > @ 0x2181686 boost::_mfi::mf2<>::operator()() > @ 0x218151a boost::_bi::list3<>::operator()<>() > @ 0x2181260 boost::_bi::bind_t<>::operator()() > @ 0x2181172 > boost::detail::function::void_function_obj_invoker0<>::invoke() > @ 0x20fba57 boost::function0<>::operator()() > @ 0x26cb779 impala::Thread::SuperviseThread() > @ 0x26d3716 boost::_bi::list5<>::operator()<>() > @ 0x26d363a boost::_bi::bind_t<>::operator()() > @ 0x26d35fb boost::detail::thread_data<>::run() > @ 0x3eb7ae1 thread_proxy > @ 0x7fc9443456b9 start_thread > @ 0x7fc940e334dc clone > I0901 15:41:14.739985 25597 impala-hs2-server.cc:405] Opened session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 effective username: > I0901 15:41:14.781677 25597 impala-hs2-server.cc:426] GetInfo(): > request=TGetInfoReq { > 01: sessionHandle (struct) = TSessionHandle { > 01: sessionId (struct) = THandleIdentifier { > 01: guid (string) = "\xea(\x8e\xcc3?J \xa7j\xb2\x96\xab\x15\xa9\xd6",
[jira] [Commented] (IMPALA-10120) Beeline hangs when connecting to coordinators
[ https://issues.apache.org/jira/browse/IMPALA-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17763532#comment-17763532 ] Zhi Tang commented on IMPALA-10120: --- I got it. Thanks for participating in this work. > Beeline hangs when connecting to coordinators > - > > Key: IMPALA-10120 > URL: https://issues.apache.org/jira/browse/IMPALA-10120 > Project: IMPALA > Issue Type: Bug > Components: Clients >Reporter: Quanlong Huang >Assignee: XiangYang >Priority: Critical > > Beeline is always hanging when connecting to a coordinator: > {code:java} > $ beeline -u "jdbc:hive2://localhost:21050/default;auth=noSasl" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > ERROR StatusLogger No log4j2 configuration file found. Using default > configuration: logging only errors to the console. Set system property > 'log4j2.debug' to show Log4j2 internal initialization logging. > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:21050/default;auth=noSasl > Connected to: Impala (version 4.0.0-SNAPSHOT) > Driver: Hive JDBC (version 3.1.3000.7.2.1.0-287) > Transaction isolation: TRANSACTION_REPEATABLE_READ > {code} > Looking into the impalad log file, there is a wrong option set: > {code:java} > I0901 15:41:14.577576 25325 TAcceptQueueServer.cpp:340] New connection to > server hiveserver2-frontend from client > I0901 15:41:14.577911 25597 impala-hs2-server.cc:300] Opening session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 request username: > I0901 15:41:14.577970 25597 status.cc:129] Invalid query option: > set:hiveconf:hive.server2.thrift.resultset.default.fetch.size > @ 0x1cdba3d impala::Status::Status() > @ 0x24c673f impala::SetQueryOption() > @ 0x250c1d1 impala::ImpalaServer::OpenSession() > @ 0x2b0dc45 > apache::hive::service::cli::thrift::TCLIServiceProcessor::process_OpenSession() > @ 0x2b0d993 > apache::hive::service::cli::thrift::TCLIServiceProcessor::dispatchCall() > @ 0x2acd15a > impala::ImpalaHiveServer2ServiceProcessor::dispatchCall() > @ 0x1c8a483 apache::thrift::TDispatchProcessor::process() > @ 0x218ab4a > apache::thrift::server::TAcceptQueueServer::Task::run() > @ 0x218004a impala::ThriftThread::RunRunnable() > @ 0x2181686 boost::_mfi::mf2<>::operator()() > @ 0x218151a boost::_bi::list3<>::operator()<>() > @ 0x2181260 boost::_bi::bind_t<>::operator()() > @ 0x2181172 > boost::detail::function::void_function_obj_invoker0<>::invoke() > @ 0x20fba57 boost::function0<>::operator()() > @ 0x26cb779 impala::Thread::SuperviseThread() > @ 0x26d3716 boost::_bi::list5<>::operator()<>() > @ 0x26d363a boost::_bi::bind_t<>::operator()() > @ 0x26d35fb boost::detail::thread_data<>::run() > @ 0x3eb7ae1 thread_proxy > @ 0x7fc9443456b9 start_thread > @ 0x7fc940e334dc clone > I0901 15:41:14.739985 25597 impala-hs2-server.cc:405] Opened session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 effective username: > I0901 15:41:14.781677 25597 impala-hs2-server.cc:426] GetInfo(): > request=TGetInfoReq { > 01: sessionHandle (struct) = TSessionHandle { > 01: sessionId (struct) = THandleIdentifier { > 01: guid (string) = "\xea(\x8e\xcc3?J \xa7j\xb2\x96\xab\x15\xa9\xd6", > 02: secret (string) = "\xf9\x11\xac\xf5wTB\xe8\xacN\r\x8e\xe3MJ\xa9", > }, > }, > 02: infoType (i32) = 17, > } >
[jira] [Commented] (IMPALA-10120) Beeline hangs when connecting to coordinators
[ https://issues.apache.org/jira/browse/IMPALA-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17773155#comment-17773155 ] ASF subversion and git services commented on IMPALA-10120: -- Commit 8f79c958354ac78ba4826d216ae1bad3338d076d in impala's branch refs/heads/master from Xiang Yang [ https://gitbox.apache.org/repos/asf?p=impala.git;h=8f79c9583 ] IMPALA-10120: Add required fields for TGetInfoResp when error. TGetInfoResp requires two fields: 'status' and 'infoValue', but impala server only return the 'status' field when error at ImpalaServer:: GetInfo(), this can cause Beeline hang. This patch fix this by set the required 'infoValue' field when error. Testing: - add an EE test: test_beeline.py. Change-Id: Ib42bb82735fb4a8e6911b6a19adb8bd84973300b Reviewed-on: http://gerrit.cloudera.org:8080/20344 Reviewed-by: Impala Public Jenkins Tested-by: Impala Public Jenkins > Beeline hangs when connecting to coordinators > - > > Key: IMPALA-10120 > URL: https://issues.apache.org/jira/browse/IMPALA-10120 > Project: IMPALA > Issue Type: Bug > Components: Clients >Reporter: Quanlong Huang >Assignee: XiangYang >Priority: Critical > > Beeline is always hanging when connecting to a coordinator: > {code:java} > $ beeline -u "jdbc:hive2://localhost:21050/default;auth=noSasl" > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > ERROR StatusLogger No log4j2 configuration file found. Using default > configuration: logging only errors to the console. Set system property > 'log4j2.debug' to show Log4j2 internal initialization logging. > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/quanlong/workspace/Impala/toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] > Connecting to jdbc:hive2://localhost:21050/default;auth=noSasl > Connected to: Impala (version 4.0.0-SNAPSHOT) > Driver: Hive JDBC (version 3.1.3000.7.2.1.0-287) > Transaction isolation: TRANSACTION_REPEATABLE_READ > {code} > Looking into the impalad log file, there is a wrong option set: > {code:java} > I0901 15:41:14.577576 25325 TAcceptQueueServer.cpp:340] New connection to > server hiveserver2-frontend from client > I0901 15:41:14.577911 25597 impala-hs2-server.cc:300] Opening session: > 204a3f33cc8e28ea:d6a915ab96b26aa7 request username: > I0901 15:41:14.577970 25597 status.cc:129] Invalid query option: > set:hiveconf:hive.server2.thrift.resultset.default.fetch.size > @ 0x1cdba3d impala::Status::Status() > @ 0x24c673f impala::SetQueryOption() > @ 0x250c1d1 impala::ImpalaServer::OpenSession() > @ 0x2b0dc45 > apache::hive::service::cli::thrift::TCLIServiceProcessor::process_OpenSession() > @ 0x2b0d993 > apache::hive::service::cli::thrift::TCLIServiceProcessor::dispatchCall() > @ 0x2acd15a > impala::ImpalaHiveServer2ServiceProcessor::dispatchCall() > @ 0x1c8a483 apache::thrift::TDispatchProcessor::process() > @ 0x218ab4a > apache::thrift::server::TAcceptQueueServer::Task::run() > @ 0x218004a impala::ThriftThread::RunRunnable() > @ 0x2181686 boost::_mfi::mf2<>::operator()() > @ 0x218151a boost::_bi::list3<>::operator()<>() > @ 0x2181260 boost::_bi::bind_t<>::operator()() > @ 0x2181172 > boost::detail::function::void_function_obj_invoker0<>::invoke() > @ 0x20fba57 boost::function0<>::operator()() > @ 0x26cb779 impala::Thread::SuperviseThread() > @ 0x26d3716 boost::_bi::list5<>::operator()<>() > @ 0x26d363a boost::_bi::bind_t<>::operator()() > @