[HIVE-19437] HiveServer2 Drops connection to Metastore when hiverserver2 webui is enabled

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 2.1.1, 2.3.2
• Component/s: HiveServer2, SQL, Web UI
• Assignee: Unassigned
• Reporter: rr
• Created: 07/May/18 07:34
• Updated: 22/Feb/19 22:32

Description

 

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

Issue Links

• is related to: HIVE-19811 the hive server2 web ui is suddenly down,can't open master:100002