2016-11-30 11:08:06,803 WARN  [pool-5-thread-948]: txn.TxnHandler (TxnHandler.java:openTxns(451)) - Maximum allowed number of open transactions (100000) has been reached. Current number of open transactions: 100000
2016-11-30 11:08:06,804 ERROR [pool-5-thread-948]: metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(195)) - MetaException(message:Maximum allowed number of open transactions has been reached. See hive.max.open.txns.)
	at org.apache.hadoop.hive.metastore.txn.TxnHandler.openTxns(TxnHandler.java:453)
	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.open_txns(HiveMetaStore.java:5729)
	at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:139)
	at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:97)
	at com.sun.proxy.$Proxy12.open_txns(Unknown Source)
	at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$open_txns.getResult(ThriftHiveMetastore.java:11765)
	at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$open_txns.getResult(ThriftHiveMetastore.java:11750)
	at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
	at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110)
	at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:422)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724)
	at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118)
	at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)

2016-11-30 11:08:06,804 ERROR [pool-5-thread-948]: thrift.ProcessFunction (ProcessFunction.java:process(41)) - Internal error processing open_txns
MetaException(message:Maximum allowed number of open transactions has been reached. See hive.max.open.txns.)
	at org.apache.hadoop.hive.metastore.txn.TxnHandler.openTxns(TxnHandler.java:453)
	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.open_txns(HiveMetaStore.java:5729)
	at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:139)
	at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:97)
	at com.sun.proxy.$Proxy12.open_txns(Unknown Source)
	at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$open_txns.getResult(ThriftHiveMetastore.java:11765)
	at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$open_txns.getResult(ThriftHiveMetastore.java:11750)
	at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
	at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110)
	at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:422)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724)
	at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118)
	at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
2016-11-30 11:08:06,878 INFO  [pool-5-thread-948]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 948: source:10.120.229.163 get_databases: NonExistentDatabaseUsedForHealthCheck
2016-11-30 11:08:06,878 INFO  [pool-5-thread-948]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=nifi	ip=10.120.229.163	cmd=source:10.120.229.163 get_databases: NonExistentDatabaseUsedForHealthCheck	
2016-11-30 11:08:06,881 INFO  [pool-5-thread-948]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 948: source:10.120.229.163 get_databases: NonExistentDatabaseUsedForHealthCheck
2016-11-30 11:08:06,881 INFO  [pool-5-thread-948]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=nifi	ip=10.120.229.163	cmd=source:10.120.229.163 get_databases: NonExistentDatabaseUsedForHealthCheck	
2016-11-30 11:08:06,884 INFO  [pool-5-thread-948]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 948: source:10.120.229.163 get_table : db=starhome tbl=olympics
2016-11-30 11:08:06,884 INFO  [pool-5-thread-948]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=nifi	ip=10.120.229.163	cmd=source:10.120.229.163 get_table : db=starhome tbl=olympics	
2016-11-30 11:08:06,950 INFO  [pool-5-thread-1280]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 1280: source:10.120.229.163 get_databases: NonExistentDatabaseUsedForHealthCheck
2016-11-30 11:08:06,951 INFO  [pool-5-thread-1280]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=nifi	ip=10.120.229.163	cmd=source:10.120.229.163 get_databases: NonExistentDatabaseUsedForHealthCheck	
2016-11-30 11:08:07,000 INFO  [pool-5-thread-1280]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 1280: source:10.120.229.163 get_table : db=starhome tbl=olympics
2016-11-30 11:08:07,000 INFO  [pool-5-thread-1280]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=nifi	ip=10.120.229.163	cmd=source:10.120.229.163 get_table : db=starhome tbl=olympics	
2016-11-30 11:08:07,119 INFO  [pool-5-thread-1280]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 1280: source:10.120.229.163 get_table : db=starhome tbl=olympics
2016-11-30 11:08:07,119 INFO  [pool-5-thread-1280]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=nifi	ip=10.120.229.163	cmd=source:10.120.229.163 get_table : db=starhome tbl=olympics	
2016-11-30 11:08:07,133 WARN  [pool-5-thread-948]: txn.TxnHandler (TxnHandler.java:openTxns(451)) - Maximum allowed number of open transactions (100000) has been reached. Current number of open transactions: 100000
2016-11-30 11:08:07,133 ERROR [pool-5-thread-948]: metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(195)) - MetaException(message:Maximum allowed number of open transactions has been reached. See hive.max.open.txns.)
	at org.apache.hadoop.hive.metastore.txn.TxnHandler.openTxns(TxnHandler.java:453)
	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.open_txns(HiveMetaStore.java:5729)
	at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:139)
	at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:97)
	at com.sun.proxy.$Proxy12.open_txns(Unknown Source)
	at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$open_txns.getResult(ThriftHiveMetastore.java:11765)
	at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$open_txns.getResult(ThriftHiveMetastore.java:11750)
	at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
	at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110)
	at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:422)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724)
	at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118)
	at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)

2016-11-30 11:08:07,133 ERROR [pool-5-thread-948]: thrift.ProcessFunction (ProcessFunction.java:process(41)) - Internal error processing open_txns
MetaException(message:Maximum allowed number of open transactions has been reached. See hive.max.open.txns.)
	at org.apache.hadoop.hive.metastore.txn.TxnHandler.openTxns(TxnHandler.java:453)
	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.open_txns(HiveMetaStore.java:5729)
	at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:139)
	at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:97)
	at com.sun.proxy.$Proxy12.open_txns(Unknown Source)
	at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$open_txns.getResult(ThriftHiveMetastore.java:11765)
	at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$open_txns.getResult(ThriftHiveMetastore.java:11750)
	at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
	at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110)
	at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:422)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724)
	at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118)
	at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)