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/07/30 13:03:53 UTC

Review Request 24094: Oozie service can not be started on Ambari server with external Postgres

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

Review request for Ambari and Dmitro Lisnichenko.


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


Repository: ambari


Description
-------

*STR:*
- Install single node cluster with Postgres 9 server as Ambari and Oozie DB (Stack - 2.0). Postgres server should be on dedicated host;
- Start all services.

*Actual result:* Oozie server will not start.

Error message for Oozie:
{noformat}
2014-07-23 08:42:57,947 - Error while executing command 'start':
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 111, in execute
    method(env)
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/OOZIE/package/scripts/oozie_server.py", line 43, in start
    oozie_service(action='start')
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/OOZIE/package/scripts/oozie_service.py", line 43, in oozie_service
    Execute( db_connection_check_command, tries=5, try_sleep=10)
  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/lib/oozie/libserver/postgresql-9.0-801.jdbc4.jar org.apache.ambari.server.DBConnectionVerification jdbc:postgresql://<host>:5432/ooziedb oozieuser [PROTECTED] org.postgresql.Driver' returned 1. ERROR: Unable to connect to the DB. Please check DB connection properties.
java.lang.ClassNotFoundException: org.postgresql.Driver
{noformat}


Diffs
-----

  ambari-server/src/main/resources/stacks/HDP/1.3.2/services/OOZIE/package/scripts/params.py 299d937 
  ambari-server/src/main/resources/stacks/HDP/2.0.6/services/OOZIE/package/scripts/oozie_service.py 2be172b 
  ambari-server/src/test/python/stacks/2.0.6/OOZIE/test_oozie_server.py c8aca2e 

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


Testing
-------

----------------------------------------------------------------------
Ran 216 tests in 1.832s

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


Thanks,

Vitalyi Brodetskyi


Re: Review Request 24094: Oozie service can not be started on Ambari server with external Postgres

Posted by Dmitro Lisnichenko <dl...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/24094/#review49097
-----------------------------------------------------------

Ship it!


Ship It!

- Dmitro Lisnichenko


On July 30, 2014, 11:03 a.m., Vitalyi Brodetskyi wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/24094/
> -----------------------------------------------------------
> 
> (Updated July 30, 2014, 11:03 a.m.)
> 
> 
> Review request for Ambari and Dmitro Lisnichenko.
> 
> 
> Bugs: AMBARI-6664
>     https://issues.apache.org/jira/browse/AMBARI-6664
> 
> 
> Repository: ambari
> 
> 
> Description
> -------
> 
> *STR:*
> - Install single node cluster with Postgres 9 server as Ambari and Oozie DB (Stack - 2.0). Postgres server should be on dedicated host;
> - Start all services.
> 
> *Actual result:* Oozie server will not start.
> 
> Error message for Oozie:
> {noformat}
> 2014-07-23 08:42:57,947 - Error while executing command 'start':
> Traceback (most recent call last):
>   File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 111, in execute
>     method(env)
>   File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/OOZIE/package/scripts/oozie_server.py", line 43, in start
>     oozie_service(action='start')
>   File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/OOZIE/package/scripts/oozie_service.py", line 43, in oozie_service
>     Execute( db_connection_check_command, tries=5, try_sleep=10)
>   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/lib/oozie/libserver/postgresql-9.0-801.jdbc4.jar org.apache.ambari.server.DBConnectionVerification jdbc:postgresql://<host>:5432/ooziedb oozieuser [PROTECTED] org.postgresql.Driver' returned 1. ERROR: Unable to connect to the DB. Please check DB connection properties.
> java.lang.ClassNotFoundException: org.postgresql.Driver
> {noformat}
> 
> 
> Diffs
> -----
> 
>   ambari-server/src/main/resources/stacks/HDP/1.3.2/services/OOZIE/package/scripts/params.py 299d937 
>   ambari-server/src/main/resources/stacks/HDP/2.0.6/services/OOZIE/package/scripts/oozie_service.py 2be172b 
>   ambari-server/src/test/python/stacks/2.0.6/OOZIE/test_oozie_server.py c8aca2e 
> 
> Diff: https://reviews.apache.org/r/24094/diff/
> 
> 
> Testing
> -------
> 
> ----------------------------------------------------------------------
> Ran 216 tests in 1.832s
> 
> OK
> ----------------------------------------------------------------------
> Total run:571
> Total errors:0
> Total failures:0
> OK
> 
> 
> Thanks,
> 
> Vitalyi Brodetskyi
> 
>