[
https://issues.apache.org/jira/browse/AMBARI-6664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vitaly Brodetskyi resolved AMBARI-6664.
---------------------------------------
Resolution: Fixed
Committed to trunk
> Oozie service can not be started on Ambari server with external Postgres
> ------------------------------------------------------------------------
>
> Key: AMBARI-6664
> URL: https://issues.apache.org/jira/browse/AMBARI-6664
> Project: Ambari
> Issue Type: Bug
> Components: agent
> Affects Versions: 1.7.0
> Reporter: Vitaly Brodetskyi
> Assignee: Vitaly Brodetskyi
> Priority: Blocker
> Fix For: 1.7.0
>
>
> *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}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
