You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Vitaly Brodetskyi (JIRA)" <ji...@apache.org> on 2014/06/10 15:20:03 UTC
[jira] [Updated] (AMBARI-6066) 'Start Hive' operation shows error
in case when Hive DB is Oracle
[ https://issues.apache.org/jira/browse/AMBARI-6066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vitaly Brodetskyi updated AMBARI-6066:
--------------------------------------
Attachment: AMBARI-6066.patch
> 'Start Hive' operation shows error in case when Hive DB is Oracle
> -----------------------------------------------------------------
>
> Key: AMBARI-6066
> URL: https://issues.apache.org/jira/browse/AMBARI-6066
> Project: Ambari
> Issue Type: Bug
> Components: agent
> Affects Versions: 1.6.1
> Reporter: Vitaly Brodetskyi
> Assignee: Vitaly Brodetskyi
> Priority: Critical
> Fix For: 1.6.1
>
> Attachments: AMBARI-6066.patch
>
>
> Hive shows next error message during start/restart operation in case when Hive DB is Oracle:
> {noformat}
> 2014-06-02 16:23:18,079 - Error while executing command 'restart':
> Traceback (most recent call last):
> File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 112, in execute
> method(env)
> File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 214, in restart
> self.start(env)
> File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive_metastore.py", line 44, in start
> action = 'start'
> File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive_service.py", line 55, in hive_service
> path='/usr/sbin:/sbin:/usr/local/bin:/bin:/usr/bin')
> 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/jdk64/jdk1.7.0_45/bin/java -cp /usr/lib/ambari-agent/DBConnectionVerification.jar:/usr/share/java/ojdbc6.jar org.apache.ambari.server.DBConnectionVerification jdbc:oracle:thin:@//c6404.ambari.apache.org:1521/XE hiveuser password oracle.jdbc.driver.OracleDriver' returned 1. ERROR: Unable to connect to the DB. Please check DB connection properties.
> java.sql.SQLRecoverableException: IO Error: Connection reset
> {noformat}
> Same situation reproduced in both cases when *Ambari* DB is Oracle or Postgres embedded.
> *Note:* there were several attempts to connect to DB from internal cluster hosts and other hosts. All of them were successfull, but connection time from internal hosts was much longer, than others.
--
This message was sent by Atlassian JIRA
(v6.2#6252)