[ https://issues.apache.org/jira/browse/HIVE-26295?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
hansonhe updated HIVE-26295: ---------------------------- Affects Version/s: 3.1.2 > Hive LB based on zookeeper occured some probability of connect failured > ----------------------------------------------------------------------- > > 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)