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

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.6.1
• Fix Version/s: 1.6.1
• Component/s: ambari-agent
• Assignee: Vitaly Brodetskyi
• Reporter: Vitaly Brodetskyi
• Created: 10/Jun/14 13:16
• Updated: 10/Jun/14 13:55
• Resolved: 10/Jun/14 13:55

Description

Hive shows next error message during start/restart operation in case when Hive DB is Oracle:

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

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.

Issue Links

• links to: RequestBoard