[
https://issues.apache.org/jira/browse/HIVE-26295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17554893#comment-17554893
]
Zhihua Deng commented on HIVE-26295:
------------------------------------
Cloud you please add _--verbose_ at the end of beeline command to see if there
are some details about the exception?
> Hive LB based on zookeeper occured some probability of connect failed
> ---------------------------------------------------------------------
>
> Key: HIVE-26295
> URL: https://issues.apache.org/jira/browse/HIVE-26295
> Project: Hive
> Issue Type: Bug
> Affects Versions: 3.1.2
> Reporter: hansonhe
> Priority: Major
>
> (1) I set LB properties in hive-site.xml
> hive.server2.support.dynamic.service.discovery=true
> hive.server2.active.passive.ha.enable=false
> (2) My hive production cluster info
> hive version: Apache 3.1.2
> hadoop version: Apache 3.1.4
> zookeeper version: Apache 3.5.9
> URL：
> jdbc:hive2://host1:2181,host2:2181,host3:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
> my hive cluster have 3 hiveserver2 : host1:10000,host2:10000,host3:10000
> （3）After lots of test connect to use beeline -u '${URL}' -n 'hive' -p 'xxxx'
> , some probability of connect failured or connect success.When connect
> success，it can connect anyone of 3 hiveserver2 randomly and successfully.
> When connect failed，failed logs as following :
> 22/06/07 11:14:59 INFO X509Util: Setting -D
> jdk.tls.rejectClientInitiatedRenegotiation=true to disable client-initiated
> TLS renegotiation
> 22/06/07 11:14:59 INFO ClientCnxnSocket: jute.maxbuffer value is 4194304 Bytes
> 22/06/07 11:14:59 INFO ClientCnxn: zookeeper.request.timeout value is 0.
> feature enabled=
> 22/06/07 11:14:59 INFO ClientCnxn: Opening socket connection to server
> host3/10.2.52.73:2181. Will not attempt to authenticate using SASL (unknown
> error)
> 22/06/07 11:14:59 INFO ClientCnxn: Socket connection established, initiating
> session, client: /10.2.52.110:61210, server:
> sh1-bigdata-master03/10.2.52.73:2181
> 22/06/07 11:14:59 INFO ClientCnxn: Session establishment complete on server
> host3/10.2.52.73:2181, sessionid = 0x301b42644c8001c, negotiated timeout =
> 60000
> 22/06/07 11:14:59 INFO ConnectionStateManager: State change: CONNECTED
> 22/06/07 11:14:59 INFO CuratorFrameworkImpl: backgroundOperationsLoop exiting
> 22/06/07 11:14:59 INFO ZooKeeper: Session: 0x301b42644c8001c closed
> 22/06/07 11:14:59 INFO ClientCnxn: EventThread shut down for session:
> 0x301b42644c8001c
> Error: org.apache.hive.jdbc.ZooKeeperHiveClientException: Unable to read
> HiveServer2 configs from ZooKeeper (state=,code=0)
> Beeline version 3.1.2 by Apache Hive
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
