[
https://issues.apache.org/jira/browse/AMBARI-6066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vitaly Brodetskyi resolved AMBARI-6066.
---------------------------------------
Resolution: Fixed
Committed to trunk
> '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)
