[jira] [Created] (AMBARI-6066) 'Start Hive' operation shows error in case when Hive DB is Oracle

["Vitaly Brodetskyi (JIRA)" <ji...@apache.org>]

Vitaly Brodetskyi created AMBARI-6066:
-----------------------------------------

             Summary: '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


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)