Biju Nair created OOZIE-2136:
--------------------------------
Summary: Oozie server startup error when JDBC URL for a MySql DB
with HA is used
Key: OOZIE-2136
URL: https://issues.apache.org/jira/browse/OOZIE-2136
Project: Oozie
Issue Type: Bug
Components: core
Reporter: Biju Nair
Two instances of MySql DB is set-up on two nodes with HA. When tried to use the
value {{<value>jdbc:mysql://bcpc-vm1,bcpc-vm2/oozie</value>}} for the property
{{<name>oozie.service.JPAService.jdbc.url</name>}} Oozie start-up fails. The
following is the error entry in the Oozie log.
2015-02-10 10:48:14,811 INFO HadoopAccessorService:543 - USER[-] GROUP[-]
TOKEN[-] APP[-] JOB[-] ACTION[-] final password is xHGotFJ3c6WxgojAGKZP
2015-02-10 10:48:15,525 FATAL Services:537 - Runtime Exception during Services
Load. Check your list of 'oozie.services' or 'oozie.services.ext'
2015-02-10 10:48:15,531 FATAL Services:537 - USER[-] GROUP[-] TOKEN[-] APP[-]
JOB[-] ACTION[-] E0103: Could not load service classes, Cannot create
PoolableConnectionFactory (No database selected)
org.apache.oozie.service.ServiceException: E0103: Could not load service
classes, Cannot create PoolableConnectionFactory (No database selected)
at org.apache.oozie.service.Services.loadServices(Services.java:306)
at org.apache.oozie.service.Services.init(Services.java:210)
at
org.apache.oozie.servlet.ServicesLoader.contextInitialized(ServicesLoader.java:45)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4709)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
at
org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at
org.apache.catalina.core.StandardService.start(StandardService.java:525)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: <openjpa-2.2.2-r422266:1468616 fatal general error>
org.apache.openjpa.persistence.PersistenceException: Cannot create
PoolableConnectionFactory (No database selected)
at
org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102)
at
org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603)
at
org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1518)
at
org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:531)
at
org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:456)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
