[HIVE-6852] JDBC client connections hang at TSaslTransport

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: JDBC
• Assignee: Unassigned
• Reporter: jay vyas
• Created: 06/Apr/14 13:01
• Updated: 28/Jun/20 11:40

Description

I've noticed that when there is an underlying issue in connecting a client to the JDBC interface of the HiveServer2 to run queries, you get a hang after the thrift portion, at least in certain scenarios:

Turning log4j to DEBUG, you can see the following when trying to get a connection using:

        Connection jdbc = DriverManager.getConnection(this.con,"hive","password");
        "jdbc:hive2://localhost:10000/default",

The logs get to here before the hang :

0    [main] DEBUG org.apache.thrift.transport.TSaslTransport  - opening transport org.apache.thrift.transport.TSaslClientTransport@219ba640
0 [main] DEBUG org.apache.thrift.transport.TSaslTransport  - opening transport org.apache.thrift.transport.TSaslClientTransport@219ba640
3    [main] DEBUG org.apache.thrift.transport.TSaslClientTransport  - Sending mechanism name PLAIN and initial response of length 14
3 [main] DEBUG org.apache.thrift.transport.TSaslClientTransport  - Sending mechanism name PLAIN and initial response of length 14
5    [main] DEBUG org.apache.thrift.transport.TSaslTransport  - CLIENT: Writing message with status START and payload length 5
5 [main] DEBUG org.apache.thrift.transport.TSaslTransport  - CLIENT: Writing message with status START and payload length 5
5    [main] DEBUG org.apache.thrift.transport.TSaslTransport  - CLIENT: Writing message with status COMPLETE and payload length 14
5 [main] DEBUG org.apache.thrift.transport.TSaslTransport  - CLIENT: Writing message with status COMPLETE and payload length 14
5    [main] DEBUG org.apache.thrift.transport.TSaslTransport  - CLIENT: Start message handled
5 [main] DEBUG org.apache.thrift.transport.TSaslTransport  - CLIENT: Start message handled
5    [main] DEBUG org.apache.thrift.transport.TSaslTransport  - CLIENT: Main negotiation loop complete
5 [main] DEBUG org.apache.thrift.transport.TSaslTransport  - CLIENT: Main negotiation loop complete
6    [main] DEBUG org.apache.thrift.transport.TSaslTransport  - CLIENT: SASL Client receiving last message
6 [main] DEBUG org.apache.thrift.transport.TSaslTransport  - CLIENT: SASL Client receiving last message