You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Dmytro Grinenko (JIRA)" <ji...@apache.org> on 2015/11/19 16:55:11 UTC
[jira] [Updated] (AMBARI-13972) RU: Restarting Hive Metastore
failed during upgrade
[ https://issues.apache.org/jira/browse/AMBARI-13972?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dmytro Grinenko updated AMBARI-13972:
-------------------------------------
Description:
{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
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}
was:
{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}
> 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
> 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)