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 (JIRA)" <ji...@apache.org> on 2014/04/02 21:38:14 UTC
[jira] [Resolved] (AMBARI-5327) Hive start fails on centos5
[ https://issues.apache.org/jira/browse/AMBARI-5327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dmytro Sen resolved AMBARI-5327.
--------------------------------
Resolution: Fixed
Committed to trunk
> Hive start fails on centos5
> ---------------------------
>
> Key: AMBARI-5327
> URL: https://issues.apache.org/jira/browse/AMBARI-5327
> Project: Ambari
> Issue Type: Bug
> Components: controller
> Affects Versions: 1.5.1
> Environment: CentOS5
> Reporter: Dmytro Sen
> Assignee: Dmytro Sen
> Fix For: 1.5.1
>
>
> {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
--
This message was sent by Atlassian JIRA
(v6.2#6252)