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 Sen <ds...@hortonworks.com> on 2014/04/02 21:27:57 UTC
Review Request 19954: Hive start fails on centos5
-----------------------------------------------------------
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
Re: Review Request 19954: Hive start fails on centos5
Posted by Dmitro Lisnichenko <dl...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/19954/#review39336
-----------------------------------------------------------
Ship it!
Ship It!
- Dmitro Lisnichenko
On April 2, 2014, 7:27 p.m., Dmytro Sen wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/19954/
> -----------------------------------------------------------
>
> (Updated April 2, 2014, 7:27 p.m.)
>
>
> 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
>
>