Pranay created HIVE-25153:
-----------------------------
Summary: JDBC connection randomly fails if both ha and zookeeper
discovery namespaces are within znode /hiveserver2
Key: HIVE-25153
URL: https://issues.apache.org/jira/browse/HIVE-25153
Project: Hive
Issue Type: Bug
Components: HiveServer2
Affects Versions: 3.1.2
Environment: Hive 3.1.2
Reporter: Pranay
Hello,
jdbc connection randomly fails to connect to hiveserver2. Here are observation
-
Zookeeper znodes
{code:java}
[zk: redacted106.visa.com:2181(CONNECTED) 5] ls /hiveserver2
[leader,
serverUri=redacted206.visa.com:10000;version=3.1.2-1-SNAPSHOT;sequence=0000000007]{code}
ZooKeeperHiveClientHelper.java randomly reads server list from the znode from
/hiveserver2 and when it reads leader as random host, it fails to connect.
Failed jdbc connection
------------------------
{code:java}
21/05/21 20:14:17 [main-SendThread(redacted106.visa.com:2181)]: DEBUG
zookeeper.ClientCnxn: Reading reply sessionid:0x102e58cc0bd0019, packet::
clientPath:null serverPath:null finished:false header:: 1,12 replyHeader::
1,42949673107,0 request:: '/hiveserver2,F response::
v{'leader,'serverUri=redacted206.visa.com:10000;version=3.1.2-1-SNAPSHOT;sequence=0000000005},s{21474836584,21474836584,1621616800534,1621616800534,0,10,0,0,13,2,42949673008}
21/05/21 20:14:17 [main-SendThread(redacted106.visa.com:2181)]: DEBUG
zookeeper.ClientCnxn: Reading reply sessionid:0x102e58cc0bd0019, packet::
clientPath:null serverPath:null finished:false header:: 2,4 replyHeader::
2,42949673107,0 request:: '/hiveserver2/leader,F response::
,s{21474836589,21474836589,1621616800587,1621616800587,0,5,0,0,0,1,42949673013}
2
21/05/21 20:14:17 [main-SendThread(redacted106.visa.com:2181)]: DEBUG
zookeeper.ClientCnxn: An exception was thrown while closing send thread for
session 0x102e58cc0bd0019 : Unable to read additional data from server
sessionid 0x102e58cc0bd0019, likely server has closed socket
Error: org.apache.hive.jdbc.ZooKeeperHiveClientException: Unable to read
HiveServer2 configs from ZooKeeper (state=,code=0){code}
Successful jdbc connection
----------------------------
{code:java}
21/05/21 20:14:01 [main-SendThread(redacted106.visa.com:2181)]: DEBUG
zookeeper.ClientCnxn: Reading reply sessionid:0x102e58cc0bd0018, packet::
clientPath:null serverPath:null finished:false header:: 1,12 replyHeader::
1,42949673103,0 request:: '/hiveserver2,F response::
v{'leader,'serverUri=redacted206.visa.com:10000;version=3.1.2-1-SNAPSHOT;sequence=0000000005},s{21474836584,21474836584,1621616800534,1621616800534,0,10,0,0,13,2,42949673008}
21/05/21 20:14:01 [main-SendThread(redacted106.visa.com:2181)]: DEBUG
zookeeper.ClientCnxn: Reading reply sessionid:0x102e58cc0bd0018, packet::
clientPath:null serverPath:null finished:false header:: 2,4 replyHeader::
2,42949673103,0 request::
'/hiveserver2/serverUri=redacted206.visa.com:10000;version=3.1.2-1-SNAPSHOT;sequence=0000000005,F
response::
#686976652e736572766572322e696e7374616e63652e7572693d736c373364706968636e30303230362e766973612e636f6d3a31303030303b686976652e736572766572322e61757468656e7469636174696f6e3d4b45524245524f533b686976652e736572766572322e7472616e73706f72742e6d6f64653d62696e6172793b686976652e736572766572322e7468726966742e7361736c2e716f703d617574683b686976652e736572766572322e7468726966742e62696e642e686f73743d736c373364706968636e30303230362e766973612e636f6d3b686976652e736572766572322e7468726966742e706f72743d31303030303b686976652e736572766572322e7573652e53534c3d66616c73653b686976652e736572766572322e61757468656e7469636174696f6e2e6b65726265726f732e7072696e636970616c3d686976652f5f484f535440434f52504445562e564953412e434f4d,s{42949673008,42949673008,1621626552349,1621626552349,0,0,0,72872936683143172,350,0,42949673008}
21/05/21 20:14:01 [main]: DEBUG jdbc.Utils: Resolved authority:
redacted206.visa.com:10000{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
