[Hive]关于Hive的启动问题，hive启动问题

[Hive]关于Hive的启动问题，hive启动问题

业务背景

用户轨迹工程脚本最近经常报错，报错如下：

SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
FAILED: Error in metadata: MetaException(message:java.lang.RuntimeException: commitTransaction was called but openTransactionCalls = 0. This probably indicates that there are unbalanced calls to openTransaction/commitTransaction)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

搜了下发现，这是hive 0.10.0, 0.11.0, 0.12.0版本的bug，描述如下：
https://issues.apache.org/jira/browse/HIVE-4996

分析

查看了下集群上hive的配置文件，发现有这些：

$locate hive-site.xml
/etc/hive/conf.cloudera.hive/hive-site.xml
/etc/hive/conf.dist/hive-site.xml
/etc/hive/conf.dist/hive-site.xml_back
/etc/hive-hcatalog/conf.dist/proto-hive-site.xml
/home/pms/db_engine/apache-hive-0.13.1-bin/conf/hive-site.xml
/home/pms/db_engine/apache-hive-0.13.1-bin/hcatalog/etc/hcatalog/proto-hive-site.xml
/home/pms/workspace/kangshantong/spark/source/spark/sql/hive/src/test/resources/data/conf/hive-site.xml
/home/pms/workspace/kangshantong/spark/source/spark/sql/hive/target/scala-2.10/test-classes/data/conf/hive-site.xml
/home/pms/workspace/tangning/software/spark-1.3.1/conf/hive-site.xml
/home/pms/workspace/tangning/software/spark-1.3.1/sql/hive/src/test/resources/data/conf/hive-site.xml
/home/pms/workspace/tangning/software/spark-1.3.1/sql/hive/target/scala-2.10/test-classes/data/conf/hive-site.xml
/home/zhoushugang/apache-hive-0.13.1-bin/conf/hive-site.xml
/home/zhoushugang/apache-hive-0.13.1-bin/hcatalog/etc/hcatalog/proto-hive-site.xml
/usr/local/biserver-ce/pentaho-solutions/system/kettle/plugins/pentaho-big-data-plugin/hadoop-configurations/cdh51/hive-site.xml
/usr/local/biserver-ce/pentaho-solutions/system/kettle/plugins/pentaho-big-data-plugin/hadoop-configurations/hadoop-20/hive-site.xml
/usr/local/cloud/hive/conf/hive-site.xml
/usr/local/cloud/hive/scripts/pdk/conf/hive-site.xml
/usr/local/cloud/hive/src/cloudera/patches/0054-CDH-10280-Change-default-value-for-hive-site.xml-in-.patch
/usr/local/cloud/hive/src/common/src/test/resources/hive-site.xml
/usr/local/cloud/hive/src/conf/hive-site