-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/19954/
-----------------------------------------------------------
Review request for Ambari and Dmitro Lisnichenko.
Bugs: AMBARI-5327
https://issues.apache.org/jira/browse/AMBARI-5327
Repository: ambari
Description
-------
{noformat}
2014-04-02 13:18:58,284 - Error while executing command 'start':
Traceback (most recent call last):
File
"/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py",
line 95, in execute
method(env)
File
"/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive_metastore.py",
line 42, 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 37, in configure
hive(name='metastore')
File
"/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive.py",
line 94, 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 239, in action_run
raise ex
Fail: Execution of '/usr/lib/hive/bin/schematool -initSchema -dbType mysql
-userName hive -passWord asd' returned 1. Metastore connection URL:
jdbc:mysql://c5901.ambari.apache.org/hive?createDatabaseIfNotExist=true
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User: hive
Starting metastore schema initialization to 0.13.0
Initialization script hive-schema-0.13.0.mysql.sql
Error: You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'USING HASH' at
line 1 (state=42000,code=1064)
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization
FAILED! Metastore state would be inconsistent !!
*** schemaTool failed ***
{noformat}
MySQL version:
{noformat}
[root@c5901 ~]# rpm -qa | grep mysql
mysql-connector-java-5.1.12-2.el5
mysql-server-5.0.95-5.el5_9
mysql-5.0.95-5.el5_9
{noformat}
HDP 2.1
Diffs
-----
ambari-server/src/main/resources/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive.py
f351087
ambari-server/src/test/python/stacks/2.1/HIVE/test_hive_metastore.py 79482eb
Diff: https://reviews.apache.org/r/19954/diff/
Testing
-------
All tests passed
Thanks,
Dmytro Sen
