You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by Vitalyi Brodetskyi <vb...@hortonworks.com> on 2014/06/10 15:21:06 UTC
Review Request 22417: 'Start Hive' operation shows error in case when Hive
DB is Oracle
-----------------------------------------------------------
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
Re: Review Request 22417: 'Start Hive' operation shows error in case when
Hive DB is Oracle
Posted by Dmitro Lisnichenko <dl...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/22417/#review45226
-----------------------------------------------------------
Ship it!
Ship It!
- Dmitro Lisnichenko
On June 10, 2014, 1:21 p.m., Vitalyi Brodetskyi wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/22417/
> -----------------------------------------------------------
>
> (Updated June 10, 2014, 1:21 p.m.)
>
>
> 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
>
>