-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/22417/
-----------------------------------------------------------

Review request for Ambari and Dmitro Lisnichenko.


Bugs: AMBARI-6066
    https://issues.apache.org/jira/browse/AMBARI-6066


Repository: ambari


Description
-------

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.


Diffs
-----

  
ambari-server/src/main/resources/stacks/HDP/1.3.2/services/HIVE/package/scripts/hive_service.py
 f0b0b6b 
  
ambari-server/src/main/resources/stacks/HDP/1.3.2/services/OOZIE/package/scripts/oozie_service.py
 a31999d 
  
ambari-server/src/main/resources/stacks/HDP/2.0.6/services/HIVE/package/scripts/hive_service.py
 f0b0b6b 
  
ambari-server/src/main/resources/stacks/HDP/2.0.6/services/OOZIE/package/scripts/oozie_service.py
 a31999d 
  ambari-server/src/test/python/stacks/1.3.2/HIVE/test_hive_metastore.py 
31952ae 
  ambari-server/src/test/python/stacks/1.3.2/HIVE/test_hive_server.py 6c8d7d9 
  ambari-server/src/test/python/stacks/2.0.6/HIVE/test_hive_metastore.py 
d9bbb09 
  ambari-server/src/test/python/stacks/2.0.6/HIVE/test_hive_server.py cc7d021 
  ambari-server/src/test/python/stacks/2.1/HIVE/test_hive_metastore.py 5ab5744 

Diff: https://reviews.apache.org/r/22417/diff/


Testing
-------

----------------------------------------------------------------------
Ran 209 tests in 1.172s

OK
----------------------------------------------------------------------
Total run:565
Total errors:0
Total failures:0
OK


Thanks,

Vitalyi Brodetskyi

Reply via email to