[
https://issues.apache.org/jira/browse/HIVE-25153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17396358#comment-17396358
]
Pranay commented on HIVE-25153:
-------------------------------
duplicate issue. patch available.
> JDBC connection randomly fails if both leader 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
> Priority: Major
>
> 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)
