[ 
https://issues.apache.org/jira/browse/HIVE-24711?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17276783#comment-17276783
 ] 

LinZhongwei commented on HIVE-24711:
------------------------------------

Here is a authorization related configuration in the hive-site.xml

<name>hive.security.metastore.authorization.manager</name>
 
<value>org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider</value>

 

Here is hivemetastore-site.xml   
 <configuration xmlns:xi="http://www.w3.org/2001/XInclude";>
 <property>
 <name>hive.compactor.initiator.on</name>
 <value>true</value>
 </property>
 <property>
 <name>hive.compactor.worker.threads</name>
 <value>10</value>
 </property>
 <property>
 <name>hive.metastore.dml.events</name>
 <value>true</value>
 </property>
 <property>
 <name>hive.metastore.event.listeners</name>
 <value></value>
 </property>
 <property>
 <name>hive.metastore.metrics.enabled</name>
 <value>true</value>
 </property>
 <property>
 <name>hive.metastore.transactional.event.listeners</name>
 <value>org.apache.hive.hcatalog.listener.DbNotificationListener</value>
 </property>
 <property>
 <name>hive.server2.metrics.enabled</name>
 <value>true</value>
 </property>
 <property>
 <name>hive.service.metrics.hadoop2.component</name>
 <value>hivemetastore</value>
 </property>
 <property>
 <name>hive.service.metrics.reporter</name>
 <value>HADOOP2</value>
 </property>
 </configuration>

 

 

> hive metastore memory leak
> --------------------------
>
>                 Key: HIVE-24711
>                 URL: https://issues.apache.org/jira/browse/HIVE-24711
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive, Metastore
>    Affects Versions: 3.1.0
>            Reporter: LinZhongwei
>            Priority: Major
>
> hdp version:3.1.5.31-1
> hive version:3.1.0.3.1.5.31-1
> hadoop version:3.1.1.3.1.5.31-1
> We find that the hive metastore has memory leak if we set 
> compactor.initiator.on to true.
> If we disable the configuration, the memory leak disappear.
> How can we resolve this problem?
> Even if we set the heap size of hive metastore to 40 GB, after 1 month the 
> hive metastore service will be down with outofmemory.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to