[OOZIE-2136] Oozie server startup error when JDBC URL for a MySql DB with HA is used

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 5.3.0
• Component/s: core
• Labels: oozie
• Assignee: Dénes Bodó
• Reporter: Biju Nair
• Created: 10/Feb/15 16:43
• Updated: 22/Jun/21 11:48
• Resolved: 22/Jun/21 11:48

Description

Two instances of MySql DB is set-up on two nodes with HA. When tried to use the value jdbc:mysql://bcpc-vm1,bcpc-vm2:3306/oozie for the property oozie.service.JPAService.jdbc.url Oozie start-up fails. The URL format is as per MySql specification.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)

Issue Links

• relates to: OOZIE-2574 Oozie to support replication-enabled mysql urls