[ https://issues.apache.org/jira/browse/HIVE-13249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15194098#comment-15194098 ]
Alan Gates commented on HIVE-13249: ----------------------------------- There's already a threadpool in AcidHouseKeeperService. This should use that rather than having its own separate threadpool. Once the number of open transactions exceeds the threshold you should require it to drain a ways below that (maybe 90% of the threshold) before allowing new transactions. This avoid it constantly lurching in and out of trouble. > Hard upper bound on number of open transactions > ----------------------------------------------- > > Key: HIVE-13249 > URL: https://issues.apache.org/jira/browse/HIVE-13249 > Project: Hive > Issue Type: Improvement > Components: Transactions > Affects Versions: 2.0.0 > Reporter: Wei Zheng > Assignee: Wei Zheng > Attachments: HIVE-13249.1.patch > > > We need to have a safeguard by adding an upper bound for open transactions to > avoid huge number of open-transaction requests, usually due to improper > configuration of clients such as Storm. > Once that limit is reached, clients will start failing. -- This message was sent by Atlassian JIRA (v6.3.4#6332)