ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dmytro Sen" <d...@hortonworks.com>
Subject Review Request 26317: Hive Metastore doesn't start
Date Fri, 03 Oct 2014 14:47:00 GMT

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/26317/
-----------------------------------------------------------

Review request for Ambari and Andrew Onischuk.


Bugs: AMBARI-7631
    https://issues.apache.org/jira/browse/AMBARI-7631


Repository: ambari


Description
-------

Hive Metastore didn't start on 2.1 Stack.
/var/lib/ambari-agent/data/errors-62.txt
2014-10-03 11:52:20,935 - Error while executing command 'start':
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py",
line 122, in execute
    method(env)
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive_metastore.py",
line 43, in start
    self.configure(env) # FOR SECURITY
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive_metastore.py",
line 38, in configure
    hive(name='metastore')
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive.py",
line 83, in hive
    not_if = check_schema_created_cmd
  File "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line 148, in __init__
    self.env.run()
  File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 149,
in run
    self.run_action(resource, action)
  File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 115,
in run_action
    provider_action()
  File "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", line
237, in action_run
    raise ex
Fail: Execution of 'export HIVE_CONF_DIR=/etc/hive/conf.server ; /usr/lib/hive/bin/schematool
-initSchema -dbType mysql -userName hive -passWord [PROTECTED]' returned 1. Metastore connection
URL:	 jdbc:derby:;databaseName=metastore_db;create=true
Metastore Connection Driver :	 org.apache.derby.jdbc.EmbeddedDriver
Metastore connection User:	 hive
Starting metastore schema initialization to 0.13.0
Initialization script hive-schema-0.13.0.mysql.sql
Error: Syntax error: Encountered "<EOF>" at line 1, column 64. (state=42X01,code=30000)
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore
state would be inconsistent !!
*** schemaTool failed ***
/var/lib/ambari-agent/data/output-62.txt
2014-10-03 11:52:09,810 - Execute['mkdir -p /var/lib/ambari-agent/data/tmp/AMBARI-artifacts/;
    curl -kf -x "" --retry 10     http://c6401.ambari.apache.org:8080/resources//UnlimitedJCEPolicyJDK7.zip
-o /var/lib/ambari-agent/data/tmp/AMBARI-artifacts//UnlimitedJCEPolicyJDK7.zip'] {'environment':
..., 'not_if': 'test -e /var/lib/ambari-agent/data/tmp/AMBARI-artifacts//UnlimitedJCEPolicyJDK7.zip',
'ignore_failures': True, 'path': ['/bin', '/usr/bin/']}
2014-10-03 11:52:09,833 - Skipping Execute['mkdir -p /var/lib/ambari-agent/data/tmp/AMBARI-artifacts/;
    curl -kf -x "" --retry 10     http://c6401.ambari.apache.org:8080/resources//UnlimitedJCEPolicyJDK7.zip
-o /var/lib/ambari-agent/data/tmp/AMBARI-artifacts//UnlimitedJCEPolicyJDK7.zip'] due to not_if
2014-10-03 11:52:09,834 - Group['hadoop'] {'ignore_failures': False}
2014-10-03 11:52:09,835 - Modifying group hadoop
2014-10-03 11:52:09,862 - Group['users'] {'ignore_failures': False}
2014-10-03 11:52:09,863 - Modifying group users
2014-10-03 11:52:09,892 - User['hive'] {'gid': 'hadoop', 'ignore_failures': False, 'groups':
[u'hadoop']}
2014-10-03 11:52:09,892 - Modifying user hive
2014-10-03 11:52:09,903 - User['mapred'] {'gid': 'hadoop', 'ignore_failures': False, 'groups':
[u'hadoop']}
2014-10-03 11:52:09,904 - Modifying user mapred
2014-10-03 11:52:09,916 - User['ambari-qa'] {'gid': 'hadoop', 'ignore_failures': False, 'groups':
[u'users']}
2014-10-03 11:52:09,916 - Modifying user ambari-qa
2014-10-03 11:52:09,930 - User['zookeeper'] {'gid': 'hadoop', 'ignore_failures': False, 'groups':
[u'hadoop']}
2014-10-03 11:52:09,930 - Modifying user zookeeper
2014-10-03 11:52:09,943 - User['tez'] {'gid': 'hadoop', 'ignore_failures': False, 'groups':
[u'users']}
2014-10-03 11:52:09,943 - Modifying user tez
2014-10-03 11:52:09,955 - User['hdfs'] {'gid': 'hadoop', 'ignore_failures': False, 'groups':
[u'hadoop']}
2014-10-03 11:52:09,955 - Modifying user hdfs
2014-10-03 11:52:09,968 - User['yarn'] {'gid': 'hadoop', 'ignore_failures': False, 'groups':
[u'hadoop']}
2014-10-03 11:52:09,968 - Modifying user yarn
2014-10-03 11:52:09,980 - User['hcat'] {'gid': 'hadoop', 'ignore_failures': False, 'groups':
[u'hadoop']}
2014-10-03 11:52:09,980 - Modifying user hcat
2014-10-03 11:52:09,994 - File['/var/lib/ambari-agent/data/tmp/changeUid.sh'] {'content':
StaticFile('changeToSecureUid.sh'), 'mode': 0555}
2014-10-03 11:52:09,995 - Execute['/var/lib/ambari-agent/data/tmp/changeUid.sh ambari-qa /tmp/hadoop-ambari-qa,/tmp/hsperfdata_ambari-qa,/home/ambari-qa,/tmp/ambari-qa,/tmp/sqoop-ambari-qa
2>/dev/null'] {'not_if': 'test $(id -u ambari-qa) -gt 1000'}
2014-10-03 11:52:10,007 - Skipping Execute['/var/lib/ambari-agent/data/tmp/changeUid.sh ambari-qa
/tmp/hadoop-ambari-qa,/tmp/hsperfdata_ambari-qa,/home/ambari-qa,/tmp/ambari-qa,/tmp/sqoop-ambari-qa
2>/dev/null'] due to not_if
2014-10-03 11:52:10,008 - Directory['/etc/hadoop/conf.empty'] {'owner': 'root', 'group': 'root',
'recursive': True}
2014-10-03 11:52:10,009 - Link['/etc/hadoop/conf'] {'not_if': 'ls /etc/hadoop/conf', 'to':
'/etc/hadoop/conf.empty'}
2014-10-03 11:52:10,019 - Skipping Link['/etc/hadoop/conf'] due to not_if
2014-10-03 11:52:10,033 - File['/etc/hadoop/conf/hadoop-env.sh'] {'content': InlineTemplate(...),
'owner': 'hdfs'}
2014-10-03 11:52:10,044 - Execute['/bin/echo 0 > /selinux/enforce'] {'only_if': 'test -f
/selinux/enforce'}
2014-10-03 11:52:10,055 - Skipping Execute['/bin/echo 0 > /selinux/enforce'] due to only_if
2014-10-03 11:52:10,057 - Execute['mkdir -p /usr/lib/hadoop/lib/native/Linux-i386-32; ln -sf
/usr/lib/libsnappy.so /usr/lib/hadoop/lib/native/Linux-i386-32/libsnappy.so'] {}
2014-10-03 11:52:10,071 - Execute['mkdir -p /usr/lib/hadoop/lib/native/Linux-amd64-64; ln
-sf /usr/lib64/libsnappy.so /usr/lib/hadoop/lib/native/Linux-amd64-64/libsnappy.so'] {}
2014-10-03 11:52:10,083 - Directory['/var/log/hadoop'] {'owner': 'root', 'group': 'hadoop',
'mode': 0775, 'recursive': True}
2014-10-03 11:52:10,084 - Directory['/var/run/hadoop'] {'owner': 'root', 'group': 'root',
'recursive': True}
2014-10-03 11:52:10,084 - Directory['/tmp/hadoop-hdfs'] {'owner': 'hdfs', 'recursive': True}
2014-10-03 11:52:10,088 - File['/etc/hadoop/conf/commons-logging.properties'] {'content':
Template('commons-logging.properties.j2'), 'owner': 'hdfs'}
2014-10-03 11:52:10,090 - File['/etc/hadoop/conf/health_check'] {'content': Template('health_check-v2.j2'),
'owner': 'hdfs'}
2014-10-03 11:52:10,091 - File['/etc/hadoop/conf/log4j.properties'] {'content': '...', 'owner':
'hdfs', 'group': 'hadoop', 'mode': 0644}
2014-10-03 11:52:10,096 - File['/etc/hadoop/conf/hadoop-metrics2.properties'] {'content':
Template('hadoop-metrics2.properties.j2'), 'owner': 'hdfs'}
2014-10-03 11:52:10,096 - File['/etc/hadoop/conf/task-log4j.properties'] {'content': StaticFile('task-log4j.properties'),
'mode': 0755}
2014-10-03 11:52:10,097 - File['/etc/hadoop/conf/configuration.xsl'] {'owner': 'hdfs', 'group':
'hadoop'}
2014-10-03 11:52:10,206 - Directory['/etc/hive/conf.server'] {'owner': 'hive', 'group': 'hadoop',
'recursive': True}
2014-10-03 11:52:10,207 - XmlConfig['mapred-site.xml'] {'group': 'hadoop', 'conf_dir': '/etc/hive/conf.server',
'mode': 0644, 'configuration_attributes': ..., 'owner': 'hive', 'configurations': ...}
2014-10-03 11:52:10,223 - Generating config: /etc/hive/conf.server/mapred-site.xml
2014-10-03 11:52:10,223 - File['/etc/hive/conf.server/mapred-site.xml'] {'owner': 'hive',
'content': InlineTemplate(...), 'group': 'hadoop', 'mode': 0644, 'encoding': 'UTF-8'}
2014-10-03 11:52:10,225 - Writing File['/etc/hive/conf.server/mapred-site.xml'] because contents
don't match
2014-10-03 11:52:10,225 - File['/etc/hive/conf.server/hive-default.xml.template'] {'owner':
'hive', 'group': 'hadoop'}
2014-10-03 11:52:10,226 - File['/etc/hive/conf.server/hive-env.sh.template'] {'owner': 'hive',
'group': 'hadoop'}
2014-10-03 11:52:10,226 - File['/etc/hive/conf.server/hive-exec-log4j.properties'] {'content':
'...', 'owner': 'hive', 'group': 'hadoop', 'mode': 0644}
2014-10-03 11:52:10,227 - File['/etc/hive/conf.server/hive-log4j.properties'] {'content':
'...', 'owner': 'hive', 'group': 'hadoop', 'mode': 0644}
2014-10-03 11:52:10,227 - Directory['/etc/hive/conf'] {'owner': 'hive', 'group': 'hadoop',
'recursive': True}
2014-10-03 11:52:10,228 - XmlConfig['mapred-site.xml'] {'group': 'hadoop', 'conf_dir': '/etc/hive/conf',
'mode': 0644, 'configuration_attributes': ..., 'owner': 'hive', 'configurations': ...}
2014-10-03 11:52:10,238 - Generating config: /etc/hive/conf/mapred-site.xml
2014-10-03 11:52:10,238 - File['/etc/hive/conf/mapred-site.xml'] {'owner': 'hive', 'content':
InlineTemplate(...), 'group': 'hadoop', 'mode': 0644, 'encoding': 'UTF-8'}
2014-10-03 11:52:10,239 - Writing File['/etc/hive/conf/mapred-site.xml'] because contents
don't match
2014-10-03 11:52:10,240 - File['/etc/hive/conf/hive-default.xml.template'] {'owner': 'hive',
'group': 'hadoop'}
2014-10-03 11:52:10,240 - File['/etc/hive/conf/hive-env.sh.template'] {'owner': 'hive', 'group':
'hadoop'}
2014-10-03 11:52:10,241 - File['/etc/hive/conf/hive-exec-log4j.properties'] {'content': '...',
'owner': 'hive', 'group': 'hadoop', 'mode': 0644}
2014-10-03 11:52:10,241 - File['/etc/hive/conf/hive-log4j.properties'] {'content': '...',
'owner': 'hive', 'group': 'hadoop', 'mode': 0644}
2014-10-03 11:52:10,242 - Execute['hive mkdir -p /var/lib/ambari-agent/data/tmp/AMBARI-artifacts/
; cp /usr/share/java/mysql-connector-java.jar /usr/lib/hive/lib//mysql-connector-java.jar']
{'environment': ..., 'path': ['/bin', '/usr/bin/'], 'creates': '/usr/lib/hive/lib//mysql-connector-java.jar',
'not_if': 'test -f /usr/lib/hive/lib//mysql-connector-java.jar'}
2014-10-03 11:52:10,252 - Skipping Execute['hive mkdir -p /var/lib/ambari-agent/data/tmp/AMBARI-artifacts/
; cp /usr/share/java/mysql-connector-java.jar /usr/lib/hive/lib//mysql-connector-java.jar']
due to not_if
2014-10-03 11:52:10,253 - Execute['/bin/sh -c 'cd /usr/lib/ambari-agent/ && curl -kf
-x "" --retry 5 http://c6401.ambari.apache.org:8080/resources/DBConnectionVerification.jar
-o DBConnectionVerification.jar''] {'environment': ..., 'not_if': '[ -f DBConnectionVerification.jar]'}
2014-10-03 11:52:10,281 - File['/var/lib/ambari-agent/data/tmp/start_metastore_script'] {'content':
StaticFile('startMetastore.sh'), 'mode': 0755}
2014-10-03 11:52:10,283 - Execute['export HIVE_CONF_DIR=/etc/hive/conf.server ; /usr/lib/hive/bin/schematool
-initSchema -dbType mysql -userName hive -passWord [PROTECTED]'] {'not_if': 'export HIVE_CONF_DIR=/etc/hive/conf.server
; /usr/lib/hive/bin/schematool -info -dbType mysql -userName hive -passWord [PROTECTED]'}
2014-10-03 11:52:20,935 - Error while executing command 'start':
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py",
line 122, in execute
    method(env)
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive_metastore.py",
line 43, in start
    self.configure(env) # FOR SECURITY
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive_metastore.py",
line 38, in configure
    hive(name='metastore')
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive.py",
line 83, in hive
    not_if = check_schema_created_cmd
  File "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line 148, in __init__
    self.env.run()
  File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 149,
in run
    self.run_action(resource, action)
  File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 115,
in run_action
    provider_action()
  File "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", line
237, in action_run
    raise ex
Fail: Execution of 'export HIVE_CONF_DIR=/etc/hive/conf.server ; /usr/lib/hive/bin/schematool
-initSchema -dbType mysql -userName hive -passWord [PROTECTED]' returned 1. Metastore connection
URL:	 jdbc:derby:;databaseName=metastore_db;create=true
Metastore Connection Driver :	 org.apache.derby.jdbc.EmbeddedDriver
Metastore connection User:	 hive
Starting metastore schema initialization to 0.13.0
Initialization script hive-schema-0.13.0.mysql.sql
Error: Syntax error: Encountered "<EOF>" at line 1, column 64. (state=42X01,code=30000)
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore
state would be inconsistent !!
*** schemaTool failed ***


Diffs
-----

  ambari-server/src/main/resources/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive.py
67720e1 
  ambari-server/src/test/python/stacks/2.0.6/HIVE/test_hive_client.py 796e820 
  ambari-server/src/test/python/stacks/2.0.6/HIVE/test_hive_metastore.py 201b3f2 
  ambari-server/src/test/python/stacks/2.0.6/HIVE/test_hive_server.py 4fe131b 
  ambari-server/src/test/python/stacks/2.1/HIVE/test_hive_metastore.py 12e7439 

Diff: https://reviews.apache.org/r/26317/diff/


Testing
-------

manual tests 

+

Ran 229 tests in 1.595s

OK
----------------------------------------------------------------------
Total run:638
Total errors:0
Total failures:0
OK


Thanks,

Dmytro Sen


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message