ambari-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adhi Tj <milis.tja...@gmail.com>
Subject Re: Hive service not starting
Date Mon, 09 Nov 2015 01:37:33 GMT
I have problem too. I fix it with flush privileges to hive database. If you
have same problem i think you must backup your hive database and delete
your hive database. Try to running your service again.

Best regards
On Nov 5, 2015 7:07 PM, "Steve Howard" <stevedhoward@gmail.com> wrote:

> MySQL has differing user permissions based on the origin of the request.
> Ambari should do this for you when it connects as a privileged user, but
> try connecting as root to MySQL, then issue...
>
>
> grant all on hive.* to 'hive@'your_ambari_host_ip' identified by
> 'your_hive_password';
> flush privileges;
>
> On Thu, Nov 5, 2015 at 6:06 AM, Kaliyug Antagonist <
> kaliyugantagonist@gmail.com> wrote:
>
>> I have installed HDP 2.3 using Ambari 2.1.2.
>>
>> When I attempt to start the Hive Metastore, I get :
>>
>> stderr:   /var/lib/ambari-agent/data/errors-811.txt
>>
>> 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 219, in <module>
>>     HiveMetastore().execute()
>>   File
>> "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py",
>> line 219, in execute
>>     method(env)
>>   File
>> "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py",
>> line 55, in start
>>     self.configure(env)  # FOR SECURITY
>>   File
>> "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py",
>> line 66, 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 152, in run
>>     self.run_action(resource, action)
>>   File
>> "/usr/lib/python2.6/site-packages/resource_management/core/environment.py",
>> line 118, in run_action
>>     provider_action()
>>   File
>> "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py",
>> line 260, 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 hive -passWord [PROTECTED]' returned 1. WARNING: Use "yarn jar"
>> to launch YARN applications.
>> Metastore connection URL: jdbc:mysql://
>> l1033lab.sss.se.company.com:3306/hive?createDatabaseIfNotExist=true
>> Metastore Connection Driver : com.mysql.jdbc.Driver
>> Metastore connection User: hive
>> org.apache.hadoop.hive.me
>>
>>
>> In the Hive config., I have selected 'New MySQL database'.
>>
>> On the machine l1033lab, there is a MySQL running :
>>
>>
>> [root@l1033lab ~]# mysql -u hive
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 441
>> Server version: 5.1.73 Source distribution
>>
>> Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights
>> reserved.
>>
>> Oracle is a registered trademark of Oracle Corporation and/or its
>> affiliates. Other names may be trademarks of their respective
>> owners.
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>> statement.
>>
>> mysql>
>> mysql>
>> mysql> select
>> User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv from
>> mysql.user;
>>
>> +------+-------------+-------------+-------------+-------------+-------------+
>> | User | Select_priv | Insert_priv | Update_priv | Delete_priv |
>> Create_priv |
>>
>> +------+-------------+-------------+-------------+-------------+-------------+
>> | root | Y           | Y           | Y           | Y           | Y
>>     |
>> | root | Y           | Y           | Y           | Y           | Y
>>     |
>> | root | Y           | Y           | Y           | Y           | Y
>>     |
>> | hive | Y           | Y           | Y           | Y           | Y
>>     |
>>
>> +------+-------------+-------------+-------------+-------------+-------------+
>> 4 rows in set (0.00 sec)
>>
>> mysql>
>> mysql> show databases;
>> +--------------------+
>> | Database           |
>> +--------------------+
>> | information_schema |
>> | mysql              |
>> | test               |
>> +--------------------+
>> 3 rows in set (0.00 sec)
>>
>> How shall I proceed ?
>>
>>
>>
>

Mime
View raw message