[ https://issues.apache.org/jira/browse/HIVE-19437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16507535#comment-16507535 ]
t oo commented on HIVE-19437: ----------------------------- Getting same issue on Hive 2.3.2 > HiveServer2 Drops connection to Metastore when hiverserver2 webui is enabled > ---------------------------------------------------------------------------- > > Key: HIVE-19437 > URL: https://issues.apache.org/jira/browse/HIVE-19437 > Project: Hive > Issue Type: Bug > Components: HiveServer2, SQL, Web UI > Affects Versions: 2.1.1, 2.3.2 > Reporter: rr > Priority: Major > > > when ssl is enabled for hiveserver2 webui on port 10002, hiveserver2 is > unable to start up. Keeps connecting to metastore and then drops the > connection and then retry again. Hiveserver2 pid will be available but its > not actually UP as it drops the metastore connection. > Logs shows as follows : > 2018-05-07T04:45:52,980 INFO [main] sqlstd.SQLStdHiveAccessController: > Created SQLStdHiveAccessController for session context : > HiveAuthzSessionContext [sessionString=9f65e1ba-8810-47ee-a370-238606f02479, > clientType=HIVESERVER2] > 2018-05-07T04:45:52,980 WARN [main] session.SessionState: > METASTORE_FILTER_HOOK will be ignored, since > hive.security.authorization.manager is set to instance of > HiveAuthorizerFactory. > 2018-05-07T04:45:52,981 INFO [main] hive.metastore: Mestastore configuration > hive.metastore.filter.hook changed from > org.apache.hadoop.hive.metastore.DefaultMetaStoreFilterHookImpl to > org.apache.hadoop.hive.ql.security.authorization.plugin.AuthorizationMetaStoreFilterHook > 2018-05-07T04:45:52,981 INFO [main] hive.metastore: Closed a connection to > metastore, current connections: 0 > 2018-05-07T04:45:52,982 INFO [main] hive.metastore: Trying to connect to > metastore with URI thrift://localhost:9083 > 2018-05-07T04:45:52,982 INFO [main] hive.metastore: Opened a connection to > metastore, current connections: 1 > 2018-05-07T04:45:52,985 INFO [main] hive.metastore: Connected to metastore. > 2018-05-07T04:45:52,986 INFO [main] service.CompositeService: Operation log > root directory is created: /var/hive/hs2log/tmp > 2018-05-07T04:45:52,986 INFO [main] service.CompositeService: HiveServer2: > Background operation thread pool size: 100 > 2018-05-07T04:45:52,986 INFO [main] service.CompositeService: HiveServer2: > Background operation thread wait queue size: 100 > 2018-05-07T04:45:52,986 INFO [main] service.CompositeService: HiveServer2: > Background operation thread keepalive time: 10 seconds > 2018-05-07T04:45:52,988 INFO [main] hive.metastore: Closed a connection to > metastore, current connections: 0 -- This message was sent by Atlassian JIRA (v7.6.3#76005)