Dmytro Grinenko created AMBARI-13972: ----------------------------------------
Summary: RU: Restarting Hive Metastore failed during upgrade Key: AMBARI-13972 URL: https://issues.apache.org/jira/browse/AMBARI-13972 Project: Ambari Issue Type: Bug Components: ambari-server Affects Versions: trunk, 2.1.3 Reporter: Dmytro Grinenko Priority: Critical Fix For: trunk, 2.1.3 {code} Traceback (most recent call last): File \"/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py\", line 234, in <module> HiveMetastore().execute() File \"/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py\", line 218, in execute method(env) File \"/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py\", line 497, in restart self.pre_upgrade_restart(env, upgrade_type=upgrade_type) File \"/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py\", line 106, in pre_upgrade_restart self.configure(env) File \"/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py\", line 71, in configure hive(name = 'metastore') File \"/usr/lib/python2.6/site-packages/ambari_commons/os_family_impl.py\", line 89, in thunk return fn(*args, **kwargs) File \"/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive.py\", line 292, in hive user = params.hive_user File \"/usr/lib/python2.6/site-packages/resource_management/core/base.py\", line 154, in __init__ self.env.run() File \"/usr/lib/python2.6/site-packages/resource_management/core/environment.py\", line 156, in run self.run_action(resource, action) File \"/usr/lib/python2.6/site-packages/resource_management/core/environment.py\", line 119, in run_action provider_action() File \"/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py\", line 238, in action_run tries=self.resource.tries, try_sleep=self.resource.try_sleep) File \"/usr/lib/python2.6/site-packages/resource_management/core/shell.py\", line 70, in inner result = function(command, **kwargs) File \"/usr/lib/python2.6/site-packages/resource_management/core/shell.py\", line 92, in checked_call tries=tries, try_sleep=try_sleep) File \"/usr/lib/python2.6/site-packages/resource_management/core/shell.py\", line 140, in _call_wrapper result = _call(command, **kwargs_copy) File \"/usr/lib/python2.6/site-packages/resource_management/core/shell.py\", line 291, in _call raise Fail(err_msg) resource_management.core.exceptions.Fail: Execution of 'export HIVE_CONF_DIR=/usr/hdp/current/hive-metastore/conf/conf.server ; /usr/hdp/current/hive-metastore/bin/schematool -initSchema -dbType mysql -userName hiveuser -passWord [PROTECTED]' returned 1. 15/11/11 17:52:41 WARN conf.HiveConf: HiveConf of name hive.default.fileformat.managed does not exist Metastore connection URL:\t jdbc:mysql://172.22.122.0/hivedb?createDatabaseIfNotExist=true Metastore Connection Driver :\t com.mysql.jdbc.Driver Metastore connection User:\t hiveuser Starting metastore schema initialization to 0.14.0 Initialization script hive-schema-0.14.0.mysql.sql Error: Duplicate key name 'PCS_STATS_IDX' (state=42000,code=1061) org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !! *** schemaTool failed ***", "stdout" : "2015-11-11 17:52:17,973 - hive-metastore is currently at version 2.2.8.0-3150 {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)